SQL developer vs Enterprise editions

• daniarchitect

  SSCommitted

  Points: 1727

  More actions

  April 18, 2013 at 11:17 am

  #394624

  Hi

  SQL server 2008 R2.

  Can we use developer edition for all our development , testing and staging servers , and use enterprise edition on production server.

  what is the disadvantage , or where does the developer version falls short in terms of functionality.

  Using Enterprise version on all servers is expensive , am not sure if that by itself is recommended

  Note that all sql server functionality like DR, Encryption... will be implemented

  Thanks

• dbafromthecold@gmail.com

  SSChampion

  Points: 10160

  More actions

  April 18, 2013 at 11:19 am

  #1607909

  Hi,

  Developer has all the functionality of Enterprise Edition, it just cannot be used for live production environments.

  Andrew