ODBC drivers export / import

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.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s