Developer edition to standard edition

Question

Developer edition to standard edition

tmmutsetse

Hall of Fame

Points: 3669
More actions
February 9, 2018 at 6:31 am

#333452

Good day experts,
At my new job we have a sql 2014 developer edition in production and its a clustered instance.We also have a licensed standard edition on the Dev environment.I disagree with this setup of running developer edition in production.My question is : 1. can i downgrade the developer to standard so that i run licensed standard in production.
Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246961 More actions · Answer 1

tmmutsetse - Friday, February 9, 2018 6:31 AM
Good day experts,
At my new job we have a sql 2014 developer edition in production and its a clustered instance.We also have a licensed standard edition on the Dev environment.I disagree with this setup of running developer edition in production.My question is : 1. can i downgrade the developer to standard so that i run licensed standard in production.
Thanks

Does the database use any 'Enterprise' features?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Alexander Zhang Default port Points: 1497 More actions · Answer 2

Technically, yes, you can do it. Basically, you are welcome to pay, anytime.
But as Phil mentioned, you should check if you use any enterprise feature. If yes, you need a alternative solution before upgrade to avoid some 'surprise'

GASQL.com - Focus on Database and Cloud

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Keep in mind that Developer edition is not licensed for production usage. So by using it in prod, you're at risk of audits hitting you with a lot of fines.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

And if I remember correctly, you may have to uninstall and reinstall to get to standard edition.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Lynn Pettis - Friday, February 9, 2018 8:38 AM
And if I remember correctly, you may have to uninstall and reinstall to get to standard edition.

afaik, you're correct. Developer to Enterprise is a key change, other editions it's an uninstall/reinstall.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

BU69 SSCrazy Points: 2784 More actions · Answer 6

You mentioned it was clustered, Standard has a limitation on the number of nodes in the cluster so if it's a two nodes it's fine but any more and you need to be on Enterprise.