August 30, 2004 at 12:43 am
Guys, i no that u cant restore a db that was backed up in sql 2000 to sql 7. But i need 2 move a datase from sql 2000 to sql 7. Do u guys have any idea on how to go about doing this. I've run out of ideas now so i really need your help.
Thanks guys
August 30, 2004 at 7:31 am
Change the compatibility level of the DB to 7.0 (SQL 7). You should then be able to generate the code scripts required to rebuild the database on your other server and then DTS EXPORT the data to the SQL 7 box.
I am sure there is an easier way but, I think this way should work for you.
Please note that IF you have developed any code that uses table variables, SCHEMABOUND views, etc.. that were introduced in SQL 2K then this probably won't work.
Good Hunting!
AJ Ahrens
webmaster@kritter.net
August 31, 2004 at 12:31 am
I just tried yesterday using DTS from SQL 2000 and exported in SQL 7 which worked successfully.
Harsh Parekh
(India)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply