June 24, 2011 at 9:37 am
We installed new sql 2008 - default instance = DBNEW
We want forward all old named instance = DBOLD\SQL connection
to new default instance = DBSQL
is it possible?
DNS entry forward only from old machine(DBOLD) to new machine(DBNEW)
June 24, 2011 at 11:04 am
Not sure if I understand cmopletely because you have three names floating around: DBNEW, DBSQL and DBOLD\SQL. How I read the post is that you want requests that were going to named instance DBOLD\SQL to start being served by default instance DBNEW on a different server meaning I will ignore DBSQL as a typo.
You can use port forwarding at the network layer to accomplish the redirection. Or you can configure DBNEW to answer on the same port as DBOLD\SQL instead of on the default port 1433. In the port forwarding scenario I think you'll still need to have the instance name DBOLD\SQL online in some form so the SQL Browser Service can continue to dole out the port # for requesting clients. Most of this is conjecture about how I understand the browser service functions and how I understand it to have been setup in a shop I previously worked in where the config management team did not have a handle on all the code/config-data they managed, note that I have never actually set this up 🙂
IMHO this is a slippery slope and the config management team in the aforementioned shop was fighting the equivalent of spaghetti code in the DNS servers and routers to deal with all the forwarding they had signed up for when in hindsight they knew they should have just done the work up front to change the config files and all clients when a server was migrated...why can't you just have all the client start going to DBNEW?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply