Can SQLExpress be used as an alias that switches between SQLServer 2005 Express and SQL Server 2008 Express
Posted on 2011-03-03
This is what I would like to do:
1. Install SQL Express 2005 and name the instance SQLExpress2005.
2. Install SQL Express 2008 and name the instance SQLExpress2008.
When I want to work on a project that uses SQLExpress2005, I would like to create an alias called SQLExpress that points to SQLExpress2005.
When I want to work on a project that uses SQLExpress2008, I would delete and re-create the alias SQLExpress so that it points to SQLExpress2008.
Is this possible? Is this a bad or good idea?