Omega Sync

Omega Sync Supported databases

• Access
• SQL Server
• MySQL
• Oracle
• Interbase
• Firebird
• ODBC sources

Schema and table data comparison and synchronization

• Schema comparison and synchronization for databases of same kind
• Data comparison and synchronization even for databases of different kind
• Compare and Synchronize databases of unlimited size!
• Data synchronization modes:
  • Compare only - no data is changed
  • One-Way Synchronization - propagate changes from reference to work database, specifying which records or even individual data cells to skip
  • Two-Way Synchronization - selectively move changes across to any database (reference or work), specifying synchronization change direction on the level of table, record, or even on the level of each field

General Features

• Supports 7 database types
• Schema comparison and synchronization
• Data comparison and synchronization
• Supports databases and individual tables of unlimited size
• Slick and usable modern interface
• Built-in Scheduler for recurring conversions
• Differences viewer and editor
• Command-line support using a dedicated console application
• Full Unicode support for international character data

Schema comparison and synchronization

• Supported on databases of same kind. This limitation will be lifted in future release.
• Supports tables, indexes, constraints, views, procedures, function, triggers, types
• Tables column order can be ignored or enforced
• Table column rename supported
• Each object can be deselected for synchronization
• Filter on object type can be applied
• SQL script for schema synchronization can be viewed and saved for manual synchronization in external tools
• Color-coded side-by-side comparison view for each object
• Synchronizes schema of large databases in seconds

Data comparison and synchronization

• Supported on databases of same or different kind. Heterogeneous compare/sync is unique Omega Sync feature.
• Using unique memory saving algorithms, there is no limitation on table or database size
• Tables can be additionally filtered using custom WHERE conditions, available separately for reference and work database table
• Global WHERE conditions, available separately for reference and work database
• Advanced table mapping dialog, allowing comparison and synchronization even if table structure differs
• Custom comparison keys can be specified and validated
• SQL script for data synchronization can be saved for manual synchronization in external tools
• Differences can be viewed in advanced grid, tailored for high usability

Data Differences Viewing and manual Synchronization overrides

• Matched reference/work table rows are displayed below each other
• Equal cells are merged to avoid clutter
• NULL values are displayed with pattern background, to be distinguished from empty string values
• Depending on data synchronization mode, synchronization direction can be manually overriden
• Synchronization direction override available on table, record, and cell level
• Easy and quick skipping of certain tables and rows even for table already selected for synchronization
• SQL synchronization statements are generated in background for instant synchronization
• Best fit columns and Auto-height rows

Quick Sync Everything

• If your product type allows it, you can compare and synchronize with a single click
• Confirmation prompt can be disabled in Options

Built-in Scheduler

• Built-in scheduler relies on Windows Scheduled Tasks to provide rich scheduling options
• Recurring synchronizations can be specified to run only when user is logged on, or always
• Scheduling modes: Once, Daily, Weekly, Monthly
• Optional task repeating for frequency multiplication
• Optional task stopping if running longer than expected

Options

• Automatic SQL logging
• XML data can be parsed, or compared as plain text for improved speed
• Unix/Windows line ending differences can be ignored
• Table column order can be ignored or enforced
• Specific project can be loaded on startup

Databases supported

• Access
• SQL Server
• MySQL
• Oracle
• Interbase
• Firebird
• Any ODBC source

Omega Sync is available in a number of different options depending on what databases you use:

• Omega Sync Pro - Advanced database comparison and synchronization. Synchronize data between databases of different types
• Omega Sync Unlimited (Omega Sync Pro + lifetime upgrades) - All future versions for free. Forever
• Omega Sync for SQL Server - When you only use SQL Server
• Omega Sync for MySQL - When you only use MySQL
• Omega Sync for Oracle - When you only use Oracle
• Omega Sync for Firebird - When you only use Firebird or Interbase
• Omega Sync for Access - When you only use Access