Database comparison and synchronization
Full Convert Pro can quickly synchronize changes in your data.
Full Convert Pro can quickly
synchronize changes in your
data
If you need real-time change streaming, see Omni Loader.
With Full Convert, do an on-demand comparison and replication.
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.
How this works
Full Convert maps source and target table columns, then compares all records and each individual value. Diff is calculated and applied to the target.
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.
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.
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.
Frequently Asked questions
We understand the real challenges of cross-platform SQL translation and
solve them with
advanced technology and deep semantic insight.
Testimonials.
“I've been working with Full Convert now for several weeks and have found it to be an exceptional product, even more so when you consider the cost. There was not another product available on the market that supported the conversion of our Paradox legacy database over to MS SQL. In doing so, the support team was the most responsive team that I've encountered in over 30 years developing software, both in terms of communication and software updates. I'm very impressed with the product as well as the dedication and commitment of the employees at Spectral Core.”
Migrate your data now.
Full Convert is used by thousands of
organizations in 98 countries.