Please note: This page was retired in December 2012.

You can find current information from the links below

If you need to buy a license for this specific version, please contact us for availability and pricing.

Other information on this page is shown for historical reference only and may have changed considerably since.

Omega Sync 3.0 released

• GUI overhaul, you can now use a wizard to create a project
• Rewritten Interbase code, now completely separate from Firebird code
• Removed full synchronization mode, to optimize user interface for each mode (schema/data)
• Bugfixes

Omega Sync 2.22 released

• Added support for SQL Server user-defined table types
• Added sync between GUID and Oracle RAW datatype
• Added per column collate
• Added protection from SQL injection in custom WHERE clause

Omega Sync 2.21 released

• Fixed nasty bug in console application which caused all tables existing in work and not in reference to be dropped, regardless of project settings

Omega Sync 2.20 released

• We will now show warning if sync script log file is not valid
• Added support for date milliseconds for SQL Server
• Fixed sorting problem when comparing SQL Server with other databases

Omega Sync 2.19 released

• User's part of WHERE clause is pushed to beginning of complete WHERE clause, so user can optimize it for optimal index utilization
• Columns that have no default and that are not null can now be added to tables that contain data
• Global where clause now gets saved even if compare is not performed
• Fixed bug when reading schema from mysql server < 5.0.xx
• Fixed bug when adding last mysql column in table

Omega Sync 2.18 released

• Improved schema synchronization - when column with no default and NOT NULL property is being added for existing data, we will add temporary default value so column can be added
• Fixed MySQL default values in alter statements
• Fixed enum field values
• Alter script identifier delimiters are now always present
• Fixed MySQL column reordering
• Removed dropping default value on column before whole column is dropped

Omega Sync 2.17 released

• Added full support for SQL Server HIERARCHYID data type
• Added extra check that splash screen is closed before continuing on startup to fix rare problem with scheduling
• Fixed display of manually mapped tables in database tree
• Fixed handling of MySQL ENUM when table had more than one ENUM column
• Fixed handling of Access metadata

Omega Sync 2.16 released

• Added ability to synchronize GUID columns with string columns
• Fixed display of manually mapped tables in database tree

Omega Sync 2.15 released

• Added proper return codes to console application
• Many bug fixes in console application

Omega Sync 2.14 released

• Updated project file to support Unicode characters for table and column names

Omega Sync 2.13 released

• Updated GUI to auto-adjust to system where large fonts are used
• Added support for multi-action Firebird triggers (for example after update+ after insert)
• Fixed stored procedures updating in Firebird
• Fixed Firebird view creation when column names are not explicit
• Timestamp columns in SQL Server databases are now correctly handled if their equivalent in work database is missing

Omega Sync 2.12 released

• Command line data synchronization speed improved 5x
• Improved GUI after schema synchronization
• Optimized SQL Server table schema fetching so server won't timeout with thousands of tables in a database
• Optimized temporary file handling so large table names can no more create problems with storage
• Scheduler now checks in advance if current user has required privileges to create scheduled tasks
• Fixed Oracle schema synchronization
• Fixed Oracle data sync when user defined types are used
• Fixed case when missing objects were not displayed in the list of objects to synchronize
• Fixed Firebird quoting for tables which require it in data synchronization
• Fixed Firebird stored procedure comparison
• Fixed SQL script generated for MySQL trigger synchronization

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