Database migration method, system, device and computer-readable storage medium

A database, preset technology, applied in the computer field to improve migration efficiency, expand coverage, and shorten migration time

Active Publication Date: 2022-03-01
深圳市明源云科技有限公司
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Aiming at solving technical problems on how to improve the quality of database migration

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, system, device and computer-readable storage medium
  • Database migration method, system, device and computer-readable storage medium
  • Database migration method, system, device and computer-readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] 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.

[0045] Such as figure 1 as shown, figure 1 It is a schematic diagram of the device structure of the hardware operating environment involved in the solution of the embodiment of the present invention.

[0046] Such as figure 1 As shown, the database migration device may include: a processor 1001 , such as a CPU, a communication bus 1002 , a user interface 1003 , a network interface 1004 , and a memory 1005 . Wherein, the communication bus 1002 is used to realize connection and communication between these components. The user interface 1003 may include a display screen (Display) and an input unit...

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 migration method, system, equipment and computer-readable storage medium. The method includes acquiring the current file in the database, determining the text for sentence conversion, and providing a data source for the data conversion of the database migration; through the file Feature determination extractor to reduce file extraction errors, extract sentences based on the extractor, extract sentences from files, perform targeted conversion, and obtain extracted sentences; after determining the characteristics of the target database, according to the extracted sentences and the target database Generate the target statement according to the characteristics of the target database, and convert the statement according to the characteristics of the target database to ensure that the converted statement can run normally in the target database, write back the target statement to the above current file, realize the conversion of the database file, and complete the database migration; expand the database migration Coverage, improve the quality of database migration; and realize database migration through automation, improve the efficiency of database migration.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a database migration method, system, equipment and computer-readable storage medium. Background technique [0002] SQL Server is a commercial, closed-source relational database developed by Microsoft Corporation of the United States, and it is one of the mainstream databases at present. Customers often have doubts about data security when using SQL Server. Due to the closed source feature, it is impossible to know its operating principle. In recent years, the country has paid more and more attention to information security. The rise of domestic databases and the advancement of localization have become an opportunity for database switching. In various fields, there are a large number of appeals for switching from SQLServer to mysql (relational database management system), pgsql (object-relational database management system), and Dameng. Database migration is a complex ...

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 Patents(China)
IPC IPC(8): G06F16/21G06F16/25G06F16/28
CPCG06F16/214G06F16/258G06F16/284
Inventor 曾吉丰
Owner 深圳市明源云科技有限公司
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