June 9, 2008 at 11:41 am
Hey y'all, I'm looking to migrate several databases on SQL 7 and SQL 2000 to a new SQL 2005 box. Has anyone done such a migration? What would you recommend as a good methodology for it? Also, should I expect stored procedures, triggers, indexes, other complementary stuff to break? I'd love to hear about your migration experiences.
June 9, 2008 at 12:12 pm
Hi alnguyen386,
I have done migration for nearly 20-30 databases.I did with backup and restore method.You need not to worry about the data,restore will takecare about that data,stored procedures,Triggers,Functions.Some of the functionalities may be break down in 2005 (EX:Compatablity changes,T-SQL Changes).I suggest you to run up grade advisor before restoring databases,After completing that run click view report their you will see one error stating something like this 'Other Database Engine upgrade issues'.Click Tell me more about this that will list you breaking functonalities between earlier versions and SQL server 2005.Make sure maintain backups before migrating.You might be face orphaned users problem after restoration of databases.
Wish you good luck...........
June 9, 2008 at 5:37 pm
If you transfer the logins using the SP_HELP_REVLOGIN stored procedure, you would not get orphaned users as it recreates the logins with the original SID
Link to the sp script: http://support.microsoft.com/kb/246133
June 9, 2008 at 7:01 pm
Have a look at all the below links. The upgradation procedure is same as that of Sql 2000 to Sql 2005. The steps are mentioned in the below links.
http://www.sqlservercentral.com/columnists/ssamuel/2987.asp --- Inplace upgrade
http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en --- Upgrade Document for SQL Server
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2534409&SiteID=1 - Upgrade from Sql 2000 to Sql 2005
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2477578&SiteID=1 - Upgrade from Sql 2000 to Sql 2005
[font="Verdana"]- Deepak[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply