Networks

Ask something
Discussion Locked

SQL2k Easy Change

0 helpful
5 replies

by davidm

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
What I'm preparing to do is not migrate to SQL2k but replace my current server with a new one,to set it up I'm going to have to name it differently from my current server and I'm trying to put together an easy way to redirect my odbc on my client computers to go to the new server.Also I have a mess of reports that are going to have to be redirecting to pull from the new server.Any good advice would be appreciated to simplify this matter.

5 replies

by budthegrey

Is the "old" server being retired? Perhaps you change it's name and IP address, then setup the new serve with the "old" name and IP address, then use DTS to migrate the databases from the old server to the new one.

by davidm

you can not rename a server and my question is about redirecting all my workstations to the new one without going to each one and changing the regitry and odbc config

by techtonik

Edit the existing entry on a master machine, then use regedit to export the corresponding registry key (HKEY_local_machine>software>ODBC>ODBC.INI>DSNname). Hopefully the DSN is named the same on all machines, and all machines are same OS or at least compatible OS. Use a regedit entry in netlogon.bat to commit registry entry to all machines and replace current DSN name entry with new settings.

As far as reports, hopefully they all use DSN's and not direct internal connections....Depending on what reporting tool you are using, using the above should get you the results needed.

This discussion is closed to new replies.