Data migration method and data migration system

A technology for migrating systems and data, applied in digital data processing, structured data retrieval, special data processing applications, etc., can solve the potential risks of project delivery data errors, inability to assess and avoid risks, and data that cannot be configured through existing functions Ways to solve problems such as avoiding data migration interruption, reducing development costs, and improving stability

Inactive Publication Date: 2017-05-31
YONYOU NETWORK TECH
View PDF8 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Although the relevant technology has completed the promotion of heterogeneous system data, there are the following shortcomings: 1. There is no source system data inspection rule before data migration, and risks cannot be assessed and avoided before migration; 2. The data structure of the source system and the target system The comparison cannot be flexibly configured. If the field comparison needs to be modified, the problem can only be solved by modifying the source code; 3. The customized data of the project cannot be solved

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

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0119] Specific embodiment one, configure the data structure comparison relationship between the source system and the target system through excel. After the configuration is completed, the source system data is imported into the target system through the front-end import function, and the source system database tables are converted according to the comparison relationship in the subsequent migration logic The field value is migrated to the corresponding database table field value of the target system. The Excel configuration import mode control template is shown in Table 2:

[0120] Table 2Excel configuration import mode control template

[0121]

Example Embodiment

[0122] Specific embodiment two, the front-end interface configuration comparison mode, the left is the target system library table structure (data dictionary), the right is the source system library table structure (data dictionary), the library table structure of the source system and the target system is through the library table The name is loaded from the source system library and the target database. The database table structure of the target database is listed in the interface in alphabetical order. The corresponding document database table structure of the source system is designed into two modes: reference mode and manual input mode. According to different rule types, select the reference mode or manual input mode. If the rule type is assignment , The manual entry mode is adopted. For other rule types, the library table structure of the corresponding document table is enumerated by reference, and then compared with the field name corresponding to the target system. The a...

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 data migration method and a data migration system. The data migration method comprises the following steps: before migrating source system data to a target system, performing legality checking on the source system data according to a preset checking rule, and processing the source system data according to a checking result; performing comparative configuration on a source system data structure and a target system data structure according to a comparative configuration mode; after the source system data passes legality checking, migrating the source system data to the target system; when the source system data does not pass legality checking, repairing and regulating the source system data until the source system data passes legality checking; recording log information in legality checking, comparative configuration and migration processes. According to the technical scheme, data migration logic is processed in a configurable manner, so that the data migration work is more flexible and easier, and the heterogeneous system data migration is simpler and more efficient.

Description

technical field [0001] The present invention relates to the technical field of data migration, in particular to a data migration method and a data migration system. Background technique [0002] Enterprise Resource Planning system (Enterprise Resource Planning, ERP) refers to a management platform based on information technology and providing decision-making and operation means for enterprise decision-makers and employees with systematic management ideas. Today, with the comprehensive development of information technology, more and more enterprises choose ERP system to manage all aspects of enterprise resources and business. [0003] However, under the background of such rapid economic development, e-commerce entering a climax of development, and corporate Internet raids, the existing ERP system often cannot meet the needs of all customers' businesses. Customized development, followed by the need for upgrading the ERP system. The ERP system has its inherent complexity, and...

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/27G06F16/214
Inventor 万多乐
Owner YONYOU NETWORK TECH
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