Synchronize Interbase and Access

Visually explore all the database differences
Synchronize both schema and data at once
Schedule synchronizations with a built-in scheduler

Handles huge databases (hundreds of GB) easily
Thousands of records per second compared
Supports Access, SQL Server, MySQL, Oracle, Interbase, Firebird, any ODBC source
Command-line support for easy batching
Comparison, one- and two-way synchronization modes
Schema synchronization of same-type databases
Data synchronization of any database types

Join Thousands Of Satisfied Customers From Over 80 Countries!

Omega Sync Pro Easy to use and sophisticated database comparison and synchronization.	$349
Omega Sync Unlimited Omega Sync Pro + lifetime upgrades. All future versions for free. Forever.	$749
See more purchasing options
You can also download a Free Trial Version. Fully functional for a period of 30 days.

Walkthrough of Interbase and Access synchronization with Omega Sync

Project

Step 1 of 8: Project Type

Choose if you want to synchronize schema (structure), data, or both.

Schema comparison and synchronization for databases of same kind
Data comparison and synchronization even for databases of different kind

Data synchronization modes:

Compare: 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!

Connections

Step 2 of 8: Database Connections

Selecting reference database: Interbase
We will choose Firebird from the list of available database formats. As Firebird is derived from Interbase code base, they are largely compatible. That's why we use the same connection info for both Interbase and Firebird. In the server field we need to type the name or IP address of the Interbase server. If you have Interbase installed on the local machine, where Omega Sync is running, you can leave the server field blank. Username and password we don't need to touch in most cases as Omega Sync pre-fills the "magic" values which open all Interbase databases. If Interbase is on this machine, we can now simply click ellipsis (...) button to select GDB or IB database file (file extension depends on the version of Interbase). If the file is on remote machine, you need to type the path to the file as remote server sees it. So, if the file is in C:\t\ folder on your server, you need to write the full path, for example: C:\t\filename.GDB.

Selecting work database: Access
From the list of available target database engines, we'll choose Access. You can simply click ellipsis (...) button to select MDB or ACCDB database file. It depends on the version of your database. Access 2007 databases are contained in ACCDB files, while earlier versions are contained in MDB files. If your Access database is protected, fill-in your password as well. In case you use Access workgroups and security, you will need to also find your system database and specify username/password for it.

Schema Selection

Step 3 of 8: What do you want to synchronize?

As soon as you specify databases you want to compare and optionally synchronize, Omega Sync analyzes their metadata and presents a list of all objects in the reference database. You can deselect any object, or a whole class of objects, with a single click.

Each object's definition is displayed on screen when you select it, in both reference and work database. Differences are color-coded for easy glance at the differences.

Schema Sync

Step 4 of 8: Structure is synchronized

Schema synchronization is generally very quick. In just a few seconds, missing objects are created in work database, obsolete objects are removed - and different objects are altered in optimal way to ensure the structure of work database matched the structure of reference database.

With structure synchronized, you can continue to data synchronization.

Data Selection

Step 5 of 8: Select tables to compare

All tables satisfying conditions for comparison and optional synchronization are preselected. You can deselect any table you do not wish to compare.

Conditions for table to be compared:

Table must have primary or unique key defined. If it doesn't, you can specify custom column list to form a matching key
Table must exist in both reference and work database. If the equivalent table is named differently in work than in reference database, you can edit table properties and specify custom mapping for table and each column.

Additionally, we allow custom WHERE condition on all tables in the project, and even on each specific table. Of course, WHERE condition can be defined separately for reference and work tables.

Data Comparison

Step 6 of 8: Lean back while we compare data

Omega Sync is highly optimized and is able to compare data very quickly. It can process tens of thousands of records per second and huge number of differences without slowing down.

Our algorithm is auto-adapting, making the most use of installed memory and gracefully offloading data to disk when needed.

Differences

Step 7 of 8: List of tables with differences

As soon as table data comparison is complete, you can see the list of all different tables, and statistics of the differences.

Some statistics displayed:

Number of equal records, records missing in work table, and extra records in work table
Number of records to be updated in reference table (only if you manually updated synchronization direction for certain differences in details grid)
Number of records to be updated in work table (only if you manually updated synchronization direction for certain differences in details grid)

As we allow you to customize each and every change to your databases, you can deselect any table to skip its synchronization, or you can click on its name to explore its differences for advanced customization.

Details

Step 7 of 8: (Optional) Explore differences

No other tool allows you to customize synchronization process so well.
Besides above-mentioned ability to deselect tables before comparison, or after comparison - you can alter synchronization direction for each modified record. And even more - you can alter it for each and every data value!

It works like this:

Comparison: Differences grid is read-only and tables can't be synchronized
One-way Synchronization: Changes are applied to work table, so reference table is never modified. You can choose to skip certain records or values and not include them in synchronization.
Two-way Synchronization: Click on any row or cell action to cycle through possible action modes:
- Change Work Table
- Skip
- Change Reference Table

Note: Depending on specific difference, wording is very specific - for example: Insert To Work, Delete From Reference, etc.

Data Sync

Step 8 of 8: Lean back while we synchronize

Synchronization can take some time, depending on the number of differences. After it is completed, you should have no differences and databases should be completely equal.

Unless, of course, you use our extensive customization features to not include certain values or records (or tables) from synchronization.

Result

Done and done!

As soon as data synchronization is completed, summary is displayed so you can see that everything went well.

You can see number of changes applied to your work database. If you used two-way synchronization and modified sync actions to change reference tables instead of work tables, you will see that changes were to your reference database, too.

There is a Recompare button on this screen. Use it to check the differences now.

Optionally recompare to check all is well

After you recompare tables, you should see the following friendly screen showing that Omega Sync found no differences in tables you told it to compare.

We didn't cover all advanced features here, but here are some:

Scheduler: Set up your recurring synchronizations with just a few clicks
Mapping dialog: When tables or fields are renamed, simply select from a drop-down list to specify which tables and fields to connect.
Options: Although Omega Sync uses auto-adapting algorithms and we carefully crafted its interface to make it as simple and intuitive as possible, you can opt to increase timeout if you have huge databases, or tweak data chunk size for maximum performance, for example.

We invite you to learn more about Omega Sync, and, of course, to purchase it. If you want to test it yourself, just download a free trial.