sql 2000 to sql 2005 -- sql server new users

CB
3/29/2006 8:30:03 AM

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.

[quoted text, click to view]

c_shah
3/29/2006 8:37:15 AM

script you entire db in SQL 2005, run those sripts in the SQL 2000
and use SSIS to tranfer data from 2005 to 2000

Chirag Shah

John
3/29/2006 5:06:10 PM

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

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

sql server new users : sql 2000 to sql 2005