Today I’m going to teach you how to backup System DSNs.
When you migrate MicroStrategy to a new machine, for example, you have to recreate all system DSNs that you had in the old machine to MicroStrategy connect to DWs and Metadata databases.
If you have a lot of DSNs configured, it could be boring create one-by-one again.
To make it easier, you can backup the System DSNs and import it to the new machines.
To do that you just have to:
1. Click Start -> Run -> type: regedit
2. Browse to: “HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI”
3. Select ODBC.INI and click “File” and then Export.
Save in a known place and paste this reg file in the new machine.
Open regedit again and click on File -> Import. Choose your .reg file and every DSN that you had will be created in target machine.
Hope it helps.
God bless you!