Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

What would happen if you use SQL server developer edition on real server ?

It says that it is fully same as enterprise edition. Are'nt there any difference at real ?

I mean for example you installed developer edition and enterprise edition on equal machines. Would they show same performance on product environment ?

share|improve this question
    
and is Evaluation: Trial same as fully licenced software ? at microsoft sql server 2008 enterprise edition ? –  MonsterMMORPG Dec 30 '10 at 23:53

3 Answers 3

up vote 3 down vote accepted

Performance - yes. The license for Developer Edition precludes you from using it in a production environment however. If you get tagged for an audit, you're up a certain creek without a paddle.

I'm going to quote myself in a reply to someone else recently, because this is relevant here as well:

Bit of advice : your questions show a lot of "beginner" traits. That's not a bad thing, and I'm not trying to discourage you from asking questions here. However, you might do well to find a qualified or experienced person, either physically near you, or online, that you could engage in a real dialog about what you need for this project. This site is specifically for targeted questions and answers, and I think you would benefit a lot more from an "overview" type of conversation instead.

In your specific case, you may want to hire a consultant, because this sounds like a potentially commercial operation and you may need a professional to help you. Try to structure the engagement as a knowledge transfer, so you can get to that level someday yourself.

share|improve this answer
    
thanks for answer. i also wonder this : Evaluation: Trial same as fully licenced software ? at microsoft sql server 2008 enterprise edition ? because it gives 180 day trial which is sufficient to format computer once at 6 months i guess –  MonsterMMORPG Dec 30 '10 at 23:54
    
Do not ask questions about how to circumvent licensing restrictions on this site. Anyway, it will still bite you in the ass if you get audited. Read the edits to my answer above. –  mfinni Dec 30 '10 at 23:56
    
ok i understand you. but i just want to learn that which edition is this : Microsoft SQL Server 2008 R2 Evaluation : Trial Experience for IT Professionals –  MonsterMMORPG Dec 30 '10 at 23:59
    
and also are there any difference between trial and fully licenced software . ofc asking about microsoft sql server 2008 R2 :) –  MonsterMMORPG Dec 31 '10 at 0:00
    
Read the documentation for what you have. –  mfinni Dec 31 '10 at 0:18

For SQL Server 2005 and 2008: yes. 'Developer' edition, as well as 'Evaluation' editions are just licensing restricted versions of Enterprise Edition.

For SQL Server 2008 R2: No. The 'Developer' and 'Evaluation' versions are licensing restricted versions of the Data Center Edition, not Enterprise Edition. The main difference between DC and EE is that DE edition can scale above 64 CPU cores.

Evalutation and Developer editions cannot be used in production: doing so is a violation of the license you agreed to when you installed the product.

share|improve this answer
    
"For SQL Server 2008 R2: No. The 'Developer' and 'Evaluation' versions are licensing restricted versions of the Data Center Edition". Interesting. Do you have a reference/link for this? –  locster Mar 18 '11 at 17:24

Developer edition has the exact same features as Enterprise edition. The only difference is the licensing. You can't use Developer in Production

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.