October 7, 2010 at 6:31 am
Hi,
What is the best way to manage the upgrade SQL Server 2000 to 2008?
Thanks
ananda
October 7, 2010 at 8:11 am
ananda.murugesan (10/7/2010)
Hi,What is the best way to manage the upgrade SQL Server 2000 to 2008?
Thanks
ananda
hi
Here are some of the ways of upgrade
In-place Upgrade
Side by Side Upgrade
Detach/Attach
Copy Database Wizard
Manual Schema Rebuild and Data Export/Import
Choosing upgrade method
The two upgrade methods discussed above have several different advantages and disadvantages with it as given below, we have to evaluate it in terms of our requirements and current circumstances before moving for upgrade.
In-place Upgrade Advantages:
It's easier and faster, especially in small systems.
It's mostly an automated process.
The instance will be offline for a minimum amount of time.
The resulting instance after upgrade will have the same name as the original, as the new setup will replace the older version.
No additional hardware is required in many cases.
o Disadvantages:
It's very complex to rollback.
Not applicable in scenarios where we want to upgrade a part of system like upgrading just one single databases.
We cannot run an upgrade comparison after doing the upgrade.
Side by Side Upgrade
o Advantages:
More control over the upgrade, as we can upgrade the components, which we want to.
We can keep our application running even when we are installing SQL 2008 as the old instance or server will be available.
Easy to do a rollback as the original database server is untouched.
In-place Upgrade Disadvantages:
We might need additional hardware resources in terms of disk space, CPU and RAM.
Manual intervention is required to migrate databases, Jobs, logins etc.
There will be change in configuration settings, which are used by the application to connect to the database.
More time is required while moving VLDB to the new version of database.
also check
http://www.sqlservercentral.com/articles/Upgrade/65872/
Thanks
Parthi
Thanks
Parthi
October 7, 2010 at 9:05 am
If you have separate hardware, use the side by side. That way you can roll back if you have issues.
October 7, 2010 at 1:13 pm
I'm a huge fan of side-by-side upgrades. So far, knock wood, I haven't had a single 2008 upgrade go wrong, but if one did, having the 2000 server sitting there waiting means I have minimal downtime on my systems.
"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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply