Data table migration method and device and related components

Abstract

The invention discloses a data table migration method. The method comprises the steps of: exporting data in a to-be-processed system to a preset directory file; creating an empty table, wherein the structure of the empty table is consistent with the structure of the data table of the target system; reading data in a preset target file, formatting each piece of data into target data meeting the requirements of a target system, and inserting each piece of target data into an empty table; and when all the target data are inserted into the empty table, executing a copying operation on the empty table so as to import the data in the empty table into the target system. According to the method and the device, the database of the target system can be operated only once in the whole data table migration process, so that the data import time is shortened, the error probability during data import is reduced, and repeated operation on the database of the target system is avoided. The invention furthermore discloses a data table migration apparatus, an electronic device and a computer readable storage medium, which have the above beneficial effects.

Description

technical field [0001] The present application relates to the field of data migration, in particular to a data table migration method, device and related components. Background technique [0002] With the rapid development of Internet big data business projects, in order to meet more and more powerful business needs, it is necessary to integrate system projects in operation from multiple dimensions such as increasing system resources, optimizing resource allocation, optimizing key programs, and upgrading system databases. Optimization, and at the same time, it is necessary to ensure that the original system data is not lost. Often in many system projects, the data in system A needs to be provided to system B for use in consideration of cost budget and other reasons during comprehensive optimization and system upgrade. In the real scene, the two system projects A and B are in different production networks, the network is isolated, and the data table structure and database of...

AI Technical Summary

Problems solved by technology

At the same time, the exportable data format of A system project is limited, and the current import scheme does not support a large number of one-time import, or there is an upper limit on the amount of data, which needs to be executed in batches and multiple times, which is inefficient and error-prone. It brings difficulty to data migration under different systems

Images