Database Sync Tool DBSync - Official Download

Database Sync Tool - DBSync

Support a Variety of Databases

DBSync is a lightweight desktop software used for database comparison and synchronization, it can identify the difference between two databases and synchronize the difference to keep them identical.

1. Main Features:

● Independent, Non-Interfere

DBSync runs independently, you don't need to change or interfere the existing system, you don't need to set script or trigger in database, you just need to connect to databases and set sync style, then sync can be done.

● Support a Variety of Databases

DBSync supports Oracle, MySQL, SQL Server, Access, PostgreSQL, DB2, SQLite, Firebird, etc., and NoSQL databases MongoDB, ES, and data files Excel, TXT, CSV, etc. Any data that can be connected with OLE DB or ODBC driver can work in DBSync.

● Support Heterogeneous Sync

Besides the sync between same type of DB, such as Oracle to Oracle, MySQL to MySQL, DBSync supports also the sync between different type of DB, such as Oracle to SQL server, SQL server to MySQL, MySQL to MongoDB or Elasticsearch.

● Remote and Cross-Platform Sync

Besides the sync in LAN, DBSync supports also remote sync, for example it can sync data between local DB and cloud DB, cross-platform sync is supported too, such as windows to Linux, Linux to UNIX.

● Support Incremental Sync

Besides the sync of full data, DBSync supports also incremental sync, it can scan the database of both sides, find out the differences, then sync only the incremental data. This makes sync process more efficient.

● Support Bidirectional Sync

The data in database can be divided into multiple logic parts, each part can has it’s own sync direction to achieve bidirectional sync in overall, this can meet the sync for distributed system.

● Support 1-to-N and N-to-1 Sync

Some company has a headquarter DB and several branch DBs, you can use DBSync to distribute headquarter data to branches, or collect branches data to headquarter, 1-to-N sync and N-to-1 sync are both supported.

● Data Filtering and Processing

You can limit the data scope in sync, it can be whole DB, or some tables, or some rows & fields in table, just filter as you like. Besides, you can set SQL statement to do additional processing, such as data conversion, data calculation, etc.

● Support Binary Field

Some field's data type are binary, such as byte[], image or object field, they are used for storing image files or binary data, these data can be synchronized too.

● Nearly Real-time Sync

The minimum time interval of repeated sync can be set to 1 second. Once the source DB changes, the changed data will sync to target DB in 1 second, it's nearly real-time.

● Sync Unattended

DBSync supports long-term unattended run, even if the network is interrupted, or the computer shut down and restarted, sync can restore automatically as long as they are restored, no manual operation is required, no data will lose.

● Except Notification

DBSync can send except notification. Once some error occurs during sync, it can send an Email to you so that you can find and handle errors in time.

2. How It Works

The mechanism of DBSync is straight, it uses neither transaction logs nor triggers, it just reads data from both sides, scans and compares them, finds out the incremental, then writes incremental data into target DB to keep them identical.

DBSync uses driver to connect to database. Any data that can be connected with OLEDB or ODBC driver can be synchronized. Therefore, it supports a variety of databases including SQL DB, NoSQL DB, and data files.

The steps to use it: First, set the database connection string to connect to databases. Second, set table mapping and field mapping of both sides. Then, set Sync Style (such as Incremental Sync) and Sync Frequency (such as once every 1 minute), then you can start the sync process.

DBSync has no hand in the inner process of database, it allows you to set sync range on demand, this makes it more adaptable, flexible, reliable, and easy to use.

DBSync is designed for DB technicians, you should know the basic information of database. For example, in order to sync customer data, you should know the store location and structure, which table it is in the source side? Which table it is in the target side? How is the tables and fields mapping? In addition, you must have read permission to source DB, write permission to target DB. DBSync will abide existing constraints of the target DB to ensure data security.

More detail, please see DBSync User Manual(.PDF)

3. Running Environment

DBSync is designed to run in windows system. You can deploy it on the source DB side, or deploy on the target DB side, or even deploy on a third-party computer. Any computer that can connect to the database can deploy DBSync.

4. Price

We provide free version and full version, both of them can be installed locally and used permanently.

The free version can not automatic sync repeatly, others are the same as the full version. Therefore, if you only sync occasionally, you can use the free version.

The full version can automatic sync repeatly, as long as you don't close the program, the sync will continue stably. The price is 1000 US$/license.