RSS
 

Copy all ODBC Data Sources to another computer

24 Jan

System Data Source information is kept in the registry.

First, let’s export to the .reg file on the source computer.

  • Open the Registry Editor (Start Menu > Run > regedit)

  • For System DSN: Select the folder My Computer > HKEY_LOCAL_MACHINE > SOFTWARE > ODBC > ODBC.INI
  • For User DSN: Select the folder My Computer > HKEY_CURRENT_USER > SOFTWARE > ODBC > ODBC.INI
  • Right click on the folder ODBC.INI and select Export, then save the .reg file

  • Transfer the .reg file the target computer, and open the Registry Editor
  • File > Import… and select the .reg file, click Open

Congratulations! You did it!

Social Share Toolbar
 
 

Tags: , , , ,

Leave a Reply

 

 
  1. Craig Dan

    January 28, 2011 at 10:10 AM

    You saved me to create about 15 new ODBC. It takes 1 minute to move all sources.

    Thanks!