Omega Sync - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

Omega Sync by Spectral Core

URLs: omega-sync, omega sync, omegasync, spectral-core, spectral core, spectralcore

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).

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

Compare and synchronize your schema and data.

Pricing: Omega Sync Pro 2.11 Unlimited (Includes Lifetime Upgrades) 1 User License (Includes Lifetime Upgrade Subscription), Omega Sync Pro 2.11 (Includes 12 Month Upgrade Subscription) 1 User License (Includes 12 Month Upgrade Subscription), Omega Sync 2.11 for SQL Server (Includes 12 Month Upgrade Subscription) 1 User License (Includes 12 Month Upgrade Subscription), Omega Sync 2.11 for MySQL (Includes 12 Month Upgrade Subscription) 1 User License (Includes 12 Month Upgrade Subscription), Omega Sync 2.11 for Oracle (Includes 12 Month Upgrade Subscription) 1 User License (Includes 12 Month Upgrade Subscription), Omega Sync 2.11 for Firebird (Includes 12 Month Upgrade Subscription) 1 User License (Includes 12 Month Upgrade Subscription), Omega Sync 2.11 for Access (Includes 12 Month Upgrade Subscription) 1 User License (Includes 12 Month Upgrade Subscription)

Evals & Downloads: Read the Omega Sync End User License Agreement, Download the Omega Sync 2.11 evaluation on to your computer - Expires after 30 days

Operating System for Deployment: Windows 7, Windows Server 2008, Windows Vista

Architecture of Product: 32Bit, 64Bit

Product Type: Application

Compatible Containers: Microsoft Access 2010, Microsoft Access 2007, Microsoft Access 2003, Microsoft Access 2002, Microsoft Access 2000, Microsoft Access 97, Microsoft SQL Server 2010, Microsoft SQL Server 2008, Microsoft SQL Server 2005, Microsoft SQL Server 2000, Microsoft SQL Server 7.0, Oracle Database 9i, Oracle Database 10g, Oracle Database 11g, MySQL 5.0, MySQL 4.1, MySQL 4.0, MySQL 3.23

Keywords: Omega Sync, omegasync, synchronization, synchronize, database

Database DB Reporting Report reports

Database DB Management

Part numbers: PC-539767-342697 539767-342697 PC-539767-342696 539767-342696 PC-539767-342698 539767-342698 PC-539767-342699 539767-342699 PC-539767-342700 539767-342700 PC-539767-342701 539767-342701 PC-539767-342702 539767-342702