August 13, 2008 at 10:22 am
Hi sorry if this is a really stupid question, but....
Is it as simple as detaching your databases - uninstalling SQL 2000 - installing SQL 2005 and then reattaching your databases?
Thanks for any help given
Craig
August 13, 2008 at 10:38 am
That's one way to do it. You could also backup the SQL 2000 databases and restore in SQL 2005 or upgrade in place. I recommend referencing "Upgrading to SQL Server 2005" in BOL http://msdn.microsoft.com/en-us/library/ms144245.aspx. I think it's especially important to think about a fallback strategy if there's a problem with the upgrade/migration. Also, use Upgrade Advisor (explained in the above reference) to prepare for the upgrade.
Greg
August 13, 2008 at 11:34 am
You'll want to rebuild all your indexes and update the space usages after you move it.
But before you move it, use the Upgrade Advisor as mentioned above. There may be deprecated code in your existing database.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 14, 2008 at 1:09 am
Thanks for the replies, both very helpful
August 17, 2008 at 12:27 pm
i always favour migrating to a clean install rather than upgrade existing instances
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2008 at 12:39 pm
I agree with Christian. It should be simple, but if you have issues, you don't want your current installation gone if you can avoid it.
Be sure you have good backups of all current dbs, including system dbs, and you note the current SQL 2000 version number, so you know what to reinstall if you need it (SPs + patches).
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply