You can use a wizard to promote your selected rule sets
to an existing subscription in a new environment.
About this task
In this scenario, you have made changes to rule sets in a
subscription that has already been promoted to another environment.
For example, the subscription may already exist in a project that
you have reserved for testing subscriptions, but you may have made
some minor changes to the rule sets for the subscription. To make
sure the subscription in the test environment includes the changes
that you made, you need to promote your changes to the testing environment. Note: When
promoting changes to an existing subscription,
CDC Replication maintains
synchronization between your source and target tables and you do not
need to set the log position in the new environment. However, if you
are making changes that causes you to lose synchronization between
your source and target tables (such as updating the definition of
a source table), then
CDC Replication does
not maintain the log position and you will have to resynchronize your
source and target tables in the original and in the new environment.
For more information on how to synchronize source and target tables
in a table mapping, see
Flagging source tables for refresh.
- Click
.
- Select the subscription with the rule sets you want to
promote.
- Click Rules in
the Table Mappings view.
- Select one or more rule sets.
- Right-click and select Promote....
- Select Promote changes to an existing
subscription.
- Select the subscription to which you want to
promote changes from the Promote To list.
- In the Mappings area you can select
one of the following two options and click Next:
- Replace all mappings in the existing subscription—Indicates
that the selected rule sets that you are promoting will replace all
existing mappings in the existing subscription you are promoting to.
For
example, you plan on promoting table mappings from subscription Develop to
subscription Test. Subscription Develop contains
four rule sets: A, B, C,
and D. A and B are
selected for promotion to subscription Test. Subscription Test contains
three rule sets: A, B, and Z.
By selecting this option, rule sets A and B in
subscription Develop will replace all of the
existing rule sets in subscription Test. After promotion
is complete, subscription Test will only contain
rule sets A and B. Rule set Z will
no longer exist in subscription Test.
- Only replace the selected mappings—Indicates
that only the selected table mappings and rule sets in the subscription
being promoted will replace table mappings and rule sets (with identical
names) in the existing subscription you are promoting to. All other
table mappings and rule sets will remain in the subscription you are
promoting to.
For example, you plan on promoting rule sets from
subscription Develop to subscription Test.
Subscription Develop contains four rule sets: A, B, C,
and D. A and B are
selected for promotion to subscription Test. Subscription Test contains
three rule sets: A, B, and Z.
By selecting this option, rule sets A and B in
subscription Develop will only replace rule sets A and B in
subscription Test. After promotion is complete, subscription Test will
still contain three rule sets: A, B and Z.
- Confirm the source datastore and the name of the database
and owner from which you want to promote the changes, then click Next.
Note that subscriptions with rule-based table mappings can
not be promoted when the source and target datastores are identical.
- Confirm the target datastore to which you want to promote
the changes.
- Click View XML to confirm
the location and attributes of the promoted subscription.
- Review the list of changes and click Finish.