How can I set the Data Synchronization as two-way process?
updated at
Apply OS: Windows, macOS, Linux
Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for MariaDB, Navicat for SQLite, Navicat for MongoDB, Navicat Premium
If you want to perform bi-direction data synchronization in Navicat, you may do the synchronization twice and need to base on your condition to adjust Insert records, Update records or Delete records option in the Options window.
Example:
Server A and Server B
- First, synchronize A to B (only Insert records and Update records), so that B contains records in A
- Second, synchronize B to A (only Insert records), add those records exist in B but not in A to A
Have more questions?
-
Support
-
About Us