Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What's the easiest way to migrate ODBC data sources from one server to another?

Migrating ODBC data sources

What's the easiest way to migrate ODBC data sources from one server to another?

by  skyler  Posted    (Edited  )
In my case, we had about 1000 ODBC data sources that needed to be migrated from an old NT 4 IIS server to a new Windows 2000 IIS server.

1. Start -> Run -> regedit

2. Highlight (single click) the following key in the scope pane (left hand side of the window).
\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI

3. Choose the Registry menu -> Export registry file -> name it 'odbcreg' and save it to a network share.

4. Go to your target machine, and browse to the same key in the registry. Right click on ODBC.INI and choose 'rename' -> name it ODBC.INI.OLD as a backup.

5. Highlight its parent registry key (ODBC)

6. Choose the Registry menu -> Import registry file -> browse to then share with 'odbcreg' and double click to import.

7. Test your applications that utilize the data sources to verify the import worked properly.

Remember, you can always roll back by renaming ODBC.INI.OLD back to ODBC.INI.

Cheers, Gabe
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top