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.