Requesting the exact steps to make changes to the active configuration file under below conditions.
1. Replicating a table with only 25 columns out of 40 columns ( vertical replication)
2. Need to alter the table to add one more (adding new column to the table) column on both source and target.
3. Need to modify the active configuration file to replicate newly added column.
4. Not replicating DDL.
N/A
Assumptions:
SP_OCT_REPLICATE_DDL 2 (enable TRUNCATE replication only)
Using vertical partioning replication
1. Add the column to the source and target table
2. Copy config to new config
3. Edit new config to add the newly added column the vertical partitoned config file to replication (26 out of 41)
Example:
Modify from :
scott.emp (c1,c2..,c25) scott.sal (c1,c2..,c25) targsysB@o.targSID + targsysC@o.targSID
To:
scott.emp (c1,c2..,c25,c26) scott.sal (c1,c2..,c25,c26) targsysB@o.targSID + targsysC@o.targSID
4. Activate new config to add new column to replication
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy