Upgrade SQL Server Edition

Hrishikesh Lele 1 Reputation point
2021-02-26T03:38:18.727+00:00

Hello,
I want to upgrade my Sql server 2014 Express to Sql server 2014 Enterprise. I have the databases, user securities, log paths setup for my project using Express.
Are there any special precautions to be taken before upgrading the edition? Does upgrading editions affect the database design or user securities or any relevant configuration in any way?

Thanks,
Hrishikesh

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,759 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,901 Reputation points
    2021-02-26T06:39:33.937+00:00

    Hello,

    You can upgrade the existing SQL Server instance directly in one go, only precaution I suggest is to backup all databases (incl. system DB) before.
    The upgrade won't effect database design, permissions or anything else, you just get more features, like SQL Server Agent, SSIS, SSAS and SSRS.

    See Upgrade to a Different Edition of SQL Server (Setup) for how to.

    0 comments
  2. Shashank Singh 6,246 Reputation points
    2021-02-26T08:28:11.383+00:00

    I have the databases, user securities, log paths setup for my project using Express.

    You should follow in-place upgrade mechanism. Copy the SQL Server 2014 enterprise setup on current machine where SQL Server 2014 express is installed. Go to setup and run it as administrator, on page that pops up select maintenance on left side and then first option of edition upgrade on top right select options that follow up and SQL server will upgrade instance automatically keeping all the securities and logins same. Since the machine does not changes the path you have configured will not change.

    0 comments
  3. CarrinWu-MSFT 6,856 Reputation points
    2021-03-01T08:41:01.183+00:00

    Hi @Hrishikesh Lele ,

    >Are there any special precautions to be taken before upgrading the edition?

    As Olaf said, you need to back up all the databases (including system databases and user databases) before the upgrade. In case of anything happen.

    >Does upgrading editions affect the database design or user securities or any relevant configuration in any way?

    No, the upgrade will not affect the database design or user securities or any relevant configuration.

    Best regards,
    Carrin

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments