Compare MySQL

Visually explore all the database differences
Synchronize both schema and data at once
Schedule synchronizations with a built-in scheduler

Handles huge databases (hundreds of GB) easily
Thousands of records per second compared
Supports Access, SQL Server, MySQL, Oracle, Interbase, Firebird, any ODBC source
Command-line support for easy batching
Comparison, one- and two-way synchronization modes
Schema synchronization of same-type databases
Data synchronization of any database types

Join Thousands Of Satisfied Customers From Over 80 Countries!

Omega Sync Pro Easy to use and sophisticated database comparison and synchronization.	$349
Omega Sync Unlimited Omega Sync Pro + lifetime upgrades. All future versions for free. Forever.	$749
See more purchasing options
You can also download a Free Trial Version. Fully functional for a period of 30 days.

Walkthrough of MySQL comparison with Omega Sync

Project

Step 1 of 8: Project Type

Choose if you want to synchronize schema (structure), data, or both.

Schema comparison and synchronization for databases of same kind
Data comparison and synchronization even for databases of different kind

Data synchronization modes:

Compare: No data is changed.
One-Way Synchronization: Propagate changes from reference to work database, specifying which records or even individual data cells to skip.
Two-Way Synchronization: Selectively move changes across to any database (reference or work), specifying synchronization change direction on the level of table, record, or even on the level of each field!

Connections

Step 2 of 8: Database Connections

Selecting reference database: MySQL
We will choose MySQL from the source database engines list. As our MySQL server is on the local machine and we have full privileges, we will simply choose a database from the dropdown menu.

Selecting work database: MySQL
From the list of available target database engines, we'll choose MySQL. As our MySQL server is on the local machine and we have full privileges, we will simply choose a database from the dropdown menu. If we wanted to create a new target database, we don't need to do round-trip to MySQL management tool or command-line MySQL client. Just typing the non-existing database name will cause Omega Sync to create new database for us.

Schema Selection

Step 3 of 8: What do you want to synchronize?

As soon as you specify databases you want to compare and optionally synchronize, Omega Sync analyzes their metadata and presents a list of all objects in the reference database. You can deselect any object, or a whole class of objects, with a single click.

Each object's definition is displayed on screen when you select it, in both reference and work database. Differences are color-coded for easy glance at the differences.

Schema Sync

Step 4 of 8: Structure is synchronized

Schema synchronization is generally very quick. In just a few seconds, missing objects are created in work database, obsolete objects are removed - and different objects are altered in optimal way to ensure the structure of work database matched the structure of reference database.

With structure synchronized, you can continue to data synchronization.

Data Selection

Step 5 of 8: Select tables to compare

All tables satisfying conditions for comparison and optional synchronization are preselected. You can deselect any table you do not wish to compare.

Conditions for table to be compared:

Table must have primary or unique key defined. If it doesn't, you can specify custom column list to form a matching key
Table must exist in both reference and work database. If the equivalent table is named differently in work than in reference database, you can edit table properties and specify custom mapping for table and each column.

Additionally, we allow custom WHERE condition on all tables in the project, and even on each specific table. Of course, WHERE condition can be defined separately for reference and work tables.

Data Comparison

Step 6 of 8: Lean back while we compare data

Omega Sync is highly optimized and is able to compare data very quickly. It can process tens of thousands of records per second and huge number of differences without slowing down.

Our algorithm is auto-adapting, making the most use of installed memory and gracefully offloading data to disk when needed.

Differences

Step 7 of 8: List of tables with differences

As soon as table data comparison is complete, you can see the list of all different tables, and statistics of the differences.

Some statistics displayed:

Number of equal records, records missing in work table, and extra records in work table
Number of records to be updated in reference table (only if you manually updated synchronization direction for certain differences in details grid)
Number of records to be updated in work table (only if you manually updated synchronization direction for certain differences in details grid)

As we allow you to customize each and every change to your databases, you can deselect any table to skip its synchronization, or you can click on its name to explore its differences for advanced customization.

Details

Step 7 of 8: (Optional) Explore differences

No other tool allows you to customize synchronization process so well.
Besides above-mentioned ability to deselect tables before comparison, or after comparison - you can alter synchronization direction for each modified record. And even more - you can alter it for each and every data value!

It works like this:

Comparison: Differences grid is read-only and tables can't be synchronized
One-way Synchronization: Changes are applied to work table, so reference table is never modified. You can choose to skip certain records or values and not include them in synchronization.
Two-way Synchronization: Click on any row or cell action to cycle through possible action modes:
- Change Work Table
- Skip
- Change Reference Table

Note: Depending on specific difference, wording is very specific - for example: Insert To Work, Delete From Reference, etc.

Data Sync

Step 8 of 8: Lean back while we synchronize

Synchronization can take some time, depending on the number of differences. After it is completed, you should have no differences and databases should be completely equal.

Unless, of course, you use our extensive customization features to not include certain values or records (or tables) from synchronization.

Result

Done and done!

As soon as data synchronization is completed, summary is displayed so you can see that everything went well.

You can see number of changes applied to your work database. If you used two-way synchronization and modified sync actions to change reference tables instead of work tables, you will see that changes were to your reference database, too.

There is a Recompare button on this screen. Use it to check the differences now.

Optionally recompare to check all is well

After you recompare tables, you should see the following friendly screen showing that Omega Sync found no differences in tables you told it to compare.

We didn't cover all advanced features here, but here are some:

Scheduler: Set up your recurring synchronizations with just a few clicks
Mapping dialog: When tables or fields are renamed, simply select from a drop-down list to specify which tables and fields to connect.
Options: Although Omega Sync uses auto-adapting algorithms and we carefully crafted its interface to make it as simple and intuitive as possible, you can opt to increase timeout if you have huge databases, or tweak data chunk size for maximum performance, for example.

We invite you to learn more about Omega Sync, and, of course, to purchase it. If you want to test it yourself, just download a free trial.