This topic explains how to perform simple database schema comparison and synchronization.
Click New Schema Comparison on the Database Design tab of the Start Page. Alternatively, click New Schema Comparison on the Comparison menu. The Schema Comparison wizard opens.
Comparing projects is available only in dbForge Studio for MySQL. The actual appearance of the window in Schema Compare for MySQL may slightly vary.
Select the Source and Target connections. (You can edit selected connections or create a new one by either clicking the Edit button or the New button.) To quickly compare schemas, you can click the Compare button immediately after setting databases and skip step 3.
To adjust comparison process, set the comparison options.
To set up the object types you want to compare, switch to the Object Filter tab.
Analyze comparison results, select the database objects you want to synchronize by checking the corresponding check boxes.
Click the Synchronize button on the Comparison toolbar to open the Schema Synchronization wizard.