Home Forums SQL Server 2014 Administration - SQL Server 2014 Sql server 2005 --> 2014 upgrade. Risks/things to consider/etc... RE: Sql server 2005 --> 2014 upgrade. Risks/things to consider/etc...

  • April 1, 2015 at 8:36 am

    #1788033

    Thanks for the post Grant. Nice. Here is my updated list therefore:

    0. On the *separate* target box install Sql Server 2014

    1. Upgrade to Sql Server 2005 SP4 if not done so already (on source box)

    2. Assess the code in 2005 using the Upgrade Advisor in 2014

    3. Assuming all is resonably well with step #3

    3.1 Backup 2005

    3.2 Restore to 2014 (NB: Strongly consider log shipping to keep things up-to-date between the 2 boxes)

    4. Test 2014 (sprocs/views/SSIS/packages)

    5. Assuming all well with #4 point the application at the new server and test If any problems change the compat mode on 2014 to ??? to assist.