Migrating ODBC data sources from one server to another

If you want to migrate your ODBC data sources from one server to another, you can do this using regedit...

On the source server/machine...

1. Start regedit.exe
2. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
3. Highlight the ODBC.INI key in the left pane
4. From the File menu, select Export...
5. Enter a suitable file name (odbc.reg), and save it to a network share or external drive (USB Stick)

On the target server/machine...

1. Start regedit.exe
2. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
3. Right-click ODBC.INI and choose Rename
4. Rename ODBC.INI as ODBC.INI.BACKUP or similar
   You can then always roll back to your previous settings by renaming ODBC.INI.BACKUP to ODBC.INI
5. Highlight (select/left click) ODBC.INI's parent registry key (ODBC)
6. From the File menu, select Import...
7. Browse to the location of your previously exported odbc.reg file
8. Double-click odbc.reg to import it

Test your applications that use the data sources to confirm that the import was successful.