Post reply

SQL 2005 to SQL 2014 Migration

  • January 27, 2017 at 10:30 am

    #339743

    Hi There

    I am planning to migrate SQL 2005 databases to 2014. As per MSDN Sql 2005 should be sp4 before going to 2014

    1. Any one migrated 2005 SP3 or earlier builds migrated to 2014?

    2. Is there any script / table to check supported versions in master database? 

    3. Any major differences between 2012 and 2014 on older versions migrations?

    Thanks in advance

  • January 27, 2017 at 10:38 am

    #1925402

    Start off by running the "Upgrade Advisor".

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • January 27, 2017 at 10:41 am

    #1925404

    phani404 - Friday, January 27, 2017 10:30 AM

    Hi There

    I am planning to migrate SQL 2005 databases to 2014. As per MSDN Sql 2005 should be sp4 before going to 2014

    1. Any one migrated 2005 SP3 or earlier builds migrated to 2014?

    2. Is there any script / table to check supported versions in master database? 

    3. Any major differences between 2012 and 2014 on older versions migrations?

    Thanks in advance

    Questions, are you going to run an upgrade on the SQL Server 2005 to 2014 or is this a new instance of SQL Server 2014? Why not go to 2016?
    😎

  • January 27, 2017 at 10:43 am

    #1925406

    Eirikur Eiriksson - Friday, January 27, 2017 10:41 AM

    phani404 - Friday, January 27, 2017 10:30 AM

    Hi There

    I am planning to migrate SQL 2005 databases to 2014. As per MSDN Sql 2005 should be sp4 before going to 2014

    1. Any one migrated 2005 SP3 or earlier builds migrated to 2014?

    2. Is there any script / table to check supported versions in master database? 

    3. Any major differences between 2012 and 2014 on older versions migrations?

    Thanks in advance

    Questions, are you going to run an upgrade on the SQL Server 2005 to 2014 or is this a new instance of SQL Server 2014? Why not go to 2016?
    😎

    New instance only... 

    First i will run Upgrade advisory.. but want to know is there any way to query supported versions from sys database?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply