dbForge Schema Compare for MySQL Tour

Read and make sure how easy schema comparison and synchronization is with dbForge Schema Compare for MySQL. Click the screenshots for details.

1. Opening the schema comparison wizard

By default, the Start page opens, where you can launch Schema Comparison wizard and start your common tasks in one click without searching a required command in the menu.

Tip: Also you quickly open previous comparison projects.

2. Creating database connections

To create a database connection, click the New button in the wizard. The Database Connection Properties window appears.

For a direct connection to a MySQL server, enter the details for the Host, Port, User, and Password fields. If you want to connect through SSL or SSH protocols, or using HTTP tunneling , move to the corresponding tab in the window and set connection parameters. Click OK to finish the creation.

Come back to the schema comparison wizard and select this connection in the drop-down list of the Connection field.

3. Selecting databases for comparison

Select the databases to compare. They are called Source and Target.

Source is the database which content is inserted to Target during synchronization. Target is the database which content you compare and synchronize with Source.

Tip: To swap Source and Target, click the swap button. To start the comparison, click Compare.

4. Selecting comparison options (optional)

You can customize comparison behavior, e.g., to ignore some objects or properties. Go to the Options wizard page and select the required check boxes.

Tip: Save the comparison settings as a command line arguments file by clicking the link at the top. Later you can use this file for automatic comparison and synchronization through command line.

Tip: To save the current selection of options as your defaults, click the Save As My Defaults button.

5. Filtering objects (optional)

Select object types that you want to include into comparison.

Tip: To group the list of supported object types by MySQL versions, select Group by Server Version.

6. Analyzing comparison results

See the full info about compared objects in the SchemaComparison window. Select required objects to synchronize .

The grid shows all compared objects automatically grouped by their status: Only in Source, Only in Target, Different, Equal, etc. See the structure differences of the selected object under the grid.

Tip: For better understanding, filter the objects in the grid, e.g., to see Only in Source objects. To be convinced you get the desired synchronization result, preview the synchronization script fragment for any object.

7. Synchronizing database structures

Use the Schema Synchronization Wizard to generate a standards-driven synchronization script and tune the synchronization result based on your needs. Click the Synchronize button to immediately generate the synchronization script.

8. SQL script management

Use SQL editor to view and edit synchronization scripts, create and execute queries against the selected database.

Tip: To open SQL editor, click the New SQL button on the toolbar.

Tip: When the query is executed, see the query results in the Data window at the bottom. Find rich data management options in the right-click menu.

9. Scheduling tasks through command line

Command line interface of dbForge Data Compare for MySQL and Windows Task Scheduler can help you automate routine schema comparison and synchronization tasks. You can create a *.bat file and schedule executing it in Windows Task Scheduler to keep schemas of your databases always in sync.