Starting scheduled end (net-change) mirroring

Scheduled End (Net Change) mirroring replicates changes (to the target) up to a user-specified point in the source database log and then ends replication.

About this task

Use this type of mirroring when business requirements dictate that you only replicate your data periodically and you have a clearly defined end point for the state of your target database when replication ends. Scheduled End (Net Change) mirroring allows you to end replication at the following points in your source database log:
  • Current time or “Now”
  • User-specified date and time
  • User-specified log position

These user specified end points ensure that your target database is in a known state when replication ends.

For example, if you start Scheduled End (Net Change) mirroring and specify a time of 12 PM, CDC Replication will continue mirroring all changes that have been committed to the target until 12 PM in the source database log. At this point, mirroring will end. You can also reschedule the Scheduled End (Net Change) mirroring to a new time or log position if business reasons warrant.

Procedure

  1. Ensure that the subscription has at least one table mapping with replication method set to Mirror. You can set the replication method in the Configuration perspective and also when you map tables in the Map Tables wizard.
  2. Click Monitoring > Subscriptions.
  3. If the subscription is available for editing, right-click one or more subscriptions and select Start Mirroring.

    Refresh Details is displayed if you have one or more tables flagged for refresh and allows you to view the refresh configuration of these tables. Scheduled End (Net Change) mirroring will not start until the refresh of these tables is complete.

  4. Depending on your version of CDC Replication, choose one of the following options.

    CDC Replication version 6.5 or later:

    Scheduled End
    CDC Replication mirrors all committed database changes in the source database and then ends replication normally at the indicated point.
    Now
    CDC Replication mirrors all committed database changes in the source database and then ends replication normally at the current source system time in the database log. The source system time when replication will end is set when you click OK.
    Specific Date/Time
    CDC Replication mirrors all committed database changes in the source database and then ends replication normally at the specified date and time in your source system database log. The current Coordinated Universal Time (UTC) offset (in minutes) of your CDC Replication source system is displayed as a hint.
    Specific Log Position
    CDC Replication mirrors all committed database changes in the source database and then ends replication normally at the specified log position in your source database log. The format of a valid log position for this subscription is displayed as a hint. This option is only available for supported source datastores.

    CDC Replication version 6.3 and earlier:

    Scheduled End (Net Change)
    CDC Replication will continue mirroring up until the current source system time in the database log and then end replication. The source system time when replication will end is set when you click OK.
  5. Click OK to start Scheduled End (Net Change) mirroring.

    After starting Scheduled End (Net Change) mirroring, you also have the option of rescheduling the end of replication to a more suitable time or log position if business reasons warrant.