After comparing schemas, or a schema and a project, the differences are shown in the Schema Comparison document.
dbForge Studio for MySQL automatically sets different statuses for compared objects to help you quickly analyze the differences. Compared objects can have the following statuses:
If a Source table has partitioning and a Target MySQL server does not support partitioning, table comparison status depends on the table structure differences. If the table exists only in Source or has other differences than partitioning, it has Only in Source or Different status and it can be synchronized with Source except for partitioning. If the tables in Source and Target have the same structure except for partitioning, the partitioning is ignored and the table comparison status is Equal.
For each compared object dbForge Studio automatically sets the operation in the Operation field to apply after synchronization. Based on your needs, you can change it and select the required one from the drop-down list in the field. The following operations are available:
If you don’t want to synchronize some objects, clear required check boxes.
To exclude several objects from synchronization or include them, highlight these objects in the grid and select the Exclude Selection or Include Selection options from the right-click the menu or press the Space key to include/exclude selected objects.
By default all compared objects are included into synchronization.
To refresh schema comparison results, click the Refresh button on the Comparison toolbar.
To better understand comparison results, you can do the following: