Data migration method and device between different types of databases and storage medium
The invention provides a data migration method and device between different types of databases and a storage medium, data in a source database is migrated to a target database, and the method comprises the following steps: obtaining source table structure information in the source database; obtainin...
Saved in:
Main Authors | , , |
---|---|
Format | Patent |
Language | Chinese English |
Published |
04.05.2021
|
Subjects | |
Online Access | Get full text |
Cover
Loading…
Summary: | The invention provides a data migration method and device between different types of databases and a storage medium, data in a source database is migrated to a target database, and the method comprises the following steps: obtaining source table structure information in the source database; obtaining a data storage rule of a target database, and generating a corresponding table construction script based on the data storage rule and the source table structure information; running the corresponding table construction script in a target database, migrating data in the source database to the target database, converting the data, and storing the converted data; and performing visualization processing on the process of migrating the data in the source database to the target database. Compared with directly exporting the table building script and executing after manual modification, the method has the advantages that the workload is greatly reduced, the error risk caused by a large amount of manual operation is avoi |
---|---|
Bibliography: | Application Number: CN202110040373 |