How to Migrate ODBC Data Sources From One Machine to Another

odbc connection

odbc connection

Some application uses ODBC connection to access an database. If you are retiring or moving the application from one server to another, follow these

steps in migrating your ODBC connection to another machine.

NOTE: Just make sure that you have installed all drivers in the new machine before you run this procedure.

  1. Click on start and select run or press the Windows Key + r (same thing).
  2. Type regedit
  3. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI, and highlight the ODBC.INI key in the left pane.
  4. From the Registry menu, select Export Registry File.
  5. Select odbc.reg, and save it to a network share.
  6. 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.
  7. Highlight ODBC.INI’s parent registry key (ODBC).
  8. From the Registry menu, select Import Registry File and browse to the network share where you saved odbc.reg or just double-click odbc.reg to import it.
  9. That is it! Test your application 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.