upgrading SQL Server 2016 express to 2016 Enterprise

  • I am considering upgrading SQL Server 2016 express to 2016 Enterprise.
    Is it possible to just upgrade, without creating a different instance/server name
    and keeping all databases that I currently have in Express version?

    Likes to play Chess

  • VoldemarG - Wednesday, November 21, 2018 11:22 AM

    I am considering upgrading SQL Server 2016 express to 2016 Enterprise.
    Is it possible to just upgrade, without creating a different instance/server name
    and keeping all databases that I currently have in Express version?

    Yes. Edition upgrades are done using setup.exe (SQL Server Installation Center), select maintenance and then Edition Upgrade.
    Upgrade to a Different Edition of SQL Server (Setup)

    Sue

  • If you wade through this document, you will find that this is a supported upgrade, so the short answer to your question is 'yes'.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • You can go up in term of edition, but you can't go down.

    I would be curious to know a business case that requires an upgrade from Express to Entreprise.

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

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