Supercharge Your Innovation With Domain-Expert AI Agents!

Database migration method, system and device based on Java development and storage medium

A database and data technology, applied in the field of computer communication, can solve the problem of single replacement method and achieve the effect of improving efficiency and accuracy

Pending Publication Date: 2020-08-28
重庆锐云科技有限公司
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Most of the existing database replacement operations use direct system replacement, the replacement method is too single, and it is easy to modify

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 based on Java development and storage medium
  • Database migration method, system and device based on Java development and storage medium
  • Database migration method, system and device based on Java development and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] In order to make the purpose, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below through specific implementation methods in conjunction with the accompanying drawings. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0020] In one embodiment, such as figure 1 As shown, a Java-based database migration method is provided, including the following steps:

[0021] S101 Receive and identify the initial data source information of the initial database input by the user.

[0022] Specifically, the user selects the data management menu in the user interface to enter the corresponding page, and enters the data source of the SQL Server and My SQL database in the corresponding information column, including the basic information of the data source, specifically the name of the data source, the sourc...

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 database migration method, system and device based on Java development and a storage medium, and the method comprises the steps: receiving and recognizing the input initial data source information of an initial database; receiving a connection test instruction, performing connection test on the initial data source information, and displaying a test result; obtaining product table information in the selected initial database, receiving a content extraction instruction, displaying a product table, and receiving and storing an edited initial product table; obtaining selected target database information; receiving a conversion generation instruction, obtaining a mapping relationship of converting data in the initial product table into a data structure in a target database, displaying the mapping relationship, and receiving and storing an edited target mapping relationship; and receiving a migration execution instruction, and migrating the initial product table to atarget product table in a target database according to the target mapping relationship. According to the technical scheme, by establishing an editable data mapping relationship, visual database migration is realized.

Description

technical field [0001] The invention relates to the technical field of computer communication, in particular to a database migration method, system, equipment and storage medium developed based on Java. Background technique [0002] In the existing business scenario, some old systems are unmaintained, the system is too old to meet the business needs, and there is no original software technical support. Through the development of the new research and development system to meet the existing business needs, there is a problem of replacing the database with the old and new systems. Condition. Most of the existing database replacement operations use direct system replacement, the replacement method is too simple, and it is easy to modify. Contents of the invention [0003] Based on this, it is necessary to provide a Java-based database migration method, system, device and storage medium for the above technical problems. [0004] A database migration method developed based 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
IPC IPC(8): G06F8/20G06F16/21G06F16/23G06F16/25
CPCG06F8/24G06F16/214G06F16/23G06F16/254
Inventor 李琦宋卫东
Owner 重庆锐云科技有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More