| Note |
|---|
To view the conflicts, please see Viewing the conflicts |
If the APPLY was paused due to a conflict, or it is retrying in a loop the same SQL again and again, you can instruct it about what to do next using the command:
| No Format |
|---|
RESOLVE CONFLICT id AS resolution |
The conflict id is the number shown in the status bar, the resolution can be one of the following:
...
By default all commands in the Dbvisit Replicate console work with the default processes MINE and APPLY. The choose replication command is useful when working with 2-way replication where there are multiple processes such as MINE, APPLY, MINE1 and APPLY1. Note that the
| Note |
|---|
The CHOOSE REPLICATION command selects all processes for the indicated replication (so both MINE and APPLY processes). |
Example:
| No Format | ||
|---|---|---|
| ||
dbvrep> CHOOSE REPLICATION MINE1 |
The above command will choose the replication pair that is associated with MINE1. Typically this is MINE1->APPLY1.
| Note |
|---|
The CHOOSE REPLICATION command is needed prior to issuing commands to display, resolve and set conflicts for the APPLY1 process. |
...