- Omega Sync, SQL database comparison and synchronization

Documentation

Back to Omega Sync

Object Selection

Previous step: Database Connections

 Step 3: Schema synchronization objects selection

As schema comparison is nearly instant, there is no progress dialog. Instead, we present all the objects in reference database, grouped by their status in work database.

An object can be:

Different - exists in both databases, but has different structure. Will be updated on sync.
Missing - exists in reference, but is missing in work. Will be created on sync.
Introduced - exist in work, but not in reference. Will be deleted on sync.
Equal - exists in both databases, and has the same structure. Will not be touched on sync.

Equal objects are colored green in the object tree to improve readability.

interface-3-object-selection

If we had a differences in the schema such that our automatic mapping algorithms can't reliably detect proper connections, you can edit mappings manually. You can even define which keys are used to compare the data.

edit-mappings