January 22, 2015 at 1:44 am
Hi Gents,
Can any one help/suggest me the best practice/approach on how to upgrade/migrate SQL Server 2008 std to SQL Server 2014 please?
1. In-place upgrade
2. Side-by-Side upgrade
January 22, 2015 at 2:05 am
Below is for your information..... It may be depends on Server Envioronmrnt also....
1. In-place upgrade
Easy to implement
no need to configure Applications...
No Backup & Restore
No logins for Users & Apps and etc...
2. Side-by-Side upgrade
Complete rebuild from Installation and then restore the Backups of SQL 2008 and Restore logins
Configure all applications and etc
Complete cross check for each & every step...
January 22, 2015 at 2:42 am
Hi Sasi,
That's great. Thank you very much for the quick reply.
I've no experience in upgrading/migration side. Can you please give me some links to verify?
Thanks,
Raj
January 22, 2015 at 4:12 am
check this in Detail :https://msdn.microsoft.com/en-us/library/bb677622.aspx
Regards,
Shivrudra W
January 22, 2015 at 2:01 pm
Check out the SQL Server 2014 Upgrade Technical Guide. Don't let the title fool you as this is also for 2005, 2K8, 2K8R2, 2012 and 2014.
January 22, 2015 at 11:12 pm
Hi DeWayne,
Thank you and much appreciated 🙂
This was awesome, will go through the document.
And Once again thank you!
Regards,
Raj
January 24, 2015 at 6:43 am
Pulivarthi Sasidhar (1/22/2015)
Below is for your information..... It may be depends on Server Envioronmrnt also....1. In-place upgrade
Easy to implement
no need to configure Applications...
No Backup & Restore
No logins for Users & Apps and etc...
2. Side-by-Side upgrade
Complete rebuild from Installation and then restore the Backups of SQL 2008 and Restore logins
Configure all applications and etc
Complete cross check for each & every step...
I don't agree completely with this assessment at all.
You're modifying your databases in place while you modify your server in place. If either goes wrong, you've lost everything. That's the most important place to have good backups. Also, in terms of configuring Applications, I assume you mean changing connection strings. You're right, but any upgrade will require you to test apps, so the cross check on each and every step that you're "avoiding" with the in place upgrade, you still have to do all of it.
The side-by-side upgrade is a lot more work, but a lot safer. If anything goes wrong, the old server is sitting there waiting for you. The in-place upgrade is less work, but is also inherently less safe. If anything goes wrong, you may have to rebuild your server from scratch as well as restore all your databases.
"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 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply