Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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

A database and computer program technology, applied in the field of database migration, can solve problems such as inability to export databases, high migration costs, incomplete compatibility, etc., and achieve the effect of accurately migrating databases, reducing migration costs, and improving data security

Active Publication Date: 2020-01-17
SHENZHEN QIANHAI HUANRONG LIANYI INFORMATION TECH SERVICES CO LTD
View PDF6 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database migration method and device from MySQL to Oracle and computer equipment
  • Database migration method and device from MySQL to Oracle and computer equipment
  • Database migration method and device from MySQL to Oracle and computer equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0047] It should be understood that when used in this specification and the appended claims, the terms "comprising" and "comprises" indicate the presence of described features, integers, steps, operations, elements and / or components, but do not exclude one or Presence or addition of multiple other features, integers, steps, operations, elements, components and / or collections thereof.

[0048] It should also be understood that the terminology used ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/21G06F16/22
CPCG06F16/214G06F16/2282Y02D10/00
Inventor 王志超
Owner SHENZHEN QIANHAI HUANRONG LIANYI INFORMATION TECH SERVICES CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com