Data migration method and system applied to localization substitution

Abstract

The invention particularly relates to a data migration method and system applied to localization substitution. According to the data migration method and system applied to the localization substitution, connection with a source database is established through a JDBC API interface, a metadata interface is called to obtain a result set, and the result set is processed to obtain table names, primary keys, foreign keys, indexes and information of columns in the tables of all tables in the source database; extracting data information in the original data table, and storing the data information in a JSON (JavaScript Object Notation) file; converting the data type according to a data type conversion method, generating a table establishment SQL statement, connecting a target database, establishing a table structure and analyzing data information in the JSON; and inserting data into the created new table to complete data migration. According to the data migration method and system applied to domestic substitution, the problem of data migration of a domestic database is solved, smooth migration of a database structure, content and a system thereof can be rapidly, correctly and efficiently realized, the data management efficiency is improved, and the data security is ensured.

Description

technical field [0001] The invention relates to the technical field of data migration, in particular to a data migration method and system applied to localization substitution. Background technique [0002] In recent years, many basic software and hardware products with independent intellectual property rights, represented by domestic operating systems and CPUs, have emerged. The ecological environment of domestic operating systems such as the winning Kirin system and deepin operating system is becoming more and more perfect, and high-end general-purpose chips with independent intellectual property rights such as Loongson and Feiteng are flourishing, and the technical level has reached or approached the world advanced level of similar products. [0003] With the vigorous development of domestic basic software and hardware, the promotion and use of domestic basic software and hardware has brought unprecedented opportunities. As an important part of the ecological environment...

AI Technical Summary

Problems solved by technology

[0007] ① The character sets of the new and old databases are different. If the migration method is not selected properly, there may be garbled characters, especially Chinese garbled characters;

[0008] ② Some unique functions and technologies of the old database may not be recognized by the new database after migration, or may cause conflicts with certain features of the new database;

Images