DBSync database synchronization tool

DBSync data synchronization tool is a tool for data synchronization between heterogeneous databases. Currently supported databases are: access, sqlserver, oracle, db2, sybase ase 11-15, Mysql. At the same time, the ODBC synchronization function provided by this software can indirectly support other databases such as FireBird and INTERBASE. This version implements support for binary field synchronization. In future versions, other types of databases will gradually be supported.

DBsync also provides the function of batch script update (refer to the specifications defined in the interface). This tool can implement synchronization operations in plans, increments, and consistency of records between two tables. DBSync also provides developers with a secondary development interface, so developers can easily configure the data that needs to be synchronized. The new fast transaction processing function can provide synchronization capabilities for millions of data records. The newly added remote synchronization task function can be combined with the remote data exchange server to form a global data exchange system; the remote file synchronization task can be combined with the remote data exchange server to form a reliable file backup system for internal use within the company.

Its specific functions include:

1) Data synchronization or incremental synchronization function between different database tables (in record units);
2) Data synchronization is defined in terms of tasks (add tasks, delete tasks, modify tasks);
3) Scheduling of synchronization tasks (immediate execution, scheduled execution, or execution at fixed time intervals);
4) Reports on daily execution results can also be viewed in real-time;
5) Data security (each synchronization task is processed in a transactional manner);
6) Import and export functions of synchronization tasks;
7) Achieve data synchronization in the form of workflow (not implemented yet);
8) Support common database record operations (add records, modify records, delete records, execute stored procedures);
9) Combine the remote data exchange system with the remote data exchange server;
10) Long-term unattended data synchronization service;
11) Provides the ability to back up local files to remote servers with a reliability of 99.99%;
12) Provide the function of creating folders;
13) Local folder synchronization function;
14) You can set the list of files that need to be synchronized and the list of files that do not need to be synchronized according to specific file synchronization requirements;
15) Supports U disk synchronization function. When the U disk is connected, the system automatically recognizes it;
16) Exclusive file synchronization function, supporting forced backup of SQL SERVER database files (MDF, LDF)
17) Provide remote combined synchronization function to easily achieve complete synchronization of remote branch database and headquarters database.
18) Provide FTP backup function;
19) Added DB2, MYSQL, ACCESS, and ODBC remote data synchronization functions;
20) Provide bidirectional synchronization support between databases;