Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jay1Jay
Yak Posting Veteran
50 Posts |
 Posted - 2004-08-05 : 16:42:17
|
| Ok I have SQL databases name "Toby" and a database name "KYLE" on one server called "InfraServer"running win2000. I am moving each of these databases onto a different server with its own instances. So say now Toby--> Citi\Finance where Citi is Virtual server name and Finance is the name of instance.KYLE --> Amex\Tax where AMEX is a different virtual server name and Tax is the name of instance.Baiscally, clients on workstations are configured to connect to these databases names TOBY and KYLE. Is it possible that I can create a DNS Alias and configure it so that I don't have to change configuration on the workstation.Basically, If I have several different instances which I will, I need to move databases around from one instance to another without having to touch the User or their workstation. What is the best way to go aobut doing this.Thanks,Jay |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-05 : 17:02:42
|
| Yes you can do this. So you would create the alias at the DNS server. The clients would point to the alias and the SQL Server port. So let's say your aliases are named alias1 and alias2. Finance instance listens on port 1 and Tax instance listens on port2. Now let's say alias1 is pointing to Citi and alias2 is pointing to Amex. Then your clients would use alias1 to get to Toby database. On the client would be a SQL alias that says alias1 listens on port1. Same goes for alias2. Then if you need to move databases around, you change just the DNS alias. You change it at the DNS server. The clients do not need anything to change. Make sense? Probably not, hard to explain.Tara |
 |
|
|
|
|
|
Databases and DNS Aliases