How to move the on-premises ControlUp database?

There are situations where the ControlUp database needs to be moved from one SQL server to another.

In order to move the database, you need to take the database backup and import it on the new SQL server. (that is done by the organization's DBA)

Once the database is moved, the SQL connection string (the SQL details defined during the on-premises server application wizard) need to be edited.

Here are the steps:

1. On the on-premises server, open regedit.exe and go to the key presented in the following screenshot - 

2017-04-20_0938.png

2. As you can see the connection string is encrypted. In order to decrypt it, download the EncryptDecryptTool.zip attached to this article.

3. Please copy the tool to the on-premises server and launch it.

2017-04-20_0946.png

4. Take the encrypted string and paste it to the tool and click decrypt - 

2017-04-20_0940.png

5. Then edit the connection details in notepad - 

2017-04-20_0949.png

6. Relaunch the tool and paste the new details and encrypt the string -

 2017-04-20_0952.png

6. Copy and paste the new encrypted string to the registry key and click OK - 

2017-04-20_0952_001.png

7. Once you are finished with the registry update, reset the IIS, and you are done -

2017-04-20_0954.png

2017-04-20_0955.png

Powered by Zendesk