Can I check for data differences between the source and target during synchronization?
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
After comparing data, the Data Synchronization window shows the number of records or documents that will be inserted, updated or deleted in the target. All tables or collections with different data and all actions are checked by default. Uncheck the tables, collections or the actions you do not want to apply to the target.
When you selected a table or collection in the list, the bottom pane shows the data in source and target. Select an option from the drop-down list to show the differences. Values that differ between source and target are highlighted. Uncheck the records or documents that you do not want to apply to the target.
-
Support
-
About Us