Omega Sync
by Spectral Core - Product Type: Application
Compare and synchronize your schema and data. Omega Sync effortlessly compares and synchronizes local or remote databases. Omega Sync can compare and synchronize both database schema and table data. With Omega Sync you can explore all the differences in structure and data of your databases, you can synchronize your databases in minutes, or save generated synchronization SQL script for later use. You can even synchronize data of heterogeneous databases (for example, compare your local SQL Server database with a MySQL replica on your web site - and synchronize all the differences in just a few minutes).
Our regular prices are shown below. Please logon to see your discounted prices.
Omega Sync Pro 2.11 Unlimited (Includes Lifetime Upgrades)
| Add to Cart | $ 734.02 | 1 User License (Includes Lifetime Upgrade Subscription) | Download (13.3 MB) |
Omega Sync Pro 2.11 (Includes 12 Month Upgrade Subscription)
| Add to Cart | $ 342.02 | 1 User License (Includes 12 Month Upgrade Subscription) | Download (13.3 MB) |
Omega Sync 2.11 for SQL Server (Includes 12 Month Upgrade Subscription)
| Add to Cart | $ 195.02 | 1 User License (Includes 12 Month Upgrade Subscription) | Download (13.3 MB) |
Omega Sync 2.11 for MySQL (Includes 12 Month Upgrade Subscription)
| Add to Cart | $ 195.02 | 1 User License (Includes 12 Month Upgrade Subscription) | Download (13.3 MB) |
Omega Sync 2.11 for Oracle (Includes 12 Month Upgrade Subscription)
| Add to Cart | $ 195.02 | 1 User License (Includes 12 Month Upgrade Subscription) | Download (13.3 MB) |
Omega Sync 2.11 for Firebird (Includes 12 Month Upgrade Subscription)
| Add to Cart | $ 195.02 | 1 User License (Includes 12 Month Upgrade Subscription) | Download (13.3 MB) |
Omega Sync 2.11 for Access (Includes 12 Month Upgrade Subscription)
| Add to Cart | $ 195.02 | 1 User License (Includes 12 Month Upgrade Subscription) | Download (13.3 MB) |
Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase. All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed, including volume licensing and previous versions.
Our regular prices are shown above. Please logon to see your discounted prices.
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
in association with
Select Business Solutions Catalog
The products shown in this catalog are specially selected for Select Business Solutions users.
Quick Links
Publisher
- Spectral Core (5)
Primary Category
- Database Reporting (108)
Related Products
Related Categories
- Database Management (131)