Data migration method and device, electronic equipment and storage medium

A data storage and data technology, applied in the field of data processing, can solve problems such as data migration failure, migration data garbled characters, etc., achieve effective data migration, solve data garbled characters, and improve effectiveness

Pending Publication Date: 2022-03-25
AGRICULTURAL BANK OF CHINA
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] At present, when migrating data stored in one type of database to another type of database, due to the different types of databases, some of the migrated data is prone to garbled characters during the data migration process, resulting in data migration failure.

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 device, electronic equipment and storage medium
  • Data migration method and device, electronic equipment and storage medium
  • Data migration method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0029] figure 1 It is a schematic flow chart of a data migration method provided in Embodiment 1 of the present invention. This embodiment is applicable to data migration. The method can be executed by a data migration device, which can use software and / or hardware Realized, it can be integrated into electronic devices such as computers or servers.

[0030] Such as figure 1 As shown, the method of the present embodiment includes:

[0031] S110. Determine the data to be migrated stored in the first data table to be processed in the first database.

[0032] Wherein, the first database can be understood as a heterogeneous database requiring data migration. Optionally, the first database may be an Oracle database. The first data table to be processed may be a data table in the first database. The number of the first data tables to be processed may be one or more. The data to be migrated may be all or part of the data stored in the first data table to be processed.

[0033] ...

Embodiment 2

[0049] figure 2 It is a schematic flowchart of a data migration method provided in Embodiment 2 of the present invention. On the basis of the foregoing embodiments, optionally, the data to be migrated stored in the updated first data table to be processed is stored in the In the second to-be-processed data table of the second database, include: the data file to be migrated that is used to store each data to be migrated in the preset text format based on the updated first data table to be processed; Each migration data stored in is stored in the second pending data table of the second database. Wherein, technical terms that are the same as or corresponding to those in the foregoing embodiments will not be repeated here.

[0050] Such as figure 2 As shown, the method in this embodiment may specifically include:

[0051] S210. Determine the data to be migrated stored in the first data table to be processed in the first database.

[0052] S220. For each data to be migrated, ...

Embodiment 3

[0069] image 3 It is a schematic flow chart of a data migration method provided by Embodiment 3 of the present invention. On the basis of the foregoing embodiments, optionally, the data migration method of this embodiment may further include: determining the updated first data to be processed Whether the first data volume of the data to be migrated stored in the table is consistent with the second data volume of the migrated data stored in the target migration data table; if the first data volume is consistent with the second data volume, Then compare the data to be migrated in the updated first data table to be processed with the migrated data corresponding to the data to be migrated in the target migration data table to generate a comparison result, and based on the Determine whether the data migration is successful based on the comparison result; if the first data volume is inconsistent with the second data volume, it is determined that the data migration is not successful...

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 embodiment of the invention discloses a data migration method and device, electronic equipment and a storage medium. The method comprises the steps of determining to-be-migrated data stored in a first to-be-processed data table in a first database; for each piece of to-be-migrated data, if the to-be-migrated data is null data, replacing the to-be-migrated data with placeholder data of which the data type is the same as that of the to-be-migrated data, and updating a first to-be-processed data table; storing the to-be-migrated data stored in the updated first to-be-processed data table into a second to-be-processed data table of a second database; and replacing each placeholder data stored in the second to-be-processed data table with null data of which the data type is the same as that of each placeholder data to obtain a target migration data table. According to the technical scheme, the technical problem that data messy codes exist in an existing data migration method is solved, more effective data migration is achieved, and therefore the technical effect of improving the validity of data migration is achieved.

Description

technical field [0001] Embodiments of the present invention relate to the technical field of data processing, and in particular, to a data migration method, device, electronic device, and storage medium. Background technique [0002] At present, when data stored in one type of database is migrated to another type of database, due to the different types of databases, part of the migrated data is prone to garbled characters during the data migration process, resulting in data migration failure. Contents of the invention [0003] In view of the problems existing in the above-mentioned data migration, embodiments of the present invention provide a data migration method, device, electronic equipment, and storage medium to achieve more effective data migration, thereby achieving the technical effect of improving the effectiveness of data migration. [0004] In a first aspect, an embodiment of the present invention provides a data migration method, the method comprising: [0005...

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): G06F16/21G06F16/22
CPCG06F16/214G06F16/2282
Inventor 吴海存毛思平梁铠埼施学勤
Owner AGRICULTURAL BANK OF CHINA
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