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
August 22, 2011
Omega Sync 2.22 released
To see detailed version history of this application, click here.
I've been really examining different programs (SQLDelta, RedGate, EMS and DBSync) testing its customization possibilities and general options and sync speed where trial is available and I've had to conclude OmegaSync had the best results in comparison.
Congratulations for your product!!
Alberto Pérez
www.treballo.com
www.treballo.com
