Data migration method and device, terminal equipment and computer readable storage medium

By establishing field mapping tables and data conversion logic, the field compatibility problem of heterogeneous data sources is solved, data migration efficiency is improved, and data accuracy and completeness are achieved.

CN118939635APending Publication Date: 2024-11-12GUANGDONG YUEDIAN INFORMATION TECH CO LTD

Patent Information

Application Number
CN202411084440.X
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-08
Publication Date
2024-11-12

AI Technical Summary

Technical Problem

During the software upgrade process, the existing technology is difficult to effectively solve the problem of field compatibility when facing heterogeneous data sources.

Method used

By obtaining the data structures of the source system and the target system, establishing field mapping tables and data conversion logic, and performing data migration, including field conversion, data cleaning and missing field processing, ensuring the accuracy and efficiency of data migration.

Benefits of technology

It solves the field compatibility problem of heterogeneous data sources, improves data migration efficiency, reduces workload, and ensures data integrity and accuracy.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118939635A_ABST
    Figure CN118939635A_ABST
Patent Text Reader

Abstract

The invention provides a data migration method and device, terminal equipment and a computer readable storage medium. The data migration method comprises the steps of obtaining a data structure of a source system and a data structure of a target system; establishing a mapping relation between the source system and the target system according to the data structure of the source system and the data structure of the target system; wherein the mapping relation comprises a field mapping table and data conversion logic; and executing data migration between the source system and the target system according to the field mapping table and the data conversion logic. According to the data structures of the source system and the target system, the field mapping table and the data conversion logic between the source system and the target system are established, so that data migration is executed, and compared with the technical scheme of migration based on the version of the system in the prior art, the field compatibility problem existing in heterogeneous data sources can be solved, the data migration efficiency is improved, and the data migration cost is reduced. And the workload in the migration process is reduced.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of data processing, and in particular to a data migration method, device, terminal equipment and computer-readable storage medium. Background Art

[0002] Under the wave of global digital economy, digital transformation has become an inevitable choice for enterprises to adapt to the digital economy and seek survival and development. Digital transformation is based on the digital transformation and digital upgrading of enterprises, using digital technology to carry out all-round and systematic changes and reshape the enterprise's strategic system, business model, business process, production operation and organizational structure.

[0003] Under multiple circumstances, various industries are faced with software upgrades, and in this process, they will inevitably face the problem of data migration. At present, each data vendor provides migration tools between its own versions based on its own starting point, but there will be field compatibility issues when facing heterogeneous data sources. Summary of the invention

[0004] The present invention provides a data migration method, apparatus, terminal device and computer-readable storage medium to solve the technical problem of field compatibility that may exist when facing heterogeneous data sources.

[0005] In order to solve the above technical problems, an embodiment of the present invention provides a data migration method, including:

[0006] Obtain the data structure of the source system and the data structure of the target system;

[0007] According to the data structure of the source system and the data structure of the target system, a mapping relationship between the source system and the target system is established; wherein the mapping relationship includes a field mapping table and data conversion logic;

[0008] Data migration between the source system and the target system is performed according to the field mapping table and the data conversion logic.

[0009] As a preferred solution, establishing a mapping relationship between the source system and the target system according to the data structure of the source system and the data structure of the target system includes:

[0010] Acquire table information and field information of the source system, and acquire field information and table information of the target system;

[0011] According to the table information and field information of the source system, the data type and constraint conditions of the source system are analyzed; according to the table information and field information of the target system, the data type of the target system is determined;

[0012] According to the data type and constraint condition of the source system and the data type of the target system, combined with the field information of the source system and the field information of the target system, a mapping relationship between the source system and the target system is established.

[0013] As a preferred solution, the establishing a mapping relationship between the source system and the target system according to the data type and constraint condition of the source system and the data type of the target system, combined with the field information of the source system and the field information of the target system, includes:

[0014] When the field information of the source system is similar to the field information of the target system, a field mapping table between the field information of the source and the field information of the target system is obtained; wherein the similarity of the field information includes the same name or similar function of the field;

[0015] When there is a difference between the field information of the source system and the field information of the target system, a mapping rule between the field information of the source system and the field information of the target system is determined, thereby obtaining a field mapping table and data conversion logic;

[0016] According to the obtained field mapping table, data conversion relationship, data type and constraint condition of the source system and data type of the target system, a mapping relationship between the source system and the target system is obtained.

[0017] As a preferred solution, before performing the data migration between the source system and the target system, the method further includes:

[0018] According to the field mapping table, field conversion or data cleaning is performed, and the field conversion includes data type conversion or data format conversion.

[0019] As a preferred solution, before performing the data migration between the source system and the target system, the method further includes:

[0020] Detect missing fields of data in the source system, assign default values ​​to the missing fields, or generate corresponding values ​​according to preset business rules.

[0021] As a preferred solution, the data migration method further includes:

[0022] Provide data mirroring for secondary import based on the log records of data migration results;

[0023] According to the data mirroring, a mirroring environment is constructed, and in the mirroring environment, a content tool is used to deduplicate the data of the source system that needs to be imported a second time, and the deduplicated data is merged with the data of the target system.

[0024] Accordingly, an embodiment of the present invention further provides a data migration device, comprising an acquisition module, a mapping establishment module and a migration module; wherein:

[0025] The acquisition module is used to acquire the data structure of the source system and the data structure of the target system;

[0026] The mapping establishment module is used to establish a mapping relationship between the source system and the target system according to the data structure of the source system and the data structure of the target system; wherein the mapping relationship includes a field mapping table and data conversion logic;

[0027] The migration module is used to perform data migration between the source system and the target system according to the field mapping table and the data conversion logic.

[0028] As a preferred solution, the mapping establishment module establishes a mapping relationship between the source system and the target system according to the data structure of the source system and the data structure of the target system, including:

[0029] The mapping establishment module obtains the table information and field information of the source system, and obtains the field information and table information of the target system;

[0030] According to the table information and field information of the source system, the data type and constraint conditions of the source system are analyzed; according to the table information and field information of the target system, the data type of the target system is determined;

[0031] According to the data type and constraint condition of the source system and the data type of the target system, combined with the field information of the source system and the field information of the target system, a mapping relationship between the source system and the target system is established.

[0032] As a preferred solution, the mapping establishment module establishes a mapping relationship between the source system and the target system according to the data type and constraint conditions of the source system and the data type of the target system, combined with the field information of the source system and the field information of the target system, including:

[0033] When the field information of the source system is similar to the field information of the target system, the mapping establishment module obtains a field mapping table between the field information of the source and the field information of the target system; wherein the similarity of the field information includes the same name or similar function of the field;

[0034] When there is a difference between the field information of the source system and the field information of the target system, the mapping establishment module determines a mapping rule between the field information of the source system and the field information of the target system, thereby obtaining a field mapping table and data conversion logic;

[0035] The mapping establishment module obtains the mapping relationship between the source system and the target system according to the obtained field mapping table, data conversion relationship, data type and constraint condition of the source system and data type of the target system.

[0036] As a preferred solution, the data migration device further includes a field processing module, and the field processing module is used for: before the migration module performs data migration between the source system and the target system:

[0037] According to the field mapping table, field conversion or data cleaning is performed, and the field conversion includes data type conversion or data format conversion.

[0038] As a preferred solution, the data migration device further includes a secondary import module, and the secondary import module is used to provide a data mirror for the secondary import according to the log record of the data migration result;

[0039] According to the data mirroring, a mirroring environment is constructed, and in the mirroring environment, a content tool is used to deduplicate the data of the source system that needs to be imported a second time, and the deduplicated data is merged with the data of the target system.

[0040] As a preferred solution, the data migration device further includes a missing field processing module, and the missing field processing module is used to: before the migration module performs data migration between the source system and the target system:

[0041] Detect missing fields of data in the source system, assign default values ​​to the missing fields, or generate corresponding values ​​according to preset business rules.

[0042] Correspondingly, an embodiment of the present invention further provides a terminal device, including a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor, wherein the processor implements the data migration method when executing the computer program.

[0043] Correspondingly, an embodiment of the present invention further provides a computer-readable storage medium, wherein the computer-readable storage medium includes a stored computer program, wherein when the computer program is running, the device where the computer-readable storage medium is located is controlled to execute the data migration method.

[0044] Compared with the prior art, the embodiments of the present invention have the following beneficial effects:

[0045] The embodiment of the present invention provides a data migration method, apparatus, terminal device and computer-readable storage medium, wherein the data migration method comprises: obtaining the data structure of a source system and the data structure of a target system; establishing a mapping relationship between the source system and the target system according to the data structure of the source system and the data structure of the target system; wherein the mapping relationship comprises a field mapping table and data conversion logic; and executing data migration between the source system and the target system according to the field mapping table and the data conversion logic. The present invention establishes a field mapping table and data conversion logic between the source system and the target system according to the data structures of the source system and the target system, thereby executing data migration. Compared with the technical solution of the prior art that migrates based on its own version, the present invention can solve the field compatibility problem that may exist when heterogeneous data sources are used, improve the efficiency of data migration, and reduce the workload during the migration process. BRIEF DESCRIPTION OF THE DRAWINGS

[0046] Figure 1 : A flow chart of an embodiment of the data migration method provided by the present invention.

[0047] Figure 2 : A structural schematic diagram of an embodiment of the data migration device provided by the present invention. DETAILED DESCRIPTION

[0048] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0049] Embodiment one:

[0050] Please refer to Figure 1 , Figure 1 A data migration method provided by an embodiment of the present invention includes steps S1 to S3; wherein:

[0051] Step S1, obtaining the data structure of the source system and the data structure of the target system.

[0052] In this step, the data structure includes but is not limited to table information, field information, data format, data length, etc. of the system data. In this embodiment, a URL link can be configured and driven to read information of both the target data source and the original data source for construction of the mapping relationship in the subsequent steps.

[0053] Among them, for the table information of the source system, the main information obtained includes the table structure. Through the table structure, you can understand the tables and fields involved in the source data and the relationship between them, including but not limited to constraints such as primary keys and foreign keys.

[0054] In addition, for the data type of the source system, you need to clarify the data type of each field, such as integer, character, and date.

[0055] For the data length of the source system, it can determine the maximum length or value range of each field in the source system.

[0056] For the data format of the source system, for example, it can be a date format, such as YYYY-MM-DD, DD / MM / YYYY, etc.; it can also be a number or currency format, such as the number of digits after the decimal point and the use of thousands separators, etc.; or a string format, such as the processing of special characters, case specifications, etc.

[0057] For the target system, the main thing to do is to obtain the table structure, which is used to analyze the table structure of the target database and determine whether it needs to be adjusted to adapt to the source system data. At the same time, it is also necessary to obtain the data format of the target system to ensure that the target system database supports the format of the source system data, such as date, number and currency format; and ensure that the format in the target data is unified to facilitate subsequent data processing and analysis.

[0058] Before building a mapping relationship, you can perform a compatibility analysis. Different systems may use different character encoding standards, such as ASC II, UTF-8, GBK, etc. When migrating data, you must ensure that the encoding of the source data and the target system is compatible.

[0059] Step S2: establishing a mapping relationship between the source system and the target system according to the data structure of the source system and the data structure of the target system; wherein the mapping relationship includes a field mapping table and data conversion logic.

[0060] In this embodiment, establishing a mapping relationship between the source system and the target system according to the data structure of the source system and the data structure of the target system includes:

[0061] Obtain the table information and field information of the source system, and obtain the field information and table information of the target system; parse the data type and constraint conditions of the source system according to the table information and field information of the source system; determine the data type of the target system according to the table information and field information of the target system; in this process, it should be noted that the target system database may have existing data and structure. According to the data type and constraint conditions of the source system and the data type of the target system, combined with the field information of the source system and the field information of the target system, establish a mapping relationship between the source system and the target system.

[0062] Further, establishing a mapping relationship between the source system and the target system according to the data type and constraint condition of the source system and the data type of the target system, in combination with the field information of the source system and the field information of the target system, includes:

[0063] When the field information of the source system is similar to the field information of the target system, a field mapping table between the field information of the source and the field information of the target system can be directly obtained; wherein the similarity of the field information includes the same name or similar function of the field;

[0064] When there is a difference between the field information of the source system and the field information of the target system (for example, a difference in data type, length, precision or business meaning), a mapping rule between the field information of the source system and the field information of the target system is determined, thereby obtaining a field mapping table and data conversion logic; the mapping rule can provide an interface for the user to set according to actual conditions, for example, the data type can be converted, the data length can be adjusted, or business logic can be applied to ensure the correctness of the data.

[0065] According to the obtained field mapping table, data conversion relationship, data type and constraint condition of the source system and data type of the target system, a mapping relationship between the source system and the target system is obtained.

[0066] In addition, if there are fields in the source system that do not exist in the target system, an interface can be provided for users to create new fields to receive these data, or ignore these fields; when a field of the source system data needs to be mapped to multiple fields of the target system data, an interface can be provided for users to define splitting rules and split the data according to the rules; when a field of the target data needs to be composed of multiple fields of the source data, an interface can be provided for users to define merging rules; for fields that need to be calculated or converted, corresponding calculation or conversion logic can be defined.

[0067] After the mapping relationship is determined, the mapping relationship can be verified, for example, by extracting a small amount of sample data, converting it according to the mapping rules, and then comparing it with the target system data to ensure the correctness of the mapping relationship.

[0068] The mapping relationship includes types such as field mapping table, configuration file and data conversion logic, and the specific type of mapping relationship can be determined according to actual needs. The field mapping table can be stored in a format including but not limited to table, JSON and / or XML.

[0069] As a preferred implementation, before executing the data migration between the source system and the target system in step S3, it also includes: performing field conversion or data cleaning according to a field mapping table, and the field conversion includes data type conversion or data format conversion.

[0070] In this embodiment, for data type conversion, the programming language or database conversion function can be used for processing according to the specific business scenario; for data format conversion, regular expressions, string processing functions, etc. can be used for conversion according to the specific business scenario; in addition, users can customize rules for business tables, remove duplicate data or repair data according to customized rules, etc., to achieve data cleaning.

[0071] As a preferred implementation, before executing the data migration between the source system and the target system in step S3, it also includes: detecting missing fields of the data in the source system, providing an entry for the user to set rules, assigning default values ​​to the missing fields, or generating the corresponding values ​​according to preset business rules; in this process, it is possible to set default values ​​according to business needs, or mark missing fields in the target data.

[0072] Step S3: performing data migration between the source system and the target system according to the field mapping table and the data conversion logic.

[0073] In this step, data migration can use built-in migration methods to perform data migration and field mapping operations according to the user's selection method; for large-scale data migration scenarios, parallel processing and batch processing can be provided to ensure the stability of migration.

[0074] In addition, you can define error handling and rollback strategies to deal with errors and exceptions during data migration and field mapping; as well as record error logs, including error information, processing steps, and scope of impact; when an error occurs, perform corresponding error handling and rollback operations based on the error type and severity.

[0075] In some implementations, after completing data migration in some application scenarios, since data migration is not a one-time job, there may be a need for secondary import or secondary migration. At this time, problems such as data duplication, conflict or overwriting need to be resolved.

[0076] Therefore, the data migration method also includes: providing a data mirror for secondary import according to the log record of the data migration result; building a mirror environment according to the data mirror, and using content tools to deduplicate the data of the source system that needs to be secondary imported in the mirror environment, merging the deduplicated data with the data of the target system instead of overwriting or repeatedly importing, and merging the imported data with the target data according to business rules and field mapping relationships to ensure the integrity and accuracy of the data.

[0077] When the target data has unique identifiers, these identifiers can be used for matching and comparison when importing data. If the identifier in the imported data already exists in the target data, the existing data will be updated or the data will be skipped according to the rules set by the user.

[0078] Accordingly, refer to Figure 2 The embodiment of the present invention further provides a data migration device, including an acquisition module 101, a mapping establishment module 102 and a migration module 103; wherein,

[0079] The acquisition module 101 is used to acquire the data structure of the source system and the data structure of the target system;

[0080] The mapping establishment module 102 is used to establish a mapping relationship between the source system and the target system according to the data structure of the source system and the data structure of the target system; wherein the mapping relationship includes a field mapping table and data conversion logic;

[0081] The migration module 103 is used to perform data migration between the source system and the target system according to the field mapping table and the data conversion logic.

[0082] As a preferred solution, the mapping establishment module 102 establishes a mapping relationship between the source system and the target system according to the data structure of the source system and the data structure of the target system, including:

[0083] The mapping establishment module 102 obtains the table information and field information of the source system, and obtains the field information and table information of the target system;

[0084] According to the table information and field information of the source system, the data type and constraint conditions of the source system are analyzed; according to the table information and field information of the target system, the data type of the target system is determined;

[0085] According to the data type and constraint condition of the source system and the data type of the target system, combined with the field information of the source system and the field information of the target system, a mapping relationship between the source system and the target system is established.

[0086] As a preferred solution, the mapping establishment module 102 establishes a mapping relationship between the source system and the target system according to the data type and constraint conditions of the source system and the data type of the target system, combined with the field information of the source system and the field information of the target system, including:

[0087] When the field information of the source system is similar to the field information of the target system, the mapping establishment module 102 obtains a field mapping table between the field information of the source and the field information of the target system; wherein the similarity of the field information includes the same name or similar function of the field;

[0088] When there is a difference between the field information of the source system and the field information of the target system, the mapping establishment module 102 determines a mapping rule between the field information of the source system and the field information of the target system, thereby obtaining a field mapping table and data conversion logic;

[0089] The mapping establishment module 102 obtains a mapping relationship between the source system and the target system according to the obtained field mapping table, data conversion relationship, data type and constraint condition of the source system and data type of the target system.

[0090] As a preferred solution, the data migration device further includes a field processing module, and the field processing module is used for: before the migration module performs data migration between the source system and the target system:

[0091] According to the field mapping table, field conversion or data cleaning is performed, and the field conversion includes data type conversion or data format conversion.

[0092] As a preferred solution, the data migration device further includes a secondary import module, and the secondary import module is used to provide a data mirror for the secondary import according to the log record of the data migration result;

[0093] According to the data mirroring, a mirroring environment is constructed, and in the mirroring environment, a content tool is used to deduplicate the data of the source system that needs to be imported a second time, and the deduplicated data is merged with the data of the target system.

[0094] As a preferred solution, the data migration device further includes a missing field processing module, and the missing field processing module is used to: before the migration module performs data migration between the source system and the target system:

[0095] Detect missing fields of data in the source system, assign default values ​​to the missing fields, or generate corresponding values ​​according to preset business rules.

[0096] Correspondingly, an embodiment of the present invention further provides a terminal device, including a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor, wherein the processor implements the data migration method when executing the computer program.

[0097] The processor may be a central processing unit (CPU), other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a microprocessor or any conventional processor, etc. The processor is the control center of the terminal, and various interfaces and lines are used to connect various parts of the entire terminal.

[0098] The memory can be used to store the computer program, and the processor realizes various functions of the terminal by running or executing the computer program stored in the memory and calling the data stored in the memory. The memory can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, an application required for at least one function (such as a sound playback function, an image playback function, etc.), etc.; the data storage area can store data created according to the use of the mobile phone (such as audio data, a phone book, etc.), etc. In addition, the memory can include a high-speed random access memory, and can also include a non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (Secure Digital, SD) card, a flash card (Flash Card), at least one disk storage device, a flash memory device, or other volatile solid-state storage devices.

[0099] Correspondingly, an embodiment of the present invention further provides a computer-readable storage medium, wherein the computer-readable storage medium includes a stored computer program, wherein when the computer program is running, the device where the computer-readable storage medium is located is controlled to execute the data migration method.

[0100] Wherein, if the module integrated in the data migration device is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on such an understanding, the present invention implements all or part of the processes in the above-mentioned embodiment method, and can also be completed by instructing the relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium, and the computer program can implement the steps of the above-mentioned various method embodiments when executed by the processor. Wherein, the computer program includes computer program code, and the computer program code can be in source code form, object code form, executable file or some intermediate form, etc. The computer-readable medium can include: any entity or device capable of carrying the computer program code, recording medium, U disk, mobile hard disk, magnetic disk, optical disk, computer memory, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium, etc.

[0101] Compared with the prior art, the embodiments of the present invention have the following beneficial effects:

[0102] The embodiment of the present invention provides a data migration method, apparatus, terminal device and computer-readable storage medium, wherein the data migration method comprises: obtaining the data structure of a source system and the data structure of a target system; establishing a mapping relationship between the source system and the target system according to the data structure of the source system and the data structure of the target system; wherein the mapping relationship comprises a field mapping table and data conversion logic; and executing data migration between the source system and the target system according to the field mapping table and the data conversion logic. The present invention establishes a field mapping table and data conversion logic between the source system and the target system according to the data structures of the source system and the target system, thereby executing data migration. Compared with the technical solution of the prior art that migrates based on its own version, the present invention can solve the field compatibility problem that may exist when heterogeneous data sources are used, improve the efficiency of data migration, and reduce the workload during the migration process.

[0103] The specific embodiments described above further illustrate the purpose, technical solutions and beneficial effects of the present invention. It should be understood that the above description is only a specific embodiment of the present invention and is not intended to limit the scope of protection of the present invention. It is particularly pointed out that for those skilled in the art, any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the scope of protection of the present invention.

Claims

1. A data migration method, It is characterized in that include: Obtain the data structure of the source system and the data structure of the target system; According to the data structure of the source system and the data structure of the target system, a mapping relationship between the source system and the target system is established; wherein the mapping relationship includes a field mapping table and data conversion logic; Data migration between the source system and the target system is performed according to the field mapping table and the data conversion logic.

2. A data migration method as claimed in claim 1, It is characterized in that The establishing a mapping relationship between the source system and the target system according to the data structure of the source system and the data structure of the target system includes: Acquire table information and field information of the source system, and acquire field information and table information of the target system; According to the table information and field information of the source system, the data type and constraint conditions of the source system are analyzed; according to the table information and field information of the target system, the data type of the target system is determined; According to the data type and constraint condition of the source system and the data type of the target system, combined with the field information of the source system and the field information of the target system, a mapping relationship between the source system and the target system is established.

3. A data migration method as claimed in claim 2, It is characterized in that The establishing a mapping relationship between the source system and the target system according to the data type and constraint condition of the source system and the data type of the target system, in combination with the field information of the source system and the field information of the target system, includes: When the field information of the source system is similar to the field information of the target system, a field mapping table between the field information of the source and the field information of the target system is obtained; wherein the similarity of the field information includes the same name or similar function of the field; When there is a difference between the field information of the source system and the field information of the target system, a mapping rule between the field information of the source system and the field information of the target system is determined, thereby obtaining a field mapping table and data conversion logic; According to the obtained field mapping table, data conversion relationship, data type and constraint condition of the source system and data type of the target system, a mapping relationship between the source system and the target system is obtained.

4. A data migration method as claimed in claim 1, It is characterized in that Before performing data migration between the source system and the target system, the method further includes: According to the field mapping table, field conversion or data cleaning is performed, and the field conversion includes data type conversion or data format conversion.

5. A data migration method as claimed in claim 1, It is characterized in that Before performing data migration between the source system and the target system, the method further includes: Detect missing fields of data in the source system, assign default values ​​to the missing fields, or generate corresponding values ​​according to preset business rules.

6. A data migration method as claimed in claim 1, It is characterized in that The data migration method further includes: Provide data mirroring for secondary import based on the log records of data migration results; According to the data mirroring, a mirroring environment is constructed, and in the mirroring environment, a content tool is used to deduplicate the data of the source system that needs to be imported a second time, and the deduplicated data is merged with the data of the target system.

7. A data migration device, It is characterized in that It includes an acquisition module, a mapping module and a migration module; among which, The acquisition module is used to acquire the data structure of the source system and the data structure of the target system; The mapping establishment module is used to establish a mapping relationship between the source system and the target system according to the data structure of the source system and the data structure of the target system; wherein the mapping relationship includes a field mapping table and data conversion logic; The migration module is used to perform data migration between the source system and the target system according to the field mapping table and the data conversion logic.

8. A data migration device as claimed in claim 7, It is characterized in that The mapping establishment module establishes a mapping relationship between the source system and the target system according to the data structure of the source system and the data structure of the target system, including: The mapping establishment module obtains the table information and field information of the source system, and obtains the field information and table information of the target system; According to the table information and field information of the source system, the data type and constraint conditions of the source system are analyzed; according to the table information and field information of the target system, the data type of the target system is determined; According to the data type and constraint condition of the source system and the data type of the target system, combined with the field information of the source system and the field information of the target system, a mapping relationship between the source system and the target system is established.

9. A terminal device, It is characterized in that The method comprises a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor, wherein the processor implements the data migration method according to any one of claims 1 to 6 when executing the computer program.

10. A computer-readable storage medium, It is characterized in that The computer-readable storage medium includes a stored computer program, wherein when the computer program is executed, the device where the computer-readable storage medium is located is controlled to execute the data migration method according to any one of claims 1 to 6.

Citation Information

Patent Citations

  • Data migration method, device and system

    CN115617773A

  • Schema matching for data migration

    EP1990740A1

Cited By

  • System upgrading method and device and storage medium

    CN119225770A