Post reply

upgrade from SQL 2005 to SQL 2014

  • December 19, 2016 at 2:43 am

    #319856

    I'm trying to upgrade from SQL 2005 to SQL 2014. I wanted to know is it a 2 step process or not.

    If it is a 2 step process what are the steps..

    Please help on this

  • December 19, 2016 at 2:45 am

    #1918624

    In-place upgrade (not recommended) or side-by-side/new server?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 19, 2016 at 2:47 am

    #1918626

    You'll probably want an OS upgrade too- I'd avoid doing an in-place upgrade, as already mentioned.

  • December 19, 2016 at 2:52 am

    #1918627

    Hi,

    Check the Upgrade-List table in this link https://msdn.microsoft.com/en-us/library/ms143393(v=sql.120).aspx

    I'd also skip in-place upgrade and do it with a new installation of SQL Server 2104.

    Do you still need the same instance name?

    Igor Micev,
    My blog: www.igormicev.com

  • December 19, 2016 at 2:52 am

    #1918628

    Hi GilaMonster/Beatrix Kiddo

    Thanks for your response. can this be upgraded directly to SQL 2014?

  • December 19, 2016 at 2:53 am

    #1918629

    Hi Igor,

    Same name needed

  • December 19, 2016 at 2:56 am

    #1918630

    atulyan.aries (12/19/2016)

    Hi GilaMonster/Beatrix Kiddo

    Thanks for your response. can this be upgraded directly to SQL 2014?

    We've both just advised you not to. Have you got a test environment?

  • December 19, 2016 at 3:02 am

    #1918631

    atulyan.aries (12/19/2016)

    Hi Igor,

    Same name needed

    Ok, I also wanted to appoint considering the renaming. You can find many posts about it.

    Igor Micev,
    My blog: www.igormicev.com

  • December 19, 2016 at 3:07 am

    #1918632

    atulyan.aries (12/19/2016)

    Thanks for your response. can this be upgraded directly to SQL 2014?

    No, and in-place upgrades are not a good idea for production systems (plus there's the small matter of the OS probably being too old for SQL 2014)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 19, 2016 at 7:35 am

    #1918674

    I agree with what everyone else is recommending.

    I would like to note that if you're asking if you have to restore to 2008 or 2012 or something, the answer is no. You can restore/attach a 2005 database to a 2014 instance. The database will be upgraded by that process. You can then, as appropriate, adjust the compatibility level.

    None of this changes the rest of the recommendations.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Viewing 10 posts - 1 through 9 (of 9 total)

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