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
Stop your application that is making changes to the database.
Ensure all changes made by the application are captured, and wait for the replication latency to reach zero. For more information on monitoring the replication latency, refer to the Statistics page.
Suspend the capture and integrate jobs running in a channel.
- Go to the Channel Details page.
- Under the Jobs pane, select the capture and integrate jobs.
- Click Suspend Jobs at the top right of the Jobs pane.
Upgrade the source database.
Activate replication in the channel to capture changes from the beginning of the oldest current (not closed) transaction, and regenerate the jobs, state tables, and enroll information for the tables.
- Go to the Channel Details page and click Activate Replication.
- In the Activate Replication dialog, under Replication Components, select all options except Supplemental Logging.
- Click Activate Replication.
Start your application.