Data migration method and device, storage medium and program product

Abstract

The invention provides a data migration method and device, a storage medium and a program product, and the method comprises the steps: exporting data of an original database table to be exported in an original database to obtain a first file; determining a migration strategy according to capacity information and/or system performance information of the database table, and importing data in the first file into a target database according to the migration strategy to form a target database table; exporting data of the target database table of the target database to obtain a second file; and comparing the content of the second file with the content of the first file, and if the content of the second file is consistent with that of the first file, determining that data migration succeeds. By means of the process, mass data migration, inspection and checking can be completed in a one-button mode. According to the method and the device, the optimal export and import strategy can be selected according to the database table capacity and/or the system performance, efficient and accurate export and import of the data are achieved, manual participation is reduced, in addition, full-amount comparison of the data is achieved based on file comparison, and the accuracy of mass data migration is guaranteed.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a data migration method, device, storage medium and program product. Background technique [0002] In the construction of the commercial bank information system, the Syabse database used earlier could not meet the growing demands of high concurrency and remote disaster recovery, and needed to be migrated to the Oracle database with better performance. However, heterogeneous databases, massive data, and character set differences all affect the efficiency and accuracy of data migration. [0003] In the prior art, data migration usually uses a command line or a database operation graphical interface, and adopts a fixed migration strategy to export and import database tables one by one; for abnormal data during the export and import process, it is often discarded or manually imported. In addition, in the process of data import and export, inspection and verification are ...

AI Technical Summary

Problems solved by technology

[0004] The existing data migration method is slow and inefficient, and cannot fully utilize the I / O, CPU and network resources of the server, especially when migrating massive data, the data migration time may be as long as more than ten hours

Moreover, the data migration process requires more manual participation. For example, some parameter selections are often subjectively selected by the executor based on experience, which leads to a decrease in migration efficiency and easily leads to command errors; The possibility of reporting, and for abnormal data processing, if it cannot be discarded directly, manual analysis and manual re-execution of commands are required, which is time-consuming and labor-intensive and can easily cause secondary errors

Images