Upgrade/Migrate SQL Server 2008 std to SQL Server 2014

  • 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

  • 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...

  • 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

  • check this in Detail :https://msdn.microsoft.com/en-us/library/bb677622.aspx

    Regards,
    Shivrudra W

  • 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.

    http://blogs.technet.com/b/sqlman/archive/2014/12/17/sql-server-2014-upgrade-technical-guide-now-available.aspx

  • Hi DeWayne,

    Thank you and much appreciated 🙂

    This was awesome, will go through the document.

    And Once again thank you!

    Regards,

    Raj

  • 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