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...
Saved in:
Main Authors | , |
---|---|
Format | Patent |
Language | Chinese English |
Published |
21.06.2024
|
Subjects | |
Online Access | Get full text |
Cover
Loading…
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 |