DBConvert & DBSync Features

Everything DBConvert and DBSync do to move your databases and keep them in sync - fast, secure, and under your control.

Speed up your database migrations

Performance

Migration speed depends on several factors - source dataset size, machine performance, output settings, and more. The conversion engine handles databases with millions of records.

Bulk insert option

For time-critical jobs. It inserts several records at once into the target database to speed up the whole migration.

Quantization option

Handles large tables with millions of rows more efficiently. DBConvert reads the source in batches and uploads each batch to the destination, instead of loading the whole table at once.

Learn more about Bulk Insert and Quantization
Bulk quantization interface

A clean transfer, every time

Reliability

DBConvert checks your schema before the transfer runs, so problems surface while they are still easy to fix. It flags type mismatches and issues with tables, indexes, and relations up front, and most are cleared with a quick adjustment at the customization step. Prevention beats correction.

The built-in verification reviews your structure and relationships before migration, so nothing is silently lost or altered. You move your data knowing exactly what will land on the destination.

Binary data support

Your binary data stays safe. DBConvert handles every binary type - BLOBs, OLE Object packages, BYTEA, and more - and carries primary keys, indexes, and foreign keys across intact.

Error verification interface

Convert views/queries automatically

Automation

DBConvert's parser handles cross-database views/queries translation for you.

It converts SQL views completely automatically. You don't need to know the differences between SQL dialects - that knowledge is already built into the tool.

Convert views interface

Three ways to synchronize

Sync

DBSync tools keep your databases up-to-date with Update, Insert and Drop synchronization features.

Insert sync

Adds new, missing records from the source database to the destination.

Update sync

Replaces records in the destination that have changed in the source.

Drop sync

Removes records from the destination when the corresponding records no longer exist in the source.

Together, these three types keep your distributed databases consistent.

Database sync types interface

Trigger-based sync

Performance

The trigger-based sync method speeds up synchronization many times over.

Using pre-created triggers, it reflects changes made in one database across the others in a distributed, heterogeneous setup.

Near real-time replication

Triggers on the source catch each insert, update, and delete as it happens and pass it to the other databases, so the copies stay current without a full re-sync.

Trigger based sync interface

Bidirectional synchronization

Sync

Map data types

Automation

DBConvert assigns target data types automatically, and you can override any of them. Pick the type you want for a given source field, and the rest is handled during migration.

Flexible data mapping

Each source type maps to its closest match in the target by default, and you can change any mapping before the migration runs.

Data mapping interface

Data filters

Control

Built-in data filters give you more control over the migration. Define filtering conditions and convert only the dataset you need.

You can select only the tables, fields, indexes, foreign keys, queries, and views you need before you proceed.

Learn more about Data Filters
Data filters interface

Automation and scheduling

Automation

Save sessions

Save your sessions and reuse them - no more reconfiguring source and destination every time. Apply your saved customizations whenever you migrate data.

Save sessions interface
Command line interface

Command line mode

Use command line mode to automate your export and import jobs using the saved session name as a parameter.

Built-in scheduler

Every DBConvert tool manages conversion and synchronization tasks through the built-in scheduler.

With sessions and batch files as parameters, scheduled tasks run as background services - unattended, on your schedule.

Learn about DBConvert Scheduler
DBConvert scheduler interface

Dump-file output

Offline target

When you can't connect to the target server directly, DBConvert can write the migration result to a SQL dump file instead. The file can be loaded later through psql, mysql, sqlcmd, phpMyAdmin, or any standard restore path.

Supported engines

MySQL, PostgreSQL, MS SQL Server, Oracle, Firebird. See dump-file destinations for the full configuration.

Dump-file output options

SSH forwarding

Security

With optional SSH configuration, DBConvert establishes a secure tunnel between platforms for safe data transfer.

Learn about SSH Forwarding configuration
SSH connection setup interface

Unicode support

Compatibility

DBConvert products fully support Unicode and multi-byte character sets, so they work with modern encodings (including utf-8) and the related standards.

You can choose your desired character set when establishing connection to a database.

Character set selection interface

Complete configuration

Customization

Copy your database as-is or reshape the target structure. Customization is WYSIWYG: every object - tables, views, fields, indexes, foreign keys - can be adjusted before migration starts, e.g. renamed or excluded.

Tables and fields customization interface

Additional features

Comprehensive capabilities for all your database needs

Core features

  • Interactive (GUI) mode and command line mode
  • Cross-platform database server connectivity
  • Unicode (utf-8/utf-16) support
  • Field mapping capabilities
  • Quantization and Bulk insert options

Advanced features

  • Primary keys, indexes, and relations conversion
  • AutoIncrement (AutoNumber) fields conversion
  • Automatic symbol replacement for reserved names
  • Task scheduler automation
  • Sessions/jobs saving and restoration

System requirements

Operating system

  • Windows 11/10/8/7

Dependencies

  • Microsoft Visual C++ 2010 x86 Redistributable