Database Restoration Scenarios

After testing the Connect integration, follow the instructions for the database restoration scenario that best matches your requirements.

Scenario A: Connect is Not Configured on the Destination Database

After testing the Connect integration in a preview or sandbox environment, you can copy or restore the database. This allows you to configure the preview or sandbox database for a production environment:

  1. Scenario A: Connect is Not Configured on the Destination Database
    After testing the Connect integration in a preview or sandbox environment, you can copy or restore the database. This allows you to configure the preview or sandbox database for a production environment:
    1. Restore the database.
    2. Run this query to clear out the existing Vantagepoint Connect values:

      UPDATE FW_CFGSystem

      SET VPConnectHMAC = NULL, VPConnectTenant = NULL, VPConnectStatus = 'notstarted', VPConnectType = 'Production'

    3. Wait 24 hours before configuring attempting to configure Connect.
  2. Scenario B: Connect is Configured on the Destination Database
    You can copy the sandbox or preview database and use it as the production database. This maintains the configuration settings and overwrites the Destination Database with another database:
    1. Run Delete All Configuration on the Destination database to Deprovision the tenant before overwriting it.
    2. Run this query:

      UPDATE FW_CFGSystem

      SET VPConnectHMAC = NULL, VPConnectTenant = NULL, VPConnectStatus = 'notstarted', VPConnectType = 'Production'

    3. Wait 24 hours before configuring attempting to configure Connect.

Administrator Recommendations:

If you are going to stop using Connect on the Source Database, it is recommended to deprovision it first (run Delete All Configuration) before creating a backup to be restored on to the Destination Database.

The administrator account that is used to configure Connect is automatically provisioned and added on the Users column. Since a mailbox can only be provisioned to one Connect instance at a time, you should ensure that you will only authenticate the mailbox or perform Connect Sync on one Connect instance.

If you plan to provision a user for another Connect instance, It is recommended to run Reset Mailbox for the user before deprovisioning the old database.