Home / server / Questions / 217585
Accepted
MonsterMMORPG
Asked: 2010-12-31 15:47:22 +0800 CST

Is microsoft sql server 2008 enterprise and developer edition totaly same?

  • 772

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 ?

sql-server

3 Answers

  1. Best Answer

    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.

    • 3

  2. 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.

    • 3

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

    • 0