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 Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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