Upgrading Database on Source Location

This section provides step-by-step instructions for upgrading a source database in a channel with activated replication to ensure that no data is lost during the upgrade.

These are the recommended steps that may vary depending on the database being upgraded.

Upgrade Steps

1. Stop your application that is making changes to the database.

2. Ensure all the changes made by the application are captured: anticipate the latency to be at zero. For more information on monitoring the replication latency, refer to the Statistics page.

3. Suspend the capture and integrate jobs running in a channel.

   UICLI

   Go to the Channel Details page, under the Jobs pane, select the capture and integrate jobs and click Suspend Jobs at the top right of the Jobs pane.

   

4. Upgrade the source database.

5. Activate replication in the channel to capture changes from the beginning of the oldest current (not closed) transaction, regenerate jobs and enroll information for tables.

   UICLI

   Go to the Channel Details page and click Activate Replication. In the Activate Replication dialog, under Replication Components, select options Jobs, Table Enrollment, Replace All Old Enrollment, and Force Start Replication Jobs.

   

6. Start your application.