Page Comparison

...

dbvrep> choose replication MINE
Process type MINE set to: MINE.
Process type APPLY set to: APPLY.
dbvrep> resume apply
Apply requested to resume.

dbvrep> choose replication MINE1
Process type MINE set to: MINE1.
Process type APPLY set to: APPLY1.
dbvrep> resume apply1
Apply requested to resume.

Adding new schemas

 To add a new schema to the 2-way replication, use the following command:

dbvrep> PREPARE SCHEMA schema_name

Note that for every table within the schema you have to synchronize the data as described above. These are the steps to follow:

1. Pause the apply processes for both replication directions .
2. Run the PREPARE SCHEMA command for both replications.
3. Synchronize the data for all tables (using transaction names as shown above)
4. Resume both apply processes

Removing tables & schemas

...

To manually remove a table from the replication, use the UNPREPARE TABLE command for both directions:

Panel
borderColor ggg
dbvrep> choose show Process MINE1 chosen, it is a MINE. Process apply1 chosen, it is a APPLY. dbvrep> unprepare table SCHEMA_RECREATE.schema_recreate_tbl Connecting to running mine [SCHEMA_RECREATE.SCHEMA_RECREATE_TBL]: [Table (un)prepared (4 internal records).] Connecting to running apply:[Apply table removed (1 metadata record(s)). Apply table added (0 metadata record(s)).] Table SCHEMA_RECREATE.schema_recreate_tbl processed. dbvrep> choose replication MINE Process type MINE set to: MINE. Process type APPLY set to: APPLY. dbvrep> unprepare table SCHEMA_RECREATE.schema_recreate_tbl Connecting to running mine [SCHEMA_RECREATE.SCHEMA_RECREATE_TBL]: [Table (un)prepared (4 internal records).] Connecting to running apply:[Apply table removed (1 metadata record(s)). Apply table added (0 metadata record(s)).] Table SCHEMA_RECREATE.schema_recreate_tbl processed.

Use UNPREPARE SCHEMA command to manually remove the whole schema.