Database synchronization method and device

Abstract

The invention provides a database synchronization method and device, and relates to the technical field of data processing. The method comprises the steps that a configuration file is obtained; the configuration file comprises database parameters and operation parameters; when a synchronous processing instruction is received, a source database, a target database and a bridging database are determined by utilizing the database parameters; the bridging database has a DBLINK permission; and synchronizing the target information of the source database to the target database by utilizing the bridging database and the operation parameters. According to the method, the bridging database with the DBLINK authority is used as the intermediate database of the source database and the target database, automatic synchronization of the target information from the source database to the target database is achieved under the condition that the DBA authority is not needed, operation is easy and convenient, and the data synchronization efficiency is improved; in addition, flexible parameter configuration can be realized through the parameter configuration file, and the method can be suitable for synchronization among multiple groups of databases.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a database synchronization method and device. Background technique [0002] This section is intended to provide a background or context to embodiments of the invention that are recited in the claims. The descriptions herein are not admitted to be prior art by inclusion in this section. [0003] Database synchronization is a technology that copies a set of data from one data source to multiple data sources, and is an effective way to publish a piece of data to multiple storage sites. Using replication technology, users can publish a piece of data to multiple servers, so that different server users can share this data within the scope of permission. To synchronize the data of one database to another database, DBA (Database Administrator, database administrator) authority is required to complete the synchronization quickly. Considering that in some cases, non-DBA personnel...

AI Technical Summary

Problems solved by technology

To synchronize the data of one database to another database, DBA (Database Administrator, database administrator) authority is required to complete the synchronization quickly. Considering that in some cases, non-DBA personnel also need database synchronization, the existing database synchronization scheme Among them, database synchronization requires manual operation, and if there is no DBA authority, the database synchronization speed is slow. At present, no better solution has been proposed for the situation where the source database and the target database do not have sufficient authority and need to perform database synchronization.

Images