Use the same procedure to enable replication for marked tables with either a log-based Replication Agent or a trigger-based Replication Agent.
To enable replication for a marked table
Log in to the Replication Agent instance with the administrator login.
Use the pdb_setreptable command to verify that replication is disabled for the table:
pdb_setreptable pdb_table
where pdb_table is the name of the marked table you want to enable replication for.
If the pdb_setreptable command returns information that the table is marked and has replication disabled, continue this procedure to enable replication for the table.
A table must be marked for replication before replication
can be enabled or disabled for the table.
Use the pdb_setreptable command to enable replication for the table:
pdb_setreptable pdb_table, enable
where pdb_table is the name of the marked table in the primary database for which you want to enable replication.
After replication is enabled for the table, any transaction that affects the data in that table will be captured for replication.
You can use the pdb_setreptable command again to verify that replication is now enabled for the table:
pdb_setreptable pdb_table
where pdb_table is the name of the marked table for which you want to verify that replication is enabled.
