[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 535
  • Last Modified:

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?
0
dmoss123
Asked:
dmoss123
  • 2
1 Solution
 
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
 
dwkorCommented:
Are you looking for something like that?

http://www.mssqltips.com/tip.asp?tip=1620
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now