- Omega Sync, SQL database comparison and synchronization

Documentation

Back to Omega Sync

Project Type

 Step 1: Defining the project

 Select desired comparison and synchronization project type.

 

 Project types:

 

Full synchronization
Compare and synchronize both structure (schema) and data.
Schema synchronization
Compare and synchronize schema, but don't touch data.
Data synchronization        
Compare and synchronize data. Schema of databases is not touched and must be compatible in order to compare and synchronize data.

 

 Data synchronization modes:

 

Comparison
Use Comparison when you only want to explore the differences in data - and want to be sure you don't change anything in your databases. This is a read-only mode and synchronization is disabled.
One-Way Synchronization
This mode will force the sync direction from reference to work database. Reference database is not changed in any case.
Two-Way Synchronization        
This mode gives you the most control over the sync process. You can change the direction of the sync for any record in a table, even for any data value separately if you wish.

interface-1-project