I am planning to buy SQL Server 2012 for development and I have gone crazy with Microsofts complicated licencing policies.I had been searching the internet for valid answers from last few days and finally decided to post a question for expert advice.
The Requirement:
I have a small team of developer who will work on different applications. The applications require SQL SERVER as the backend.Following are the things I want to do with SQL Server
- The application will interact with the basic tables, SP, functions and views.
- Developing basic SSIS packages and SSRS reports.
- I do NOT intend to use the database for Mirroring, Replication, Snapshots or any other complicated stuff but just the basic development.
I approached the Microsoft vendors for quotes for SQL SERVER 2012. They told me that I can go with the Standard Edition with 5 CALS (I have no idea what is CAL and why do I need it). I searched the internet and found that there is a BI edition also which is much costlier than the standard edition.
The Question:
The question is that what version should I use considering my requirement?
Thanks
Best Answer
Purchase Microsoft SQL Server Developer Edition for each of your SQL developers in the exact SQL edition that you need. I would personally go for SQL Server 2014 Developer Edition since service pack one is available.
UPDATE: As of Late March 2016 Microsoft SQL Server Developer Edition is now free.
https://blogs.technet.microsoft.com/dataplatforminsider/2016/03/31/microsoft-sql-server-developer-edition-is-now-free/?MC=Vstudio&MC=SQL&MC=IE&MC=HTML5&MC=JavaScript
Microsoft SQL Server Developer Edition, contains all the benefits of Microsoft SQL Server Enterprise Edition, and must be applied to each respective SQL developer within your organization that uses Developer Edition. That being said, once your developers have a SQL Server developer license, they can develop indiscriminately on as many Developer Edition SQL Servers and databases as you like with as many cores as you like.
For example, one developer with license can deploy (n...) databases to (n...) SQL Servers with (n...) cores. Another developer within your organization can access all those installations, databases, and SQL Servers provided that they, too, have a developer license.
Microsoft SQL Server and can literally save your organization thousands to tens of thousands of dollars for development servers--especially since core licensing has gone through the roof. It's a shame that many Microsoft licensing VARs are very misinformed and/or uninformed about Microsoft SQL Server Developer Edition.