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

Apply Navicat Version No.: Version 10 or above

 

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 tab / window.

 

Example:

Server A and Server B

  1. First, synchronize A to B (only Insert records & Update records), so that B contains records in A
  2. Second, synchronize B to A (only Insert records), add those records exist in B but not in A to A

Have more questions?
Submit Ticket