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

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

  1. Start regedit.exe.
  2. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.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."

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.