You can compare two table structures and see the differences in columns, keys, indexes, and other structural table elements. Also, you can compare data in selected tables and see the differences in values.
Compare two table structures
In the Database tool window ( ), select two tables.
Right-click the selection and navigate to Compare ⌘D.
Compare contents of two tables
Double-click two tables that you want to compare.
In the editor, click the Compare Content button () and select the second table.
If needed, change the value of the Tolerance parameter in the comparison dialog. The Tolerance parameter defines a maximum number of differences that are allowed between two result sets. For example, if you want to consider two rows as equal if their data differs in a single column, enter
1in the Tolerance field.