August 20, 2002 at 8:50 am
Please let me know what is the easiest way to migrate database in its entirety from sqlserver7 to sqlserver2000 including all tables, storedprocedures, views,users. Is there something i need to be cautious about?
suggestions are appreciated.
August 22, 2002 at 12:03 pm
I migrated from 6.5 to 7. It seemed as though getting the users setup was a much needed first step. The transition from 7 to 2000 may be easier because of DTS. If nothing else you could script out stuff from 7 create it on 2000 and then migrate the data. Good luck 🙂
Bruce Szabo, MCSE+I, MCDBA, MCSD
Bruce Szabo, MCSE+I, MCDBA, MCSD
August 26, 2002 at 3:58 pm
You can also use the Copy Database Wizard. I didn't have any problems with Logins when I used this. Also, it copied my scheduled jobs as well. The only thing that I couldn't copy was the DTS packages, but I was able to use Access to copy the records from sysdtspackages in MSDB fast.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply