SQL Server 2016 Developer Edition

Question

SQL Server 2016 Developer Edition

Lawrage

SSC Veteran

Points: 287
More actions
June 26, 2016 at 9:33 pm

#327400

Hi all,
I have a question about SQL Server Developer Edition, more specifically this line:
"SQL Server Developer Edition is for development and testing only, and not for production environments or for use with production data."
My question isn't around the production environments part but the production data part.
As an example say we have a typical use case, a Production server fully licensed for 2016 Enterprise and a Dev server which is used for genuine development (not to test restores or running dbcc against). The Dev environment would get the databases from the production server restored from time to time to do Dev and Test work against.
Am I interpreting that right in that restoring a backup from Prod to Dev is "production data" and as such isnt a Dev server? Or is it that once the data is on Dev, its Dev data now and can be used to develop against. I hope I am reading the former wrong as it seems strange to me.
Any thoughts on this?
Cheers.
EDIT - Interesting that the licensing PDF on the site words it slightly differently.
"SQL Server Developer Edition may not be used in a production environment or with product data."

Viewing 5 posts - 1 through 4 (of 4 total)

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

frederico_fonseca SSCoach Points: 16154 More actions · Answer 1

Interpretation on one my my clients, a major enterprise, is that as soon as the data is restored to a non prod environment it is no longer production data. And this has been discussed with Microsoft a few 3-4 years ago.

Luis Cazares SSC Guru Points: 183706 More actions · Answer 2

The moment that you can't trust a restore from Dev to Prod, the data is no longer production data. However, you might want to review the restores from to Dev as you might encounter privacy problems with data.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Lawrage SSC Veteran Points: 287 More actions · Answer 3

Thanks for the replies, that is the way I would have thought it works however figured id check and see how others read that.

Am waiting on an official reply from a MS rep.

DeWayne_McCallie Hall of Fame Points: 3617 More actions · Answer 4

It is normal to restore Prod DB's to a test/dev server for TESTING and development work. There are no issues with this as long as the DEV server is not used for production work (this is the key part).