Urgent SQL Developer vs Enterprise edition 2012/2014

Question

Post reply

Urgent SQL Developer vs Enterprise edition 2012/2014

Craig G

Old Hand

Points: 305
More actions
May 6, 2015 at 12:27 pm

#296708

Hello DBAs.
We have a tool that has sql server enterprise edition to be used as the database. But Is enterprise edition used in production environment same as the developer edition used in Development environment.
Mostly organizations use enterprise edition only in production. Can any DBA confirm if its the same ?

Viewing 15 posts - 1 through 14 (of 14 total)

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

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

Developer Edition is the Enterprise Edition with restricted licensing.

Phil Parkin SSC Guru Points: 246964 More actions · Answer 2

Same functions in both editions, no need to worry.

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

Eric M Russell SSC Guru Points: 125561 More actions · Answer 3

In addition to the above, unserstand that multiple users may connect to Developer Edition, but licensing requires that each user must have a developer edition license, which is about $50 US per seat.

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 4

Eric M Russell (5/13/2015)
In addition to the above, unserstand that multiple users may connect to Developer Edition, but licensing requires that each user must have a developer edition license, which is about $50 US per seat.

... which is TONS less expensive than an Enterprise Edition for Dev even if you had a hundred seats.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Eric M Russell SSC Guru Points: 125561 More actions · Answer 5

Jeff Moden (5/13/2015)
Eric M Russell (5/13/2015)
In addition to the above, unserstand that multiple users may connect to Developer Edition, but licensing requires that each user must have a developer edition license, which is about $50 US per seat.
... which is TONS less expensive than an Enterprise Edition for Dev even if you had a hundred seats.

In most places I've worked, I believe they had Enterprise Edition running on the development server, but they saved money by skimping on the hardware specifications, typically running it on a VM. Does anyone know of a white paper or FAQ where Microsoft explains in detail what they consider to be the proper useage scenarios for Developer Edition?

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Gazareth One Orange Chip Points: 27737 More actions · Answer 6

From MS's point of view: 2-core VM with Enteprise Edition ~$4000. 10 x Dev Editions ~$500. Think I know which one they prefer 😀

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 7

Gazareth (5/13/2015)
From MS's point of view: 2-core VM with Enteprise Edition ~$4000. 10 x Dev Editions ~$500. Think I know which one they prefer 😀

Who are you buying you licensing through because $4K is a whole lot less than what our NetOps is paying for the EE.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 8

EE at $4k / 2 core? Really? I thought it was closer to $7k/core, min of two. The open price is $14k/core.

I think $4k/2 core is more Standard pricing.

https://www.microsoft.com/en-us/server-cloud/products/sql-server/Purchasing.aspx

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 9

Steve Jones - SSC Editor (5/13/2015)
EE at $4k / 2 core? Really? I thought it was closer to $7k/core, min of two. The open price is $14k/core.
I think $4k/2 core is more Standard pricing.
https://www.microsoft.com/en-us/server-cloud/products/sql-server/Purchasing.aspx

I also believe the min is 4 core (a core being a single internal cpu).

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

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

Jeff Moden (5/13/2015)
Steve Jones - SSC Editor (5/13/2015)
EE at $4k / 2 core? Really? I thought it was closer to $7k/core, min of two. The open price is $14k/core.
I think $4k/2 core is more Standard pricing.
https://www.microsoft.com/en-us/server-cloud/products/sql-server/Purchasing.aspx
I also believe the min is 4 core (a core being a single internal cpu).

And only for the first 4 cores if I remember correctly. You should be able to purchase additional licenses 2 at a time.

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 11

Current licensing says 2 core packs. With their verbiage, it's confusing. The licensing PDF does say minimum of 4 cores, so my apologies.

Gazareth One Orange Chip Points: 27737 More actions · Answer 12

Gazareth

One Orange Chip

Points: 27737

May 13, 2015 at 10:36 am

#1797610

Ha, yeah my bad. My cranial £ to $ rate is faulty!

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 13

Steve Jones - SSC Editor (5/13/2015)
Current licensing says 2 core packs. With their verbiage, it's confusing. The licensing PDF does say minimum of 4 cores, so my apologies.

Of course, it's to their financial benefit not to update the pricing PDF anytime soon. :Whistling:

Do you have a link to the current licensing, Steve? We got a couple of projects that are just too big for Express but not big enough to require more than 2 core and I need to show the one of the folks responsible for buying licenses where I work.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 14

This is what's on the main page: http://download.microsoft.com/download/B/4/E/b4e604d9-9d38-4bba-a927-56e4c872e41c/SQL_Server_2014_Licensing_Guide.PDF

It's not clear, and buried a bit down in there, but says 4 core min.