Post reply

migrating SQL Enterprise 2008 SP 2 to SQL 2014 Developer

  • January 11, 2018 at 8:30 am

    #327132

    Good day,
    I was checking the possible upgrade path from microsoft and it seems i cannot upgrade enterprise to developer edition.I want to go for developer because of license costs.Its not a production server.
    Anyone who did it before?

  • January 11, 2018 at 9:09 am

    #1975532

    For that you'll need to uninstall 2008 and then install 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

  • January 11, 2018 at 6:46 pm

    #1975661

    tmmutsetse - Thursday, January 11, 2018 8:30 AM

    Anyone who did it before?

    I did that many times. I used side by side migration for this purpose. In the nutshell steps are:
    1. Install the new server
    2. Set up database log shipping between old and new server
    3. Switch the application to the new server
    4. Decommission the old server

  • January 12, 2018 at 1:50 am

    #1975682

    Thank you i will try it

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

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