Bulletproof database migration

Compare and synchronize
your database tables

Non-destructively update your target database tables and make them match your source database.
Even across database types!

Synchronize anything

For example, compare your local SQL Server database with a MySQL replica on your web site and synchronize all the differences in just a few minutes. You can even sync changes coming from file databases (CSV, DBF, Excel documents, Paradox...)

Examine differences in detail

If you just want to compare tables, you'll be glad to learn that we have a beautiful visualizer of the table differences. You can even export the differences in a machine-readable JSON format.

Continuous synchronization

We have a built-in scheduler for recurring synchronization, as many of our customers need to replicate changes on an ongoing basis. Save your project and tell us when exactly do you want us to run it. Overnight, or every 15 minutes - or whatever you need.

faq

Frequently asked questions

Our biggest advantage is the fact that we support a huge number of popular database formats. We don't use slow and buggy ODBC drivers (though we support that if you need it). Instead, we spent time to implement native, fast and reliable communication for each database format. And - we can synchronize changes from non-relational data, something no other products do.
Our high-performance engine compares and logs all differences between each source table and its equivalent target table. We then apply a minimal set of changes to the target table needed to make it the same as the source table. As most changes will be new data, we use our fast bulk load engine to make the replication super-quick.
It means "databases of different type". Not only can we synchronize data between databases of the same type (for example, two PostgreSQL databases), we can synchronize data from SQL Server to Oracle, from CSV to MySQL, or basically any other combination.
Replicator does not do that. However, Full Convert does and its Pro plan includes the same comparison and synchronization features Replicator uses.
We don't do two-way synchronization as that would require either polluting your databases with triggers and slowing them down, or a low-level file access to your database servers to be able to read logs. Also, it would severely limit the number of databases Replicator supports.
No, we won't. While trigger-based replication is fast, it comes at a steep cost. You'd need to create potentially thousands of triggers and additional tables - and make your database slower in everyday's work, as well as more brittle.
Head over to the purchase page, please.
Yes, there is a free trial available at the trial page. Provide an email when activating trial and you'll get full support from our developers.
Absolutely. Send an email to support, tell us which timezone you're in and describe what is it you need to achieve. One of our devs will get in touch.

Features

If you're looking for exhaustive list of features in the application, here you go.

Pro plan

over 40 database engines supported directly with no drivers needed
If we don't support your database directly, we provide ODBC connection you can use
One-way synchronization of data for all tables with primary or unique key defined
Any of the supported relational databases can be used as a target for synchronization
Compare and synchronize data from relational and non-relational databases
Custom row comparison key with automatic checking for value uniqueness
Optimal bulk insert mode for the table structure, target database type and version
Non-destructive changes to target tables with minimal set of inserts/updates/deletes
Customizable schema mapping rules
Six different logs - summary, errors, warnings, whole SQL, failed SQL, JSON
Custom script and system commands can be run before or after the conversion
Both 32- and 64-bit version applications included
Dedicated console application included
Powerful per-table mapping overriding per-project settings
Custom WHERE expressions to filter the range of data compared
Sophisticated table de/selection UI to quickly work with a subset of a large database
Multi-column row keys support
Unicode support for international character sets
Advanced table mapping dialog, allowing comparison and synchronization even if table structure differs
SQL script for data synchronization can be saved for manual synchronization in external tools
Built-in data difference vizualizer:
- matched reference/work table rows are displayed below each other
- equal cells are merged to avoid clutter
- NULL values are displayed with patterned background
Built-in scheduler for recurring replications:
- relies on Windows Scheduled Tasks to provide rich scheduling options
- can be specified to run only when user is logged on, or always
- scheduling modes: Once, Daily, Weekly, Monthly
XML data can be parsed, or compared as plain text for improved speed
Unix/Windows line ending differences can be ignored