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

Data migration method and device between different types of databases and storage medium

A database and data technology, applied in database indexing, database management system, database design/maintenance, etc., can solve problems such as differences in syntax of table creation scripts, high abnormal risk, and heavy workload, so as to achieve low difficulty in getting started and increase usage scene, the effect of reducing the workload

Inactive Publication Date: 2021-05-04
叮当快药科技集团有限公司
View PDF5 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, in actual use, there will be situations where data needs to be migrated between database products of different manufacturers (such as Oracle to MySQL). At this time, it is necessary to create a table structure in the new database in advance. Table script syntax is different, and database table creation cannot be completed through simple import and export. Currently, database client tools only support table structure synchronization between database products of the same manufacturer. Table structure synchronization between cross-vendor database products requires manual modification and creation of tables. Statement script, heavy workload, high abnormal risk

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
  • Data migration method and device between different types of databases and storage medium
  • Data migration method and device between different types of databases and storage medium
  • Data migration method and device between different types of databases and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is only some embodiments of the present invention, but not all embodiments. 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.

[0051] The terms "first", "second", "third", "fourth", etc. (if any) in the description and claims of the present invention and the above drawings are used to distinguish similar objects and not necessarily Describe a specific order or sequence. It is to be understood that the data so used are interchangeable under appropriate circumstances ...

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 provides a data migration method and device between different types of databases and a storage medium, data in a source database is migrated to a target database, and the method comprises the following steps: obtaining source table structure information in the source database; obtaining a data storage rule of a target database, and generating a corresponding table construction script based on the data storage rule and the source table structure information; running the corresponding table construction script in a target database, migrating data in the source database to the target database, converting the data, and storing the converted data; and performing visualization processing on the process of migrating the data in the source database to the target database. Compared with directly exporting the table building script and executing after manual modification, the method has the advantages that the workload is greatly reduced, the error risk caused by a large amount of manual operation is avoided to a certain extent, the database migration working difficulty is reduced, and the practicability is relatively high.

Description

technical field [0001] The invention relates to data migration technology, in particular to a data migration method, device and storage medium between different types of databases. Background technique [0002] With the development of the times, people will generate a large amount of data in the process of production, life, and scientific research, and then store the large amount of data in different databases. Since different database products have different advantages, different scenarios will return to Choose a different database product for data storage. [0003] However, in the actual use process, there will be situations where data needs to be migrated between database products of different manufacturers (such as Oracle to MySQL). At this time, it is necessary to create a table structure in the new database in advance. Table script syntax is different, and database table creation cannot be completed through simple import and export. Currently, database client tools on...

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/22G06F16/25
CPCG06F16/214G06F16/2282G06F16/254
Inventor 朱明宙赖寿生宋子龙
Owner 叮当快药科技集团有限公司
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