Data migration method and device between different types of databases and storage medium

Abstract

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 avoided to a certain extent, the database migration working difficulty is reduced, and the practicability is relatively high.

Description

technical field [0001] The invention relates to data migration technology, in particular to a data migration method, device and storage medium between different types of databases. Background technique [0002] With the development of the times, people will generate a large amount of data in the process of production, life, and scientific research, and then store the large amount of data in different databases. Since different database products have different advantages, different scenarios will return to Choose a different database product for data storage. [0003] However, in the actual use process, there will be situations where data needs to be migrated between database products of different manufacturers (such as Oracle to MySQL). At this time, it is necessary to create a table structure in the new database in advance. Table script syntax is different, and database table creation cannot be completed through simple import and export. Currently, database client tools on...

AI Technical Summary

Problems solved by technology

[0003] However, in actual use, there will be situations where data needs to be migrated between database products of different manufacturers (such as Oracle to MySQL). At this time, it is necessary to create a table structure in the new database in advance. Table script syntax is different, and database table creation cannot be completed through simple import and export. Currently, database client tools only support table structure synchronization between database products of the same manufacturer. Table structure synchronization between cross-vendor database products requires manual modification and creation of tables. Statement script, heavy workload, high abnormal risk

Images