Is it Possible or is there a way to use the database you have been working on the developer option for production?

Hi，Betselot Getahun

Migrating the Developer version to other versions, such as Express, is not difficult, and there are several methods for you to choose from.

However, before migrating, you need to have sufficient expectations of the database version features and carefully review the version characteristics(such asScale limits/Replication/ Programmability).

Best regards,

Mikey Qiao

If you are satisfied with the answer (or the excellent answer from other seniors), don't forget to accept it.By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

There are three (four) editions available for production usage:

• Express Edition. Free, but database size limited to 10 GB, and there are some other resource constraints as well.
• Web Edition. This session is only available to web hosters, so it is not likely to be an option for you.
• Standard Edition. No limit in database size, but comes with a price tag that is not ignorable.
• Enterprise Edition. Very powerful and very expensive.

Developer Edition has the same feature set as Enterprise, so there is a risk that you go for any of the other options, that you are relying on a feature not available in the lower editions. But when it comes to programmability surface area, there is parity, so it may not be an issue. (The differences are mainly about manageability and performance.)

If you go for Express Edition, the best way to move the database is by BACKUP/RESTORE as Karen said.

Additional note: The free Express Edition has several limitation, on e is a max database size of 10 GB.

The databases themselves aren't licensed; the server/instance is.

It sounds like you want to change to a different edition (from Developer to Enterprise or Express). This Docs link can walk you through this.

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-ver16

Note that the Developer edition is virtually the same as the Enterprise Edition, so this upgrade should be straightforward.

You'll also want to check out the supported upgrade paths in this article:

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

If you are also moving the database to another server, you'd likely want to use backup and restore to move the database to the new server.