Database synchronization method and synchronization device based on incremental field

Abstract

The invention provides a database synchronization method and synchronization device based on the incremental field. The synchronization method comprises the steps that a preset data field is selected from a source table to serve as the incremental field, a first endpoint value and a second endpoint value are set, the incremental field has an incremental relation, and the first endpoint value is smaller than the second endpoint value; and data between the first endpoint and the second endpoint is screened from the incremental field as incremental data, and the incremental data is synchronized into the target table. According to the database synchronization method and device provided by the invention, a user can specify the increment field and the initial value through visual configuration, and a numerical type, a time and date type and a timestamp type are supported. A data initialization script and an incremental script are automatically constructed through the incremental field and the initial value, and a periodic task is configured to realize incremental data acquisition. Compared with an existing incremental acquisition method, the method is easy to implement, easy to operate, easy to use and high in universality.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and device for synchronizing databases based on incremental fields. Background technique [0002] The data initialization work in the current database synchronization needs to be performed manually. Use the database backup tool to export the data from the source database into a backup file, and then manually import it to the target database, and then perform incremental synchronization. It is also necessary to manually start the incremental synchronization. tool. During the whole process, a lot of human workload is required, and the process of constantly monitoring the export and import of backup files is relatively cumbersome. At the same time, for some large databases, an initialization process usually lasts for 3-4 days, and even lasts for as long as Several weeks, however, the database transaction log during this period may be cleaned up due to the long period of ...

AI Technical Summary

Problems solved by technology

During the whole process, a lot of human workload is required, and the process of constantly monitoring the export and import of backup files is relatively cumbersome. At the same time, for some large databases, an initialization process usually lasts for 3-4 days, and even lasts for as long as Several weeks, however, the database transaction log during this period may be cleaned up due to too long, causing the incremental synchronization tool to not work properly

[0003] In related technologies, technical means such as date and time stamps are used to collect or incremental data in the source table. This method can only perform incremental extraction for date and time data, and when the synchronization is divided into multiple times, it cannot be effectively connected Up to last updated content

Images