Convert SQLServer 2014 and 2012 Standard to Developer license

Chitra Saha 6 Reputation points
2022-05-23T20:30:28.117+00:00

Do you know if there will be any issues while converting sqlserver standard to SQLServer developer edition?

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,680 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,716 Reputation points
    2022-05-23T20:49:56.913+00:00

    You cannot do an in-place upgrade from Standard or Enterprise Edition to Developer edition. This considered an edition "downgrade".

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

    1 person found this answer helpful.
    0 comments
  2. YufeiShao-msft 7,056 Reputation points
    2022-05-24T01:55:20.11+00:00

    Hi @Chitra Saha

    SQL Server standard edition need license, just money, but developer edition is a free product, you can install it directly.
    If you no longer want to use the standard edition, you can backup your database(or you can use any other ways you want to ), detach .mdf files from the standard edition and attach them to the developer edition

    For more questions about license, you can consult professionals in this area
    For detailed information about the license issue, please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. For international customers, please use the https://www.microsoft.com/en-us/licensing/worldwide to find contact information in your locations. For Volume Licensing Service Support, please use the https://learn.microsoft.com/en-us/licensing/contact-us to contact information for your country.

    -------------

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.