Universal heterogeneous database data migration method

Abstract

The invention discloses a universal heterogeneous database data migration method, which comprises the following steps of: 1, registering a data source; 2, obtaining a database structure; 3, selectinga source database and a target database; step 4, querying whether a target database name exists in a table database table in the SQLite database or not by using the SELECT statement, and if not, creating a target database completely consistent with the source database structure; 5, selecting a data type mapping rule; 6, extracting database data from the source database; 7, judging whether to backup the data or not, and generating an XML file if the data is backed up; step 8, writing each row of data extracted in the step 7 into a target database; and 9, writing the data migration log into a migration log table of the SQLite database. The general heterogeneous database data migration method provided by the invention is suitable for common databases on the market, such as Oracle, SQLServer,Mysql, post, DM and Jinbao, and can effectively complete data migration.

Description

technical field [0001] The invention relates to the technical field of data storage, in particular to a general data migration method for heterogeneous databases. Background technique [0002] In the field of database management systems, there are many mature database products (such as Oracle, SQLServer, Mysql, Postgre, Wuhan Dameng, Renda Jincang, China General, etc.), and among the many application systems built by enterprises, due to the application Due to factors such as different development departments or the characteristics of the application system itself, different systems use different database systems, and the data already in these heterogeneous databases cannot be integrated. In order to solve the problem of data fusion between heterogeneous databases, it is necessary to migrate data from one heterogeneous database to another heterogeneous database. At present, the data migration tools provided by various database manufacturers are only suitable for migration be...

AI Technical Summary

Problems solved by technology

[0006] The Chinese patent "CN 106570086 A Data Migration System and Data Migration Method" overcomes the defect that the entire database can only be migrated at one time in the prior art, and the migration data is easily lost, and provides a data migration system and data migration method

[0007] Chinese patent "CN 104598531 B A Trigger-Based Incremental Data Migration Method Between Heterogeneous Relational Databases" solves incremental data migration of databases by creating triggers on heterogeneous relational databases to obtain database changes. It is impossible to migrate the historical data that already exists in the database, and it does not solve the situation that the target database does not exist. Solving these problems will undoubtedly increase the additional work of the operator

[0008] The Chinese patent "CN 107357866 A A localized migration method for middleware and databases of electric power enterprise information systems" uses DMHS tools to synchronize data in non-domestic databases to domestic databases, and solves the problem of migrating Oracle databases to Dameng databases , the DMHS tool used can only be used for the case where the target database is Dameng database, and it is not universal

[0009] The Chinese patent "CN 106570086 A Data Migration System and Data Migration Method" needs to design the migration intermediate table in the source database, and set the migration intermediate database in the target database, which increases the workload of operators

Images