mardi, juin 05, 2007

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

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.

Aucun commentaire: