Database object migration method and system

A technology for migrating systems and databases, which is applied in the field of database object migration methods and systems, and can solve problems such as losing important information

Pending Publication Date: 2020-10-09
WUHAN HONGXIN TECH SERVICE CO LTD
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, the current tools with database migration functions, such as Sqlserver studio management and navicat, etc., either need to manually adjust the field type mapping between ...

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 object migration method and system
  • Database object migration method and system
  • Database object migration method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention. In addition, the technical features involved in the various embodiments of the present invention described below can be combined with each other as long as they do not constitute a conflict with each other.

[0033] A database object structure migration system according to an embodiment of the present invention includes a reading module, a cache module, a heterogeneous mapping module and an export module. The reading module is used for accessing the data dictionary in the source database, reading the structure information of the source database object from the data dictionary, and mapping the structu...

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 discloses a database object structure migration system and method. The system comprises a reading module used for accessing a data dictionary in a source database, reading structure information of a source database object from the data dictionary, and mapping the structure information of the source database object into a class-oriented object in an object corresponding to the structure information; a caching module used for recording the state of the object structure information of the source database and the change of the state of the structure information; a heterogeneous mapping module used for modifying the cached structure information of the source database object into object structure information which conforms to a target database standard and has the same function; and an exporting module used for converting the modified object structure information into a script file meeting a target database standard. The method can be suitable for database object structure migration among different relational databases, and has the advantages of automation, batch and comprehensive migration information.

Description

technical field [0001] The invention belongs to the technical field of databases, and more specifically relates to a database object migration method and system. Background technique [0002] Relational databases are widely used, and different relational databases have different emphases in reuse. Taking SqlServer and Mysql databases as examples, Sqlserver, as a large and medium-sized database, is often used in large and medium-sized projects. Sqlserver has relatively complete functions and powerful performance Yes, but Sqlserver has higher requirements for server configuration and takes longer to deploy; while Mysql is often used in small and medium-sized projects. Although Mysql has weaker performance, it has lower requirements for server configuration. [0003] Considering various factors such as cost, it may happen that Mysql is used to replace Sqlserver, so there is a need to migrate the Sqlserver database to the Mysql database. [0004] However, the current tools with...

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
IPC IPC(8): G06F16/21G06F16/28
CPCG06F16/214G06F16/284
Inventor 黄鑫胡西平黄晓艳肖伟明
Owner WUHAN HONGXIN TECH SERVICE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap