Wednesday, March 28, 2012

Installing more than one edition

I am a contract software designer, servicing multiple industries and multiple sizes within those industries. I need a way to develop and test on both SQL Server Developer edition, and SQL Server Express. Is it possible to install these two editions side-by-side for the purposes of development?

Do I need to have them installed on separate computers?

Yes. You can install different editions of SQL Server 2005 on the same machine successfully, which is supported by SQL Server 2005 provided that the machine has enouugh resources like disk space and the operating system supports the edition of SQL Server 2005. Please see BOL(Books OnLine) for details.

|||Yes, and the major concern is to be aware that if you use SSMS (from the Developer Edition), you will have some functionality that SQL Express does not support. So be cautious when you are attempting to guide a client that may have only SSMSE.sql

No comments:

Post a Comment