September 24, 2006 at 10:28 am
I was wondering if anyone tried it. I have a database on SQL 2005, but have a need to move it to 2000. The compatibility level is 80. Can I simply detach it and attach it to 2000 version? What would you suggest? I know I cannot restore a backup because 2000 won't take it.
Thanks.
September 24, 2006 at 6:06 pm
Nope. Even with the compatibility level is 80, it won't work. You'd have to script out the structure of the database (reviewing the script for syntactical differences between 2000 and 2005) and use Integration Services to move the data.
The copy database function won't do it either (hello, MS, that would be a nice addition - just back to SQL 2000 please).
September 25, 2006 at 9:30 am
You can submit feedback directly to the SQL Server team @: https://connect.microsoft.com/SQLServer/Feedback
Cheers,
Dan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply