Trial period for SQL Server 2019 Evaluation ended, can I move the instance to express on the same server?

Justin Yandall 0 Reputation points
2024-07-02T22:15:05.7633333+00:00

Trial period for SQL Server 2019 Evaluation ended, can I move the instance to express on the same server? I'm using it for just a test environment, but don't want to lose the work done already.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,534 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 36,026 Reputation points
    2024-07-03T01:34:18.9066667+00:00

    Hi @Justin Yandall,

    move the instance to express on the same server

    Do you mean that you want to upgrade the Evaluation to Express directly? If yes, you may try to use Edition upgrade to do that.

    User's image

    In addition, you need to consider limitations of Express edition, DB size is one.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

  2. Olaf Helper 43,811 Reputation points
    2024-07-03T05:00:36.64+00:00

    Officially an Edition "Upgrade" Evaluation => Express is not supported, see

    See https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2022?view=sql-server-ver16

    Other way is uninstall Evaluation and reinstall Express.

    0 comments No comments

  3. Erland Sommarskog 108.9K Reputation points MVP
    2024-07-03T10:14:03.78+00:00

    Another alternative is move to Developer Edition instead. In this case, you will not face any obstacles with databases sizes etc. And this is a supported Edition Upgrade.

    Just beware that Developer Edition is not supported for production. But if it is true as you say that you are only testing, Developer Edition is fine.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.