Can SQLExpress be used as an alias that switches between SQLServer 2005 Express and SQL Server 2008 Express

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?
dmoss123Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
dwkorConnect With a Mentor Commented:
Are you looking for something like that?

http://www.mssqltips.com/tip.asp?tip=1620
0
 
dwkorCommented:
Use Connection strings in config file (http://msdn.microsoft.com/en-us/library/ms254978.aspx) and simply switch server name from one server to another.

You can see some examples here: http://www.connectionstrings.com/sql-server-2005
0
 
dmoss123Author Commented:
dwkor, normally that would be good advice, but in this case my reason for using an alias is to avoid having to modify the connection strings.
0
All Courses

From novice to tech pro — start learning today.