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

A database and grammar technology, applied in the computer field, to achieve the effects of reducing file extraction errors, improving migration quality, and shortening migration time

Active Publication Date: 2021-12-21
深圳市明源云科技有限公司
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 and device and computer readable storage medium
  • Database migration method, system and device and computer readable storage medium
  • Database migration method, system and 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 and device and a computer readable storage medium. The method comprises the steps that a current file in a database is obtained, a text for statement conversion is determined, and a data source is provided for data conversion of database migration; an extractor is determined through file features, file extraction errors are reduced, statements are extracted based on the extractor, statements are extracted from the file, targeted conversion is carried out, and extracted statements are obtained; after target database features are determined, target statements are generated according to the extracted statements and the target database features, statement conversion is performed according to the target database features to ensure that the converted statements can normally run in the target database, the target statements are written back to the current file to realize database file conversion, and database migration is completed. The database migration coverage range is expanded, and the database migration quality is improved; and database migration is automatically realized, so that the database migration efficiency is improved.

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 Applications(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

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