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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-08-09 : 16:01:14
|
| Hi,We are moving sql server instances from cluster to vm, seperate server for each instance. My question what will be better cname or sql alias for client connection. Applications are already connected to cluster instances. So to redirect applications to new server what is best option cname or sql alias?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-08-09 : 16:50:04
|
| CNAME is a lot less work, especially if you ever have to change or move something. Client aliases are really handy for clients = 1, and really really REALLY suck for clients > 1. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-08-10 : 11:55:01
|
| CName is more flexible. Consider creating some documentation for users, as they tend to add them to ODBC and correct directly. In fact , depending on your environement , it may be useful to scan for usage of the server name - and get everyone to change the links before the migrationJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
CNAME or Alias