question

KrishnaDeepakKD-2839 avatar image
0 Votes"
KrishnaDeepakKD-2839 asked MichaelKurz-9288 commented

Can we install SQL Server Developer Edition in our Non-Production Environment, which will save some licensing cost?

We are already a SQL Server shop with more than 1200+ instances using Enterprise and Standard Edition for our Production and Non-Production environment. For our Non-Production environment can we install SQL Server Developer Edition.

Is it possible to use Non-Production environment where we don't have any production data, but we periodically do database refresh activity. That means we take data from Production and restore it in Non-Production for testing purpose. Then the application team validates the data and builds applications and tests their efficiency based on that data. To clarify we don't use Non-Production for business activities but we use it for development/testing purpose which contains production data to test the workload.

So is it fine to use Developer Edition (which is free) in the Non-Production environment. If it is possible can you please share the licensing guide which has this statement mentioned in it, so that we can share it with our customers to prove that this is legal to use.

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft commented

Hi @KrishnaDeepakKD-2839,

So is it fine to use Developer Edition (which is free) in the Non-Production environment. If it is possible can you please share the licensing guide which has this statement mentioned in it,

Yes, you can . SQL Server Developer edition includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server.

When you install SQL Server Developer Edition, the license terms are copied to a location like:
C:\Program Files\Microsoft SQL Server\150\License Terms\SQLServer2019_License_DEV_1033.rtf

You can read it. The license states, in relevant part:

1. INSTALLATION AND USE RIGHTS.

a. General. You may install and use copies of the software on any device, including third party shared devices, to design, develop, test and demonstrate your programs. You may not use the software in a production environment.

b. Demonstration. Any person that has access to your internal network may install and use copies of the software to demonstrate use of your programs with the software. Those copies may not be used for any other purpose.

c. User Testing. Your end users may access the software to perform acceptance tests on your programs.

Best regards,
Cathy


If the response 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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @KrishnaDeepakKD-2839,

Any update for this thread? Did the reply could help you? If the response helped, do "Accept Answer". This can be beneficial to other Q&A members reading the thread.

Best regards,
Cathy

1 Vote 1 ·
Shashank-Singh avatar image
0 Votes"
Shashank-Singh answered MichaelKurz-9288 commented

Is it possible to use Non-Production environment where we don't have any production data, but we periodically do database refresh activity. That means we take data from Production and restore it in Non-Production for testing purpose

This is allowed, if you limit your activities to testing you can restore prod database backup on DEV edition.

So is it fine to use Developer Edition (which is free) in the Non-Production environment. If it is possible can you please share the licensing guide which has this statement mentioned in it.

Attaching SQL Server 2016 licensing data sheet . Quoting from the sheet

SQL Server 2016 Developer Edition provides a fully featured version of SQL Server software—including all of the features and capabilities of Enterprise Edition—licensed for development, test and demonstration purposes only.

It also says what is Production environment

A production environment is defined as an environment that is accessed by end-users of an application (such as an Internet website) and that is used for more than gathering feedback or acceptance testing of that application.

There is one more detailed licensing guide which says

SQL Server Developer Edition may not be used in a production environment or with product data. Any test data that was used for design, development, or test purposes must be removed prior to deploying the software for production use.

So make note of this also. This basically means that you can do testing on dev edition but cannot consider it as stage database( or staging environment) and take backup of it and restore it on production. In that case you may be violating license. Testing as I said is allowed.


· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Cathyji-msft ,
tfound this post on the web and I have also a question about the free SQL Server Developer edition. Can we use them in a training environment where the trainees learn how to handle and manage the database and the solution access the database. It's a training environment with no productive data. After the training all data will be removed.

Thanks for your help.


Michael

0 Votes 0 ·

Hi @MichaelKurz-9288,

>>Can we use them in a training environment where the trainees learn how to handle and manage the database and the solution access the database.

Yes, you can .

0 Votes 0 ·

Sounds good :-)

Thanks for the answer and have a great day.

Michael

0 Votes 0 ·