Oracle and MS Access move to the new application
Version 5.3.0 ships for all 16 pairs on the new application. Nine of them are new to it: four Oracle pairs and five MS Access pairs. Each is one product that converts and synchronizes in both directions.
Oracle with MySQL, SQL Server, PostgreSQL, SQLite
- The Oracle client is part of the installer. There is nothing else to install, and it reaches Oracle Database 11.2 and later.
- Connect with a service name, as Normal, SYSDBA, or SYSOPER.
- Sync out of Oracle is trigger-based or by comparison, one way or both.
MS Access with MySQL, SQL Server, PostgreSQL, SQLite, Firebird
- Reads and writes
.accdband.mdbfiles, with a database password. - Exact numbers stay exact: Currency and Decimal keep every digit.
- Needs Microsoft's free 64-bit Access Database Engine. If it is missing, Connect links to the download.
- Access 97 files must be re-saved in Access 2000 format or later. Workgroup security (
.mdw) is not supported.
Oracle, up to 43 times faster
10 million rows against Oracle Database XE 21 on 2 CPUs, measured on our test machine, 4 threads:
| Job | Before | Now |
|---|---|---|
| Oracle to MySQL | 294 s | 39.7 s |
| MySQL to Oracle | about 29 min | 40.7 s |
| Sync into Oracle, 200,000 unchanged rows | 129.4 s | 11.3 s |
The other new pairs, the same 10 million rows: Oracle to PostgreSQL 32 s, PostgreSQL to Oracle 40 s, Oracle to SQL Server 41 s, SQL Server to Oracle 47 s.
- A table the run creates in Oracle is loaded with Oracle's direct path when its column types allow it, several loads in parallel, and its key index is rebuilt once at the end.
- Reads out of Oracle fetch about a megabyte of rows per round trip and split large tables by key ranges.
- Sync looks keys up 500 at a time and merges in key order instead of asking one row at a time.
Firebird, three to eight times faster
Measured on our test machine, 4 threads:
| Job | Before | Now |
|---|---|---|
| Firebird to SQL Server, 10 million rows | 130.8 s | 37.4 s |
| Firebird to PostgreSQL, 10 million rows | 115.1 s | 27.9 s |
| PostgreSQL to Firebird, 1 million rows | 49.1 s | 6.1 s |
| Sync out of Firebird, 10 million unchanged rows | over 32 min | 42.1 s |
Also in this release
- Jobs, connections, and settings are saved as files in
%LOCALAPPDATA%\DBConvert, easy to back up. Passwords and the licence key stay in Windows Credential Manager. - A PostgreSQL
double precisioncolumn keeps its fraction in Firebird. - A Firebird BLOB that cannot be read is reported as an error instead of arriving empty.
- A session saved by the previous interface with the "MSSQL Azure Database" connection imports as SQL Server.