Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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 through the existing function configuration method, and can only be developed through the customized project ;4. Customized business rules cannot be dynamically extended to existing products, and can only be solved through customized project development; 5. After data migration to the target system, there is no reconciliation process between the source system and the target system, and the correctness of the data cannot be automatically generated Validate the report, the potential risk of project delivery data error is too great

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

specific Embodiment 1

[0119] Specific embodiment 1, configure the data structure comparison relationship between the source system and the target system through excel, after the configuration is completed, import the source system data into the target system through the foreground import function, and import the source system database table into the target system according to the comparison relationship in the subsequent migration logic Field values ​​are migrated to the corresponding database table field values ​​of the target system. The excel configuration import mode comparison template is shown in Table 2:

[0120] Table 2excel configuration import mode comparison template

[0121]

specific Embodiment 2

[0122] Specific embodiment two, foreground interface configuration comparison mode, the left side is the target system library table structure (data dictionary), the right side is the source system library table structure (data dictionary), the library table structure of the source system and the target system are all through the library table The names are loaded from the source system library and the target database. The table structure of the target database is listed on the interface in alphabetical order. The structure of the corresponding document database of the source system is designed into two modes: reference mode and manual input mode. Choose the reference mode or manual input mode according to different rule types. If the rule type is assignment , the manual input mode is adopted. If it is another rule type, the library table structure of the corresponding document table is enumerated by reference, and then compared with the corresponding field name of the target s...

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 Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com