Data comparison method and device based on database migration

Abstract

The invention provides a data comparison method and device based on database migration. The database migration-based data comparison method comprises the steps of obtaining a source database type anda target database type; generating a query statement according to a preset database table name and a preset parameter entry field; determining database drive connection according to the source database type and the target database type; and comparing the data in the source database and the target database according to the query statement and the database drive connection. According to the invention, deep dependence on an ORACLE database in the fields of finance and communication is overcome; the method solves the problems that in domestic database transformation, when services are migrated, the correctness and data consistency of the migrated services are difficult to verify, and especially the situation that at present, a method which can provide batch execution, can be repeatedly executed, is simple and easy to use and can execute transaction units in batches to compare multi-database execution results does not exist in the industry.

Description

technical field [0001] The present invention relates to the field of information technology, in particular to the technical field of application of localized database technology in the fields of finance and communication, and in particular to a data comparison method and device based on database migration. Background technique [0002] At present, in the field of finance and communication, the database software of foreign companies such as ORACLE and DB2 occupies most of the market. However, with the development of the national information technology industry planning and localization strategy, the domestic Information products have been gradually fully used in various industry organizations. It has become a mainstream trend to go to ORACLE and migrate from ORACLE database to localized database. In the process of database migration, how to quickly and effectively check whether the data in the Oracle database and the localized database for the same transaction are consistent...

AI Technical Summary

Problems solved by technology

[0005] Aiming at the problems in the prior art, the data comparison method and device based on database migration provided by the present invention overcomes the inability to compare a single transaction flexibly, quickly, efficiently and accurately during the migration process of a large data-level database The problem of data consistency before and after enables users to transparently control the results of business migration during the process of migrating business from commercial databases such as ORACLE and DB to localized databases, and at the same time greatly reduces the consistency ratio of the same transaction results after migration Cost and Boost vs. Efficiency

Images