Data migration method and device for heterogeneous database, equipment and storage medium

The invention provides a data migration method for a heterogeneous database, which comprises the following steps of: generating a corresponding first table structure according to a data table needing to be migrated in a source database; establishing a first mapping relationship between the field typ...

Full description

Saved in:
Bibliographic Details
Main Authors CHEN TAO, ZHANG ZHONGZHEN
Format Patent
LanguageChinese
English
Published 21.06.2024
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:The invention provides a data migration method for a heterogeneous database, which comprises the following steps of: generating a corresponding first table structure according to a data table needing to be migrated in a source database; establishing a first mapping relationship between the field type in the first table structure and the field type with the same attribute in the target database; and according to the first mapping relationship, replacing the field type in the first table structure with a corresponding field type in the target database, and generating a second table structure. According to the data migration method for the heterogeneous database, by establishing the first mapping relation between the field type of the source database and the field type of the target database, the data migration compatibility is improved, and the error rate is reduced; and furthermore, the migration efficiency of the database is improved in a manner of converting the external table into the internal table in the
Bibliography:Application Number: CN202410641744