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 |
|
JohnHinch
Starting Member
1 Post |
 Posted - 2012-05-04 : 08:21:23
|
| Hi,We currently have a SQL 2000 database running on a clustered server. We are looking to move to a much bigger cluster and therefore our database on the new server (SQL 2008) will be referred to by servername\instance name. My question is, will it be possible to move to the new server without having to change connection strings everywhere. If we weren't moving to an instance on the new server we could move, switch off the old server, add a DNS entry to send connections to the new server without changing any application settings. To put things into perspective, if we have to change the connection strings everywhere, we are going to have to change stored procedures on at least 9 other SQL servers, plus linked server settings, plus Registry and Config file settings on at least 30 Citrix servers, plus config setttings on multiple Web Servers, plus various other applications that have connection settings hard coded with have to be rebuilt and deployed. I have read up about SQL aliases but don't think they will help as we would still need to do something on each server. Any ideas or pointers would be much appreciated. Thanks. John. |
|
|
|
|
|
Database move without updating connection strings?