Moving the TimeXtender Orchestration and Data Quality database

To move the TimeXtender Orchestration and Data Quality database between SQL Server instances, follow these instructions.

Moving the database

First, we need to move the database between servers. Here is an outline of the tasks needed:

1. Take the TimeXtender Orchestration and Data Quality databases offline to make sure no instance is running on the old instance, before and after we move the database.

2. Back up the TimeXtender Orchestration and Data Quality database.

3. Restore the TimeXtender Orchestration and Data Quality database on the new server.

4. Create a SQL Login user with db_owner privileges on the new TimeXtender Orchestration and Data Quality database.

Updating database connections on servers

For all servers running TimeXtender Orchestration and Data Quality.

1. Locate ExpectusConfig.config under C:\Program Files\exMon\Bin and open it with Notepad

2. Update Data Source and Initial Catalog with your new hostname/instance name and database name respectably.

3. Find and remove in two places exMonEncryptionString=XXXXXXXX

4. Where exMonEncryptionString was, add: Password=XXXXX where XXXXX is your new password.

5. Save and close.

TimeXtender Orchestration and Data Quality should work now but the password is saved in plaintext. To encrypt the password you need to run the TimeXtender Orchestration and Data Quality upgrade tool and choose Upgrade.

You can now test the database connection by opening C:\Program Files\exMon\Bin\ExpectusAdmin.exe.

Portal

For servers running the TimeXtender Orchestration and Data Quality Portal

1. Locate client.config under C:\Program Files\exMon\exMon\Portal and open it with Notepad

2. Update Data Source and Initial Catalog with your new hostname/instance name and database name respectably.

3. Find and remove exMonEncryptionString=XXXXXXXX

4. Where exMonEncryptionString was, add: Password=XXXXX where XXXXX is your new password.

5. Save and close.

6. Open Internet Information Server (IIS) and restart the website TimeXtender Orchestration and Data Quality is running under. By default, it is called Default Website.

TimeXtender Orchestration and Data Quality should work now but the password is saved in plaintext. To encrypt the password you need to run the TimeXtender Orchestration and Data Quality upgrade tool and choose Upgrade.

You can now test if the Portal works.

Desktop installed on local machines

For all machines where TimeXtender Orchestration and Data Quality was installed using the download link on the portal.

1. Make sure the portal is using the new password by following the steps above.

2. Uninstall TimeXtender Orchestration and Data Quality using Control Panel > Uninstall a program.

3. Download TimeXtender Orchestration and Data Quality from the portal by hovering over the user's name in the top bar.

4. Install TimeXtender Orchestration and Data Quality.