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...

Full description

Saved in:
Bibliographic Details
Main Authors ZHU MINGZHOU, LAI SHOUSHENG, SONG ZILONG
Format Patent
LanguageChinese
English
Published 04.05.2021
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
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