Migrate ODBC Connections to new PC

MIS Department Policy & Procedure 

Migrate ODBC Connections to new PC

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.    Save as odbclocal.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.    On the new PC double click this reg file 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.

Do the same for

HKEY_CURRENT_USER/SOFTWARE/ODBC\ODBC.INI

Export and save this one as odbccurrent.reg

On the new PC double click this reg file to import it.

Save these files for the user in their H: drive for future use.

Note: if any new ODBC connections are made you would want to update these files before importing into a new machine.