Wednesday, February 27, 2013

Is SQL Server express edition supported by Microsoft?

As DBA you would never be happy seeing express edition in your production environment. But if someone ask you whether Microsoft officially says that express edition is 'NOT' supported? The answer is 'No' , it is supported. You can use express edition in production , it depends on requirement.
Any edition other than developer edition can be used for production environment.

MSDN says :

SQL Server 2012 Developer edition lets developers build any kind of application on top of SQL Server. It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server. SQL Server Developer is an ideal choice for people who build and test applications.

You can use express edition for production but it would not be scalable and there many features which you will not get in express edition. The good thing is that you can upgrade express edition seamlessly to the higher editions as per business requirements.

Following link contains SQL Server support lifecycle published by Microsoft :


No comments:

Post a Comment