Menu
DO these versions mean anything to me as a developer? I understand they have limitations on connections/processors/etc but none of that matters to me for a local development instance. All of the ISOs on MSDN are the same size, does it make a difference which of these I choose to download?
565
What is the difference between the SQL Server Express Edition and the Developer Edition? Both editions are free editions, but the Express edition has limited functionality whereas the Developer Edition does not have any limitations compared with an enterprise.
While the Enterprise edition of SQL Server 2016 does support a wide array of data warehouse features, the Standard edition only supports standard algorithms and data mining tools (Wizards, Editors, Query Builders).
SQL Server Reporting Services is available in both editions, however if you want to use Data-Driven subscriptions or a scale-out deployment, you'll need Enterprise Edition. Standard Edition simply doesn't have those capabilities.
SQL Server Developer edition lets developers build any kind of application on top of SQL Server. It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server.
The Developer edition is identical to the Enterprise edition, so you get all the feature you'll probably ever need. It's just not licensed for production use.
Standard edition (and Web edition) are somewhat limited in their functionality.
Developer Edition for 2014 and 2016 is available at no cost, so I'd definitely pick that one, if you need a dev platform!
82
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
