How good is SQL server developer Edition

  • Hi, our management has decided to go with SQL Server 2019 developer edition on test servers.

    My concern is will there be limitations on using SQL Server developer edition box, when production SQL Servers are having Enterprise edition?  I have already told to my management that backups from developer edition may not work while trying to restore to enterprise edition box . Has anyone tired this before?

    How secure would a developer edition SQL server be?

    Any other limitations on using this edition. any comments or thoughts?   -thanks

  • Developer = Enterprise - just not licensed for production use.

    no other limits neither differences.

  • Hi,

    like frederico_fonseca mentioned Developer = Enterprise, only cannot be used for production.

    About restoring, depends what is your current production, if this is also SQL 2019 is no problem with restore, but if there is lower version 2017,2016 an, etc, there is not possible restore to lower version.

    Thanks

  • Thanks guys, so I don't think there would be any limitations other than using this on production.

    I hope even the database sizes, memory , CPU / high availability features would all be the same as Enterprise Edition.  Express edition have some limitations - I believe so.

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

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