Data migration method and system

A data and database technology, applied in the direction of database model, relational database, electronic digital data processing, etc., can solve the problems of long time, high accuracy and cost, and achieve the effect of reducing duplication, improving work efficiency and

Active Publication Date: 2016-09-21
SUZHOU LANGCHAO INTELLIGENT TECH CO LTD
View PDF8 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the face of complex business systems involving hundreds or thousands of tables, it takes a lot of time and effort to manually execute migration state

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

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0047] The technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative work shall fall within the protection scope of the present invention.

[0048] The embodiment of the invention discloses a data migration method and system to realize data migration and migration.

[0049] See figure 1 , A data migration method provided by an embodiment of the present invention includes:

[0050] S101. Obtain a table name parameter file, obtain database connection name information, obtain first quantity information of an executable program, and obtain second quantity information of sentences in ...

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 data migration method. The method comprises the steps of when data in a database is migrated, inputting migration parameters required for data migration into a programmed migration script framework; automatically generating a corresponding number of executable program sets according to the migration parameters; and migrating the data by running the executable program set, so that the problem of repetition, omission, errors or the like caused by manual execution of a migration process is reduced, the efforts of engineers are released, the migration process and a result are concerned, and the working efficiency and the data migration integrity and accuracy are improved, wherein the migration parameters are a table name parameter file, database connection name information, first quantity information of executable programs and second quantity information of statements in the executable programs. The invention furthermore discloses a data migration system, which can achieve the technical effect as well.

Description

technical field [0001] The present invention relates to the technical field of data migration, and more specifically, to a data migration method and system. Background technique [0002] The process of data migration from ORACLE to K-DB involves the migration of hundreds of gigabytes of large-capacity business tables. The common method is to use database connection or smooth text files for data migration. In the process of using database connection migration, you need to manually execute migration statements in multiple windows to achieve parallel migration and improve migration efficiency. In the face of complex business systems involving hundreds or thousands of tables, it takes a lot of time and effort to manually execute migration statements or write migration scripts, and manual migration or writing scripts has high requirements for accuracy, and no omissions can occur , errors, etc. [0003] Therefore, how to perform data migration is a problem to be solved by those ...

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): G06F17/30
CPCG06F16/214G06F16/284
Inventor 关坤龙杜彦魁
Owner SUZHOU LANGCHAO INTELLIGENT TECH 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