How do I migrate ODBC data sources from one server to another?

John Savill

June 21, 2001

1 Min Read
ITPro Today logo in a gray background | ITPro Today

A. To migrate ODBC data sources, perform the following steps:

  1. Start regedit.exe.

  2. Go to HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INI, and highlight the ODBC.INI key in the left pane.

  3. From the Registry menu, select Export Registry File.

  4. Select odbc.reg, and save it to a network share.

  5. Go to your target machine and browse to the same key in the registry. Right-click ODBC.INI and choose Rename. As a backup, rename ODBC.INI as ODBC.INI.OLD.

  6. Highlight ODBC.INI's parent registry key (ODBC).

  7. From the Registry menu, select Import Registry File and browse to the network share where you saved odbc.reg. Double-click odbc.reg to import it.

  8. Test your applications that use the data sources to verify that the import worked properly.

Remember, you can always roll back by renaming ODBC.INI.OLD to ODBC.INI. See also, "Microsoft Site Server ODBC Database Catalog Search."

About the Author

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like