Can I view the data differences between the source and target tables during Data Synchronization?
Apply OS: Windows, macOS, Linux
Apply Navicat Product: All
Apply Navicat Version No.: Version 12 or above
After comparing data, the Data Synchronization window shows the number of records that will be inserted, updated or deleted in the target tables. All tables with different data and all actions are checked by default. Uncheck the tables or the actions you do not want to apply to the target.
When you selected a table in the list, the bottom pane shows the data in source and target. Select an option from the list to show the differences. Values that differ between source and target are highlighted. Uncheck the records that you do not want to apply to the target.