Sometimes we came across a situation where we want to back up our existing configuration .
Basically during migration of MicroStrategy from one machine to another.We need to recreate all system DSNs that we had in old machine to connect to DW and Metadata databases.
If we have a lot of DSNs configured , it would be teddies to create one-by-one again.
To make it easier , we can backup the system DSNs and import it to new machines.
For this we have to follow few steps as mentioned below.
Step 1: Open the Registry.
Click Start -> Run -> type: regedit
Step 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 import this reg file in the new machine.
Open regedit again and click on File -> Import. Choose your .reg file.
It will create every DSN that you had to the target machine.
Basically during migration of MicroStrategy from one machine to another.We need to recreate all system DSNs that we had in old machine to connect to DW and Metadata databases.
If we have a lot of DSNs configured , it would be teddies to create one-by-one again.
To make it easier , we can backup the system DSNs and import it to new machines.
For this we have to follow few steps as mentioned below.
Step 1: Open the Registry.
Click Start -> Run -> type: regedit
Step 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 import this reg file in the new machine.
Open regedit again and click on File -> Import. Choose your .reg file.
It will create every DSN that you had to the target machine.
Comments