Developer vs Enterprise

  • Hi Experts,

    Is there any difference between Developer & Enterprise Edition of SQL Server (2019 ,2017 & 2014) both in features & performance wise?

     

    TIA

  • Developer edition is free to download, and has all the bells and whistles of all the versions, so that you can develop the features you require.  HOWEVER, you cannot use it for production in any way.

    Below is an answer to a similar question on another forum.

    As stated in this blog, SQL Server Developer Edition is for development and testing only, and not for production environments or for use with production data.

    SQL Server Developer edition offers the full feature set of SQL Server Enterprise edition, when you need to develop an application that uses advanced features, for example, table partitioning and transparent database encryption, SQL Server Developer edition is useful.

    In addition, for more detailed information regarding to the license issues, please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. For international customers, please use the Guide to Worldwide Microsoft Licensing Sites to find contact information in your locations.

  • DesNorton wrote:

    Developer edition is free to download, and has all the bells and whistles of all the versions, so that you can develop the features you require.  HOWEVER, you cannot use it for production in any way.

    Below is an answer to a similar question on another forum.

    As stated in this blog, SQL Server Developer Edition is for development and testing only, and not for production environments or for use with production data.

    SQL Server Developer edition offers the full feature set of SQL Server Enterprise edition, when you need to develop an application that uses advanced features, for example, table partitioning and transparent database encryption, SQL Server Developer edition is useful.

    In addition, for more detailed information regarding to the license issues, please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. For international customers, please use the Guide to Worldwide Microsoft Licensing Sites to find contact information in your locations.

     

    Thanks DesNorton,

    Any difference wrt to performance?

  • I have no idea about performance differences.  Although I cannot imagine that there will be a difference, as they are the same product installed from the same media.  In our shop, we dev with DEV edition, then all L&P and prod is done on Standard or Enterprise edition (depending on the final destination server)

     

  • VastSQL wrote:

    Any difference wrt to performance?

    They code base is identical.  The only differences are the licensing.

    Curious, why would you think that there may be a performance difference?

     

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • DesNorton wrote:

    I have no idea about performance differences.  Although I cannot imagine that there will be a difference, as they are the same product installed from the same media.  In our shop, we dev with DEV edition, then all L&P and prod is done on Standard or Enterprise edition (depending on the final destination server)

    Thanks DesNorton

  • Michael L John wrote:

    VastSQL wrote:

    Any difference wrt to performance?

    They code base is identical.  The only differences are the licensing.

    Curious, why would you think that there may be a performance difference?

    Thanks Michael,

    Just to make sure the Pre-Prod environment will give a good baseline if we do some performance testing and edition should not impact the same. We are planning to change the edition of SQL Server used as backend for BizTalk and Biztalk is really a grey area for me.

  • VastSQL wrote:

    Michael L John wrote:

    VastSQL wrote:

    Any difference wrt to performance?

    They code base is identical.  The only differences are the licensing.

    Curious, why would you think that there may be a performance difference?

    Thanks Michael,

    Just to make sure the Pre-Prod environment will give a good baseline if we do some performance testing and edition should not impact the same. We are planning to change the edition of SQL Server used as backend for BizTalk and Biztalk is really a grey area for me.

    It's been a while since I've used and supported BizTalk, so I may be completely wrong.  If I remember correctly, BizTalk would quickly fragment the indexes in the databases.

    Is you hardware virtual, or physical?  If it's physical, I would look at the hardware differences first.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • Michael L John wrote:

    VastSQL wrote:

    Michael L John wrote:

    VastSQL wrote:

    Any difference wrt to performance?

    They code base is identical.  The only differences are the licensing.

    Curious, why would you think that there may be a performance difference?

    Thanks Michael,

    Just to make sure the Pre-Prod environment will give a good baseline if we do some performance testing and edition should not impact the same. We are planning to change the edition of SQL Server used as backend for BizTalk and Biztalk is really a grey area for me.

    It's been a while since I've used and supported BizTalk, so I may be completely wrong.  If I remember correctly, BizTalk would quickly fragment the indexes in the databases.

    Is you hardware virtual, or physical?  If it's physical, I would look at the hardware differences first.

    Thanks Michael, We are running SQL Server on Vmware.

Viewing 9 posts - 1 through 9 (of 9 total)

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