Omega Sync - Online Documentation

Documentation

Tables Selection

Step 5: Data synchronization tables selection

Omega Sync will automatically select all tables with compatible table structure for comparison. Each table needs to have a primary key, which we use to match records.

When table structure is not compatible, you can edit table mappings to specify alternative key for matching and connect equivalent columns,

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-5-table-selection

Advanced feature is to specify a WHERE condition for any specific table. In addition, you can specify different condition for reference, and for work table.

interface-5-table-selection-adv

Release August 14, 2010
Omega Sync 2.9 released
To see detailed version history of this application, click here.