Re: Server migration - ODBC Connections
- From: "Dave Patrick" <DSPatrick@xxxxxxxxxxxxxxxx>
- Date: Sun, 22 Mar 2009 15:58:53 -0600
If you're using file DSN's, then you can copy them from/to
%ProgramFiles%\Common Files\ODBC\Data Sources
If you use system DSN's then you can create a *.reg file from;
You'll need to get the subkey with the DSN names
HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources
and also the subkey for each DSN
HKLM\SOFTWARE\ODBC\ODBC.INI\
Also look for user DSN's in;
HKCU\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources
and also the subkey for each DSN
HKCU\SOFTWARE\ODBC\ODBC.INI\
You can also use VBScript
http://cwashington.netreach.net/depo/view.asp?Index=1010&ScriptType=vbscript
--
Regards,
Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Ashenafi" wrote:
Hello everyone
I'm hoping you can give me a bit of help here.
I'll set the scene a little with what we currently have, and what we
want to achieve.
We currently have a Windows NT4 domain, with more than 30 windows 2003
member servers.
The windows 2003 member servers are hosting
- SQL 2000 and 2005 servers where clients' applications are connected
and get access using ODBC connections
- File Servers where clients get access using map drives.
- IIS servers hosting Intranet applications.
- DNS and DHCP servers (Stand alone windows 2003 servers)
Our target is to migrate the NT4 abc.com domain to xyz.net windows 2003
Active Directory. We have all the necessary hardware and software
requirements.
So far we have migrated almost all of user/computer accounts using ADMT
v3 and we have been successfully efficient on this.
Now we are about to begin the servers migration. The challenge here is
that the name of the servers will be changed. I.e. from server23 to
something like DC0000-US-2003 and I believe we will have problems with
the ODBC connections to the SQL servers and Map drives to the File
servers.
We can reconnect the Map Drives using Login script but what I would
like to know is how we can handle the ODBC connections as smooth as
possible (without business interruptions). I have been scratching my
head for weeks now and I couldn't come up with a solution.
Thank you in Advance.
Ashe
--
Ashenafi
------------------------------------------------------------------------
Ashenafi's Profile: http://forums.techarena.in/members/53020.htm
View this thread: http://forums.techarena.in/server-migration/1144516.htm
http://forums.techarena.in
.
- References:
- Server migration - ODBC Connections
- From: Ashenafi
- Server migration - ODBC Connections
- Prev by Date: Re: help required to repair windows 2003
- Next by Date: subinacl /migratetodomain
- Previous by thread: Server migration - ODBC Connections
- Next by thread: DHCP/DNS problems when migrating computers
- Index(es):
Relevant Pages
|
