Other than the product itself, there was just a free developer edition. Should these be shared on one server, or distributed on a number of servers or Virtual machines? Should all development servers be of the same edition? Is it wise to rely on an internet connection to base all your development servers in the cloud, or is there a place for the traditional ‘SQL Server on the laptop’.īefore SQL Server 2005, it wasn’t hard to choose the edition that you’d use to develop with. The LocalDb edition of SQL Server was created to be the obvious edition for developers Does that idea make practical sense and what alternative advantages come the other editions for developers?ĭevelopment work will usually require a number of server instances. In this article we will look at the choices, and the decisions you need to make. There are several options to choose from, and various issues that you might need to bear in mind.

Does the choice affect the tools that are used?Īs a developer, I need a SQL Server database against which I can develop and test code.

What options are there that could be used for development work?.

Which Edition of SQL Server is Best for Development Work? - Simple Talk

Sql server enterprise edition