Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Do you use SQL Server Developer Edition on server-class machines in DEV and STAGING environments?

I am working on a large project where (if it passes the proof of concept stage) we will have several large geographically distributed enterprise class database servers running SQL Server 2012 Enterprise Edition.

We will have a production environment will initially have 3 servers, our Staging environment will have a minimum of 3 servers, and our Development environment will have 1 server (hosting three instances).

I was under the impression that we would only need to acquire Enterprise licences for the actual production servers, and we could get by with developer edition in our developer and staging environments because they are not "production".

Other sources have told me that we need to have an enterprise licence on all of the above mentioned machines, and that the developer edition is only meant for a single developer on their workstation.

Since developer edition has all the sexy features of Enterprise, I can't really see the value of it on a workstation class machine, especially for developing and testing the type of high availability system we are building.

If we have to fork out Enterprise licences for a dev server, that will just about kill our proof of concept stage, thus killing the project. Forcing an enterprise licence on a staging environment will make management just want to skip staging altogether.

share|improve this question
2  
"Since developer edition has all the sexy features of Enterprise, I can't really see the value of it on a workstation class machine, especially for developing and testing the type of high availability system we are building." -- it's tough to develop an application that uses, for example, table partitioning, when it's not available. That's the whole point of Developer Edition. –  Jon Seigel Mar 20 '13 at 17:10
    
Just to clarify, what I meant was that it would be a shame to NOT be able to use developer edition on a big honking server. I specifically intend on showcasing the more advanced features and do not want to try to do that on a developers laptop. –  datagod Mar 20 '13 at 17:20
2  
Oh okay, yeah, I agree completely. –  Jon Seigel Mar 20 '13 at 17:26
1  
What's your definition of a staging environment? Are you referring to a test/user-acceptance-test system or ETL type staging? Appropriate isn't the correct term here, it's more to do with the legality of a configuration. –  Mark Storey-Smith Mar 21 '13 at 1:27
    
In my neck of the woods (Canadian government clients) staging is the environment used for test/user-acceptance. Sometimes they have 4 environments (DEV/TEST-QA/STAGING/PROD) and in that case staging is simply a place that is an exact copy of production so that when you rollout your changes you will see if anything breaks. Bit costly to maintain all 4 environments, so typically the middle two get merged into one. –  datagod Mar 21 '13 at 2:12
add comment

2 Answers

up vote 8 down vote accepted

Development edition licenses can be used to install anything that isn't production, provided that everyone that connects to the server has their own development license. MSDN licenses can be used as well if everyone has an MSDN license.

share|improve this answer
add comment

Short answer: yes.

Slightly longer answer: yes as long as you have one developer license for every person accessing the development and staging servers.

From the Licensing Quick Reference Guide:

The SQL Server 2012 Developer Edition is a full-function version of the SQL Server software—with all the features and capabilities of the Enterprise edition—licensed under the Developer Tools model, which is a “per user” model. One license is required for each person that accesses or uses the software.

When using SQL Server software for development, test or demonstration purposes, only the users are licensed and there is no need for a corresponding license for the actual server systems running SQL Server software in this case.

As long as only licensed users have access to the software, customers can install as many copies of the software on any number of servers that are used exclusively for development, test or demonstration purposes. This is significant, because it allows customers to run the software on multiple devices (for testing purposes, for example) without having to license each non-production server system

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.