April 28, 2012 at 9:15 pm
Hi,
can any one say plz what is the advantage of side by side upgradation/migration.
Thanks in advance
April 29, 2012 at 4:47 am
So easy to google this one.
The main advantage though, in my opinion, is the ability to roll back to the old server in event of some issue with migration. All the planning in the world can't plan for the unexpected.
It can also be quicker. Lets say you've got a 5TB database, with a side by side migration you can set up a logship months in advance. All you have to do no migration day is apply the last log file and change connection strings. Minutes and not hours.
An in place upgrade isnt so simple. If you fail you have to uninstall, clean up, reinstall the old version of sql, apply logins/permissions/restore backups etc etc. The upgrade process can take many hours as well.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply