Data verification method and device after data migration

Abstract

The invention discloses a data verification method and device after data migration, and relates to the technical field of automatic programming, and the method comprises the steps: obtaining a pre-created configuration file; determining a connection mode of the source database according to the type of the source database in the configuration file; determining a connection mode of the target database according to the type of the target database in the configuration file; according to the connection mode of the source database, calling a connection tool of the source database to obtain source database data; according to the connection mode of the target database, calling a connection tool of the target database, and obtaining data of the target database; and according to the verification mode in the configuration file, comparing the source database data with the target database data to obtain a data verification result after data migration. According to the method, the data after data migration can be efficiently, accurately and comprehensively verified, so that the successful online efficiency of a new system after data migration is improved, and a powerful guarantee is provided for stable operation of the new system in future.

Description

technical field [0001] The invention relates to the technical field of automatic program design, in particular to a data verification method and device after data migration. Background technique [0002] This section is intended to provide a background or context to embodiments of the invention that are recited in the claims. The descriptions herein are not admitted to be prior art by inclusion in this section. [0003] The success of data migration is an important prerequisite for the successful launch of the new system, and it is also a strong guarantee for the stable operation of the new system in the future. After the data is migrated from the source database to the target database, the consistency of the source database and the target database directly affects the success of the data migration, so it is very important to check the consistency of the source database and the target database after data migration. important. [0004] The data consistency between the sour...

AI Technical Summary

Problems solved by technology

[0004] The data consistency between the source database and the target database is mainly reflected in the consistency of database objects such as the number of tables, the number of data entries in the table, the key fields of the table, the index of the table, the partition of the table, and the stored procedure. The comparison between the source database and the target database is acceptable when the amount of data is small, but when the amount of data is large, this method is extremely inefficient on the one hand, and on the other hand, due to manual reasons, comparisons are easy to occur The case where the result is wrong

Even though the sampling method can be used to improve the efficiency, the result does not represent the sampling results of all data, and there is a certain risk in the accuracy. It is not suitable for systems with strong data sensitivity, and the scope of application is limited.

Images