Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2011-03-03
3
Medium Priority
?
537 Views
Last Modified: 2013-11-05
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
Comment
Question by:dmoss123
  • 2
3 Comments
 
LVL 13

Expert Comment

by:dwkor
ID: 35030369
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
 

Author Comment

by:dmoss123
ID: 35030826
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
 
LVL 13

Accepted Solution

by:
dwkor earned 2000 total points
ID: 35031011
Are you looking for something like that?

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

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

585 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question