Features
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
Requirements
- Runs great on all Windows versions, including Windows 7
- Runs on both 32- and 64-bit Windows (x86 and x64)
- Can be installed on Linux and Mac under virtualization software
- Easily connects to databases running on Unix/Linux/Mac
Databases supported
- Access
- SQL Server
- MySQL
- Oracle
- Interbase
- Firebird
- Any ODBC source
July 13, 2010
Omega Sync 2.8 released
To see detailed version history of this application, click here.
