sql 2000 to sql 2005

29 Mar 2006 4:06 PM

John

Hi

How can I move a sql 2005 db (data and all) to sql server 2000? I have made
the mistake of developing on sql server 2005 and now found out that
production server is still 2000.

Thanks

Regards

29 Mar 2006 4:30 PM

CB

I'm somewhat sure you cannot backup & restore a 2005 to 2000, nor can you
detach/reattach. You'll need to script out your stuff, move it over, or
perhaps create an SSIS package to move the objects & data.

Show quote

"John" wrote:

> Hi
>
> How can I move a sql 2005 db (data and all) to sql server 2000? I have made
> the mistake of developing on sql server 2005 and now found out that
> production server is still 2000.
>
> Thanks
>
> Regards
>
>
>