A tool used for database comparison and synchronization.
Main Features:
1. Non-Invasive, Independent Software Non-Invasive, there is no need to change the existing system, no need to inject script or trigger. DBSync runs independently, you just need to connect the databases and set the fields mapping, sync will be done.
2. Support a Variety of Databases It supports a variety of databases, such as Access, SQL server, Oracle, MySQL, DB2, etc., and it also support Excel, TXT, and CSV files. Any data that can be connected with OLE DB or ODBC can participate in synchronization.
3. Support Heterogeneous Database It not only supports the sync between same type of database, such as Access to Access, SQL server to SQL server, but also the sync between different type of database, such as Access to SQL server, SQL server to Oracle, etc.
4. Support Heterogeneous Platform It not only supports the data sync between same type of platform, such as Windows to Windows, Linux to Linux, but also the sync between different type of platform, such as Windows to Linux, Linux to Unix, etc.
5. Support Differences Sync It supports not only simple data replication from source DB to target DB, but also sync just the differences. The software can scan the databases on both sides, compare them and find out the differences, then sync just the differences. This makes the sync more efficient. 6. Support Bidirectional Sync The data table involved in the sync can be divided into multiple parts, each part has own self sync direction to realize the overall bidirectional sync, which can meet the sync of distributed system.
7. Support Binary Field Some field's data type are binary, byte[], image or object, they are used for storing image files or binary data, they can also be synchronized.
8. Additional Processing After Sync It has a mechanism for additional processing after sync, this can be used for data conversion, data calculation, etc.
9. Can Compare Before Sync Before sync