Unanswered: upgrade \ migration question sql server 2000 to 2005
We have A SQL Server 2000 Server with Several Instances and a seperate SQL Server 2005 Server built out with the same instances and I have been migrated databases from 2000 to 2005 by scripting out the logins on the 2000 server and recreating them on the 2005 server and then doing a backup and restore (2000 to 2005)
So far this has worked great.
is there ever a need to actually do an upgrade as opposed to restoring a 2000 database to 2005? I thought that a migration of sorts took place when you did the restore? can anyone explain?
I assume you are using sp_help_revlogins to do the scripting for you?
"is there ever a need to actually do an upgrade as opposed to restoring a 2000 database to 2005?" - well, kinda. The problem with doing it this way is that, 999 times out of 1000, you are moving to a new machine (bigger, better hardware) so it's a migration instead of an upgrade. So is it likely that people do upgrades? Sure - happens all the time when Big Software Vendor tells Little Client that they must use SQL 2005 yet Little Client doesn't want to buy new hardware.
But that's not likely happening in a 500GB database situation!