Migration from SQL SERVER 7.0 to SQL SERVER 2000
-
Hello guys!
I am a junior DBA in one firm and we are planning to migrate our databases from SQL SERVER 7.0 to SQL SERVER 2000. Here is the situation:
Old system
OS : Windows NT 4.0
Database server : SQL SERVER 7.0
New system
OS : Windows Server 2003
Database server : SQL SERVER 2000
I would like to have ideas about the requirements and the process of migrating from the old system to the new one.
Many thanks and good day to all!
Kindest Regards,Aboubakar Alhadji Ibrahim
-
If you wanted to migrate only the user databases, just take a backup of those databases and restore it in the SQL 2000 server.
subban -
You should convert your Dev databases before your Test, and Test before Production. It is a few years since we converted from SQL7/NT4 to SQL2000/W2003, and there were a few issues mainly with Windows security that needed to be resolved, but these could be site-specific.
If you want to send me a private message with your email address, I can send you routines to script your logins, jobs, operators, alerts, user messages, DTS packages. You should not attempt to restore the SQL7 system databases into SQL 2000, so anything in those databases must be scripted out of SQL7 and into SQL2000. Most of these scripts were written to convert from SQL2000 to SQL2005, but they should work in SQL7.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
-
If I remember correctly, I just detached the 7 databases and attached them in 2000. There were some login issues I had to deal as well. It seems that there might have been some issues with the log file, but I don't quite remember anymore.
Steve
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply