October 25, 2012 at 8:34 am
Example scenario. Current odbc connection on a workstation is to CLIENT_SQL\DATABASE. This database is being moved to CLIENTSQL\DATABASE and the old server CLIENT_SQL is being decommissioned. We cannot name the new server the same as old server. If we set an A record in DNS so that CLIENT_SQL points to CLIENTSQL, will that odbc connection on a workstation still work?
Thank you in advance.
October 25, 2012 at 9:13 am
It sounds good in theory, but I suggest trying it with a proof-of-concept test. Should be easy enough to test on a simple VM. Then you'll know for sure.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 25, 2012 at 10:11 am
Worked for me when I did it at my previous work place. Get's a bit messy if you do it a lot.
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
October 25, 2012 at 10:13 am
Thank you. Im fairly positive it is not best practice 😉
More of a temporary solution immediately following the migration.
Thank you for the responses.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply