ODBC drivers export / import

November 21, 2018, 9:49 am technology

Hi everyone

In some case you might want to export all ODBC configurations from one server to another's one.

There is a small handy tip with PowerShell to achieve that goal;

Export the DNS;

Get-OdbcDsn |Export-Clixml dsn.xml

On the other machine, we import it;

Import-Clixml dsn.xml |Add-OdbcDsn

Voila, the config is now copied between the computers.