How do I set up bi-directional, that is, where two tables are kept exactly synchronized?
You can use bi-directional replication and protected collision resolution to set up a configuration where two tables are kept exactly synchronized.
In the Getting Started Guide and in previous Advanced User Guide topics, routing has been uni-directional, that is, from source to target(s) only. You can also define a bi-directional configuration, which allows user updates locally at both a source and a target server and where the server is defined as both a source and a target. No hierarchical relationship exists between the servers.
In a bi-directional distribution, Connect CDC assumes responsibility for detecting data collisions and either resolves them automatically or presents them for resolution as you specify.
The principal tasks described in the section include: