I have a build server which has the incorrect edition.
Octopus connects between Production and the Build SQLServer.
Production is Enterprise Edition.
Build Server is Standard Edition
Dev and Test are Developer Edition.
The question is, Should the build server be Enterprise or Developer?
I have done a fair bit of googling and read a couple of articles but no one has a clear answer for build server edition.
I have been on a call to Microsoft and they asked me to talk to a reseller regarding licensing.
My feeling is that it is not customer facing, i.e. production app servers do not connect to this, therefore it should be Developer Edition.
That being said, I have reviewed this
Other scenarios that constitute production environments include:Environments that connect to a production database.
My Build Database Environment does not directly connect to the production database but it does so vicariously via Octopus, which makes me unsure of whether it can be Developer or Enterprise.
Answer by Kev Riley ·
I'd say that Build is not Production, and so would use Developer edition
On the current edition website : https://www.microsoft.com/en-us/sql-server/sql-server-2017-pricing
it states that Developer edition is for (emphasis mine)
Full-featured version of SQL Server software that allows developers to cost-effectively build, test, and demonstrate applications based on SQL Server software.
The fact that Octopus connects between Prod and Build (presumably for determining whats changed and possibly even pushing the changes) is irrelevant.