Data synchronization method and device, computer equipment and storage medium

The embodiment of the invention belongs to the technical field of computers, is applied to the field of smart communities, and relates to a data synchronization method, which comprises the following steps of: obtaining primary keys in each data table in an Oralce database and field values correspond...

Full description

Saved in:
Bibliographic Details
Main Author HUANG LIANGREN
Format Patent
LanguageChinese
English
Published 25.03.2022
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:The embodiment of the invention belongs to the technical field of computers, is applied to the field of smart communities, and relates to a data synchronization method, which comprises the following steps of: obtaining primary keys in each data table in an Oralce database and field values corresponding to the primary keys, converting the formats of the primary keys into character strings, and obtaining a target primary key; the target primary key and the corresponding field value are synchronized to a MySQL database; regularly storing the first data in the Oracle database and the second data in the MySQL database into an intermediate database; and when a data comparison instruction is received, comparing whether the first data and the second data in the intermediate library are the same, and when the first data and the second data are different, executing data correction operation. The invention further provides a data synchronization device, computer equipment and a storage medium. Wherein the data table can
Bibliography:Application Number: CN202111539576