Database comparison and synchronization

Full Convert Pro can quickly synchronize changes in your data

Use our data change replication and update tables in-place, without recreating everything.

Quickly compare and synchronize data changes

When to use sync?

If you already have your target database tables, we can compare source table with the target and do a few precise changes to the target to bring it in sync with the source.

Requirements

Source tables need to have a primary or unique key defined, so we can tell which records are equivalent.
You can also specify custom key.

Let's see how this works with an example

We have copied SQL Server's AdventureWorks database to PostgreSQL. At this point source and target databases are exactly the same; source is SQL Server and target is PostgreSQL.

We have copied SQL Server's AdventureWorks database to PostgreSQL. At this point source and target databases are exactly the same; source is SQL Server and target is PostgreSQL.

SQL script to change the target database

Databases are compared in Full Convert

Full Convert detects the changes. As 16 records are missing in the target compared to the source; it's the same as if 16 new records are added to the source so this is the convention Full Convert uses to report changes. Also, one record is changed.

All differences can be examined in Full Convert before applying the change replication. Added records show there is nothing in the target (bottom part of the row), while changed records split only the values that are actually different. We can see that CountryRegionCode and Name are the same for the 'BA' record, while the Modified date differs.

Each difference can be examined

Applying the change script

Running the replication will apply the minimal changes to the target database. The script used is a minimal SQL script needed to bring the target in sync with the source database.

Running the comparison again will show that databases are again exactly the same. Often, customers will use Full Convert's built-in scheduler to do a periodic replication of data changes from source to the target.

Changes precisely copied to the target

faq

Frequently asked questions

  • We chose not to pollute your databases with hundreds of triggers and log tables. Our solution is clean and supports all popular database engines (see overview page). Also, we're the only ones efficiently synchronizing non-relational files (CSV, DBF, Excel etc.) with the relational target tables.

  • We support over 40 databases at this point and are very likely to support yours. Take a look at the whole list on our databases page.

  • There is no comparison, really. We natively support all popular (and less popular) databases. We took the time to talk to each database directly instead of the easy way of using slow and buggy generic ODBC drivers. Just looking at the performance, features and stability, our software is in a class of it's own. And don't get us started about ease of use and our fantastic user interface...

  • Absolutely! Your source database will be used only for reading and is perfectly safe.

  • For most of the database types, we can and we do. If you don't have the target database when you try connecting, we'll ask you if you'd like us to create it for you.

  • Yes! Use the standard conversion project once to create your target database and populate it with your source data. After that, create a data replication project for ongoing sync of the changes.

  • 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.

Migrate your data now.
60-day money back guarantee

Full Convert is used by thousands of organizations in 98 countries.