Database migration method and device from MySQL to Oracle and computer equipment

Abstract

The invention relates to a database migration method and device from MySQL to Oracle and computer equipment. The method comprises the steps of selecting an initial MySQL database; acquiring table nameinformation of all database tables of the initial MySQL database; circularly traversing the database table according to the table name information to obtain initial table structure definition information; according to the database table and the initial table structure definition information, converting to obtain target table structure definition information meeting Oracle requirements; and generating a target Oracle database according to the database table and the target table structure definition information. According to the scheme, the table name information and the initial table structuredefinition information are obtained, the initial table structure definition information is converted to obtain the target table structure definition information, and finally the corresponding targetOracle database is generated, so that the database can be selected for migration according to actual needs, and migration cost is reduced while accurate migration of the database is guaranteed.

Description

technical field [0001] The present invention relates to data migration, and more specifically refers to a database migration method, device and computer equipment from MySQL to Oracle. Background technique [0002] MySQL is a relational database management system. Relational databases store data in different tables instead of putting all the data in one big warehouse, which increases speed and improves flexibility. [0003] ORACLE is currently the most widely used database management system in the world. As a general database system, it has complete data management functions; as a relational database, it is a complete relational product; as a distributed database, it realizes distributed Processing function. [0004] MySQL and Oracel are commonly used database management systems in enterprise business systems, but there is a problem of incomplete compatibility. When the database of the business system is migrated from MySQL to Oracle, it is often necessary to migrate the co...

AI Technical Summary

Problems solved by technology

[0004] MySQL and Oracel are commonly used database management systems in enterprise business systems, but there is a problem of incomplete compatibility. When the database of the business system is migrated from MySQL to Oracle, it is often necessary to migrate the corresponding table structure and data. Now the commonly used database The migration tools in the client usually cannot export the databases they need according to specific business needs. During the migration process, when there are many databases, it will bring high migration costs.

[0005] In the existing database migration tools, most of the migration operations do not have customizable settings. Even if there are, there are relatively few configurable places. For the production database migration script, whether it is a format or a statement, it may not be It is what you want, so during the migration process, if there are more databases, it will bring higher migration costs

Images