CN116257503A - Data migration processing method, device, equipment and storage medium - Google Patents

Abstract

The application discloses a data migration processing method, a device, equipment and a storage medium, wherein a temporary intermediate original table with the same structure as an old system table is created in a new system, data is migrated on two intermediate tables according to a mapping relation, the data on the temporary intermediate tables are preprocessed, and finally data are synchronized to the database original table of the new system, so that possible data migration errors are isolated in the temporary intermediate table to solve the problem, the data errors are prevented from appearing on a line of the new system, and the technical problem that the data migration processing is difficult because the differences exist in the database types adopted by the new and old systems or the field structures of the database tables adopted by the new and old systems in the actual development process is solved.

Description

A data migration processing method, device, equipment and storage medium

technical field

The present application relates to the technical field of data migration, and in particular to a data migration processing method, device, device, and storage medium.

Background technique

In the field of software development, old systems are often refactored and upgraded, a new system is built to replace the old system, and the database tables used independently by the new system are redesigned.

After the new system is built, the old system needs to be gradually abandoned. In order to allow the business to run smoothly when the new and old systems are switched back, data migration from the old system database to the new system database is required.

In the actual development process, there may be differences in the database types used by the new and old systems. For example, the old system uses the oracle database, while the new system uses the mysql database, or the field structures of the database tables used by the new and old systems are different. As a result, the technical problem of data migration processing is difficult.

Contents of the invention

This application provides a data migration processing method, device, equipment, and storage medium, which solves the problem that the database types used by the new and old systems may be different in the actual development process, or the database tables used by the new and old systems may be different. There are differences in the field structure of the field, which causes technical problems in data migration processing difficulties.

In view of this, the first aspect of the present application provides a data migration processing method, the method comprising:

S1. Create a temporary intermediate original table having the same table structure as the original table of the first system database of the first system database;

S2. Create a temporary intermediate table having the same table structure as the original table of the second system database of the second system database;

S3. Import the data in the first database original table of the first system database into the temporary intermediate original table;

S4. Migrate the data in the temporary intermediate original table to the temporary intermediate table by executing the field mapping relationship script between the first system database and the second system database;

S5. After preprocessing the temporary intermediate table, import the data in the temporary intermediate table into the original table of the second system database.

Optionally, before the step S4, it also includes:

S6. Create a field mapping relationship script between the first system database and the second system database.

Optionally, the preprocessing of the temporary intermediate table in the step S5 is specifically:

Perform verification, cleaning, and correction preprocessing on the data in the temporary intermediate table.

Optionally, after the step S6, it also includes:

The time condition in the field mapping relationship script is updated, so that the data in the temporary intermediate original table is migrated to the temporary intermediate table in time periods according to the time condition.

The second aspect of the present application provides a data migration processing device, the device comprising:

The first creation unit is used to create a temporary intermediate original table with the same table structure as the original table of the first system database of the first system database;

The second creation unit is used to create a temporary intermediate table with the same table structure as the original table of the second system database of the second system database;

The first synchronization unit is configured to import the data in the first database original table of the first system database into the temporary intermediate original table;

A data migration unit, configured to migrate the data in the temporary intermediate original table to the temporary intermediate table by executing the field mapping relationship script between the first system database and the second system database;

The second synchronization unit is configured to import the data in the temporary intermediate table into the original table of the second system database after preprocessing the temporary intermediate table.

Optionally, also include:

A third creation unit, configured to create a field mapping relationship script between the first system database and the second system database.

Optionally, the preprocessing of the temporary intermediate table is specifically:

Perform verification, cleaning, and correction preprocessing on the data in the temporary intermediate table.

Optionally, also include:

An update unit, configured to update the time conditions in the field mapping relationship script, so that the data in the temporary intermediate original table is migrated to the temporary intermediate table in time periods according to the time conditions.

The third aspect of the present application provides a data migration processing device, the device includes a processor and a memory:

The memory is used to store program codes and transmit the program codes to the processor;

The processor is configured to execute the steps of the method for data migration processing as described in the first aspect above according to the instructions in the program code.

A fourth aspect of the present application provides a computer-readable storage medium, where the computer-readable storage medium is used to store program code, and the program code is used to execute the method described in the first aspect above.

It can be seen from the above technical solutions that the embodiments of the present application have the following advantages:

In this application, a data migration processing method, device, equipment and storage medium are provided. By creating a temporary intermediate original table with the same structure as the old system table in the new system and a temporary intermediate table with the same structure as the new system table, according to The mapping relationship first migrates the data on the two intermediate tables, then preprocesses the data on the temporary intermediate table, and finally synchronizes the data to the original database table of the new system, and isolates possible data migration errors in the temporary intermediate table To solve, to avoid data errors appearing on the new system line, to solve the problem that due to the actual development process, the database types used by the new and old systems may be different, or the field structure of the database tables used by the new and old systems may exist. Differences, resulting in difficult technical issues for data migration to deal with.

Description of drawings

Fig. 1 is the method flowchart of the data migration processing method in the embodiment of the present application;

FIG. 2 is a schematic structural diagram of a data migration processing device in an embodiment of the present application;

FIG. 3 is a schematic structural diagram of a data migration processing device in an embodiment of the present application.

Detailed ways

In order to enable those skilled in the art to better understand the solution of the application, the technical solution in the embodiment of the application will be clearly and completely described below in conjunction with the drawings in the embodiment of the application. Obviously, the described embodiment is only It is a part of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

This application designs a data migration processing method, device, equipment, and storage medium, which solves the problem that due to the actual development process, the database types used by the new and old systems may be different, or the database tables used by the new and old systems may be different. There are differences in the field structure of the field, which causes technical problems in data migration processing difficulties.

For ease of understanding, please refer to Figure 1. Figure 1 is a flow chart of the data migration processing method in the embodiment of the present application, as shown in Figure 1, specifically:

S1. Create a temporary intermediate original table having the same table structure as the original table of the first system database of the first system database;

It should be noted that before data migration, it is first necessary to create a temporary intermediate original table in the new database that has the same table structure as the original database table of the old database. The temporary intermediate original table has the same field structure as the original database table of the old database, but there is no data.

S2. Create a temporary intermediate table having the same table structure as the original table of the second system database of the second system database;

It should be noted that before the data migration, it is necessary to create a temporary intermediate table in the new database with the same table structure as the original database table of the new database, that is, the backup of the new table, and the temporary intermediate table and the original database table of the new database The table structure is the same, but without the data.

S3. Import the data in the original table of the first database of the first system database into the temporary intermediate original table;

It should be noted that, firstly, the data in the original database table of the old database is imported into the temporary intermediate original table.

S4. Migrate the data in the temporary intermediate original table to the temporary intermediate table by executing the field mapping relationship script between the first system database and the second system database;

It should be noted that the field mapping relationship script between the first system database and the second system database is executed in the new database, so as to migrate the data in the temporary intermediate original table to the temporary intermediate table.

S5. After the temporary intermediate table is preprocessed, the data in the temporary intermediate table is imported into the original table of the second system database.

It should be noted that the data in the temporary intermediate table is preprocessed to ensure the accuracy of the final data, and then the data in the temporary intermediate table is imported into the original database table of the new database.

It is understandable that the problem of cross-machine and cross-database systems is first solved by using the "temporary intermediate original table", and the problem is simplified to the problem of data migration between different data tables in the same database system.

Due to the different table field structures of the new and old data tables, the mapping relationship is complex, and the migration process is prone to errors. This paper proposes to first create a backup of the new table (with the same field structure as the new table, without data) "temporary intermediate table" on the new system. Follow-up migration is performed on the two intermediate tables according to the mapping relationship, and then preprocessing of data verification and correction is performed on the "temporary intermediate table", and finally the data is synchronized to the corresponding original table. In this way, possible data conversion and migration errors are isolated and solved in the "temporary intermediate table" to avoid data problems from appearing on the new system line.

Maintain the mapping relationship between the old and new system table fields by writing the mapping relationship sql, and execute the sql directly during migration without manual entry, which can greatly improve efficiency and reduce errors. When a data error is found, there is no need to modify the data one by one, just directly modify the mapping relationship sql and execute it again, which facilitates rapid data correction and maintenance.

Further, before step S4, it also includes:

S6. Create a field mapping relationship script between the first system database and the second system database.

Further, the preprocessing of the temporary intermediate table in step S5 is specifically:

Perform verification, cleaning, and correction preprocessing on the data in the temporary intermediate table.

Further, after step S6, it also includes:

Update the time conditions in the field mapping relationship script, so that the data in the temporary intermediate original table is migrated to the temporary intermediate table in time periods according to the time conditions.

It should be noted that, in the scenario where the old and new systems are running side by side and phased data migration is required, it is also easy to perform phased data migration by modifying or updating the time conditions in the field mapping relationship script.

Please refer to Figure 2, Figure 2 is a schematic structural diagram of the data migration processing device in the embodiment of the present application, as shown in Figure 2, specifically:

The first creating unit 201 is configured to create a temporary intermediate original table having the same table structure as the original table of the first system database of the first system database;

It should be noted that before data migration, it is first necessary to create a temporary intermediate original table in the new database that has the same table structure as the original database table of the old database. The temporary intermediate original table has the same field structure as the original database table of the old database, but there is no data.

The second creating unit 202 is configured to create a temporary intermediate table having the same table structure as the original table of the second system database of the second system database;

It should be noted that before the data migration, it is necessary to create a temporary intermediate table in the new database with the same table structure as the original database table of the new database, that is, the backup of the new table, and the temporary intermediate table and the original database table of the new database The table structure is the same, but without the data.

The first synchronization unit 203 is configured to import the data in the first database original table of the first system database into the temporary intermediate original table;

It should be noted that, firstly, the data in the original database table of the old database is imported into the temporary intermediate original table.

The data migration unit 204 is configured to migrate the data in the temporary intermediate original table to the temporary intermediate table by executing the field mapping relationship script between the first system database and the second system database;

It should be noted that the field mapping relationship script between the first system database and the second system database is executed in the new database, so as to migrate the data in the temporary intermediate original table to the temporary intermediate table.

The second synchronization unit 205 is configured to import the data in the temporary intermediate table into the original table of the second system database after preprocessing the temporary intermediate table.

It should be noted that the data in the temporary intermediate table is preprocessed to ensure the accuracy of the final data, and then the data in the temporary intermediate table is imported into the original database table of the new database.

It is understandable that the problem of cross-machine and cross-database systems is first solved by using the "temporary intermediate original table", and the problem is simplified to the problem of data migration between different data tables in the same database system.

Due to the different table field structures of the new and old data tables, the mapping relationship is complex, and the migration process is prone to errors. This paper proposes to first create a backup of the new table (with the same field structure as the new table, without data) "temporary intermediate table" on the new system. Follow-up migration is performed on the two intermediate tables according to the mapping relationship, and then preprocessing of data verification and correction is performed on the "temporary intermediate table", and finally the data is synchronized to the corresponding original table. In this way, possible data conversion and migration errors are isolated and solved in the "temporary intermediate table" to avoid data problems from appearing on the new system line.

Maintain the mapping relationship between the old and new system table fields by writing the mapping relationship sql, and execute the sql directly during migration without manual entry, which can greatly improve efficiency and reduce errors. When a data error is found, there is no need to modify the data one by one, just directly modify the mapping relationship sql and execute it again, which facilitates rapid data correction and maintenance.

Further, it also includes:

The third creation unit is configured to create a field mapping relationship script between the first system database and the second system database.

Further, the preprocessing of the temporary intermediate table is specifically as follows:

Perform verification, cleaning, and correction preprocessing on the data in the temporary intermediate table.

Further, it also includes:

The update unit is used to update the time condition in the field mapping relationship script, so that the data in the temporary intermediate original table is migrated to the temporary intermediate table in time periods according to the time condition.

It should be noted that, in the scenario where the old and new systems are running side by side and phased data migration is required, it is also easy to perform phased data migration by modifying or updating the time conditions in the field mapping relationship script.

The embodiment of the present application also provides another data migration processing device, as shown in Figure 3, for the convenience of description, only the parts related to the embodiment of the present application are shown, and the specific technical details are not disclosed, please refer to the implementation of the present application Example methods section. The terminal can be any terminal device including mobile phone, tablet computer, personal digital assistant (English full name: Personal Digital Assistant, English abbreviation: PDA), sales terminal (English full name: Point of Sales, English abbreviation: POS), vehicle-mounted computer, etc. Take mobile phone as an example:

FIG. 3 shows a block diagram of a partial structure of a mobile phone related to the terminal provided by the embodiment of the present application. Referring to Fig. 3, the mobile phone includes: radio frequency (English full name: Radio Frequency, English abbreviation: RF) circuit 1010, memory 1020, input unit 1030, display unit 1040, sensor 1050, audio circuit 1060, wireless fidelity (English full name: wirelessfidelity, English abbreviation: WiFi module 1070 , processor 1080 , power supply 1090 and other components. Those skilled in the art can understand that the structure of the mobile phone shown in FIG. 3 does not constitute a limitation to the mobile phone, and may include more or less components than shown in the figure, or combine some components, or arrange different components.

The following is a specific introduction to each component of the mobile phone in conjunction with Figure 3:

The RF circuit 1010 can be used for sending and receiving information or receiving and sending signals during a call. In particular, after receiving the downlink information from the base station, it is processed by the processor 1080; in addition, it sends the designed uplink data to the base station. Generally, the RF circuit 1010 includes, but is not limited to, an antenna, at least one amplifier, a transceiver, a coupler, a low noise amplifier (English full name: LowNoiseAmplifier, English abbreviation: LNA), a duplexer, and the like. In addition, RF circuitry 1010 may also communicate with networks and other devices via wireless communications. The above-mentioned wireless communication can use any communication standard or protocol, including but not limited to Global System for Mobile Communication (English full name: Global System of Mobile communication, English abbreviation: GSM), General Packet Radio Service (English full name: General Packet Radio Service, GPRS), Code Division Multiple Access (English full name: CodeDivision Multiple Access, English abbreviation: CDMA), Wideband Code Division Multiple Access (English full name: Wideband CodeDivisionMultiple Access, English abbreviation: WCDMA), Long Term Evolution (English full name: Long TermEvolution, English abbreviation: LTE) , email, short message service (English full name: ShortMessaging Service, SMS), etc.

The memory 1020 can be used to store software programs and modules, and the processor 1080 executes various functional applications and data processing of the mobile phone by running the software programs and modules stored in the memory 1020 . The memory 1020 can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, at least one application program required by a function (such as a sound playback function, an image playback function, etc.); Data created by the use of mobile phones (such as audio data, phonebook, etc.), etc. In addition, the memory 1020 may include a high-speed random access memory, and may also include a non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other volatile solid-state storage devices.

The input unit 1030 can be used to receive input numbers or character information, and generate key signal input related to user settings and function control of the mobile phone. Specifically, the input unit 1030 may include a touch panel 1031 and other input devices 1032 . The touch panel 1031, also referred to as a touch screen, can collect touch operations of the user on or near it (for example, the user uses any suitable object or accessory such as a finger or a stylus on the touch panel 1031 or near the touch panel 1031). operation), and drive the corresponding connection device according to the preset program. Optionally, the touch panel 1031 may include two parts, a touch detection device and a touch controller. Among them, the touch detection device detects the user's touch orientation, and detects the signal brought by the touch operation, and transmits the signal to the touch controller; the touch controller receives the touch information from the touch detection device, converts it into contact coordinates, and sends it to the to the processor 1080, and can receive and execute commands sent by the processor 1080. In addition, the touch panel 1031 can be implemented in various types such as resistive, capacitive, infrared, and surface acoustic wave. In addition to the touch panel 1031 , the input unit 1030 may also include other input devices 1032 . Specifically, other input devices 1032 may include, but are not limited to, one or more of physical keyboards, function keys (such as volume control keys, switch keys, etc.), trackballs, mice, joysticks, and the like.

The display unit 1040 may be used to display information input by or provided to the user and various menus of the mobile phone. The display unit 1040 may include a display panel 1041. Optionally, a liquid crystal display (English full name: Liquid Crystal Display, English abbreviation: LCD), an organic light-emitting diode (English full name: Organic Light-Emitting Diode, English abbreviation: OLED) etc. may be used. form to configure the display panel 1041 . Furthermore, the touch panel 1031 can cover the display panel 1041, and when the touch panel 1031 detects a touch operation on or near it, it sends it to the processor 1080 to determine the type of the touch event, and then the processor 1080 determines the type of the touch event according to the The type provides a corresponding visual output on the display panel 1041 . Although in FIG. 3 , the touch panel 1031 and the display panel 1041 are used as two independent components to realize the input and input functions of the mobile phone, in some embodiments, the touch panel 1031 and the display panel 1041 can be integrated to form a mobile phone. Realize the input and output functions of the mobile phone.

The handset may also include at least one sensor 1050, such as a light sensor, a motion sensor, and other sensors. Specifically, the light sensor can include an ambient light sensor and a proximity sensor, wherein the ambient light sensor can adjust the brightness of the display panel 1041 according to the brightness of the ambient light, and the proximity sensor can turn off the display panel 1041 and/or when the mobile phone is moved to the ear. or backlight. As a kind of motion sensor, the accelerometer sensor can detect the magnitude of acceleration in various directions (generally three axes), and can detect the magnitude and direction of gravity when it is stationary, and can be used for applications that recognize the posture of mobile phones (such as horizontal and vertical screen switching, related Games, magnetometer attitude calibration), vibration recognition related functions (such as pedometer, tap), etc.; as for other sensors such as gyroscope, barometer, hygrometer, thermometer, infrared sensor, etc. repeat.

The audio circuit 1060, the speaker 1061, and the microphone 1062 can provide an audio interface between the user and the mobile phone. The audio circuit 1060 can transmit the electrical signal converted from the received audio data to the speaker 1061, and the speaker 1061 converts it into an audio signal for output; After being received, it is converted into audio data, and then the audio data is processed by the output processor 1080, and then sent to another mobile phone through the RF circuit 1010, or the audio data is output to the memory 1020 for further processing.

WiFi is a short-distance wireless transmission technology. The mobile phone can help users send and receive emails, browse web pages, and access streaming media through the WiFi module 1070, which provides users with wireless broadband Internet access. Although Fig. 3 shows the WiFi module 1070, it can be understood that it is not an essential component of the mobile phone, and can be completely omitted as required without changing the essence of the invention.

The processor 1080 is the control center of the mobile phone. It uses various interfaces and lines to connect various parts of the entire mobile phone. By running or executing software programs and/or modules stored in the memory 1020, and calling data stored in the memory 1020, execution Various functions and processing data of the mobile phone, so as to monitor the mobile phone as a whole. Optionally, the processor 1080 may include one or more processing units; preferably, the processor 1080 may integrate an application processor and a modem processor, wherein the application processor mainly processes operating systems, user interfaces, and application programs, etc. , the modem processor mainly handles wireless communications. It can be understood that the foregoing modem processor may not be integrated into the processor 1080 .

The mobile phone also includes a power supply 1090 (such as a battery) for supplying power to various components. Preferably, the power supply can be logically connected to the processor 1080 through the power management system, so that functions such as charging, discharging, and power consumption management can be realized through the power management system.

Although not shown, the mobile phone may also include a camera, a Bluetooth module, etc., which will not be repeated here.

In this embodiment of the application, the processor 1080 included in the terminal also has the following functions:

S1. Create a temporary intermediate original table having the same table structure as the original table of the first system database of the first system database;

S2. Create a temporary intermediate table having the same table structure as the original table of the second system database of the second system database;

S3. Import the data in the original table of the first database of the first system database into the temporary intermediate original table;

S4. Migrate the data in the temporary intermediate original table to the temporary intermediate table by executing the field mapping relationship script between the first system database and the second system database;

S5. After the temporary intermediate table is preprocessed, the data in the temporary intermediate table is imported into the original table of the second system database.

The embodiment of the present application further provides a computer-readable storage medium, which is used to store program code, and the program code is used to execute any one implementation manner in the data migration processing method described in the foregoing embodiments.

In the embodiment of the present application, a data migration processing method, device, device, and storage medium are provided. By creating a temporary intermediate original table with the same structure as the old system table in the new system, the temporary intermediate table with the same structure as the new system table According to the mapping relationship, the data is first migrated on the two intermediate tables, and then the data on the temporary intermediate table is preprocessed, and finally the data is synchronized to the original database table of the new system, and possible data migration errors are isolated in the temporary The intermediate table is used to solve the problem, avoiding data errors appearing on the new system line, and solving the problem that in the actual development process, there may be differences in the database types used by the new and old systems, or the fields of the database tables used by the new and old systems There are differences in the structure, resulting in difficult technical problems in data migration.

Those skilled in the art can clearly understand that for the convenience and brevity of the description, the specific working process of the above-described system, device and unit can refer to the corresponding process in the foregoing method embodiment, which will not be repeated here.

The terms "first", "second", "third", "fourth", etc. (if any) in the description of the present application and the above drawings are used to distinguish similar objects and not necessarily to describe specific sequence or sequence. It is to be understood that the data so used are interchangeable under appropriate circumstances such that the embodiments of the application described herein, for example, can be practiced in sequences other than those illustrated or described herein. Furthermore, the terms "comprising" and "having", as well as any variations thereof, are intended to cover a non-exclusive inclusion, for example, a process, method, system, product or device comprising a sequence of steps or elements is not necessarily limited to the expressly listed instead, may include other steps or elements not explicitly listed or inherent to the process, method, product or apparatus.

It should be understood that in this application, "at least one (item)" means one or more, and "multiple" means two or more. "And/or" is used to describe the association relationship of associated objects, indicating that there can be three types of relationships, for example, "A and/or B" can mean: only A exists, only B exists, and A and B exist at the same time , where A and B can be singular or plural. The character "/" generally indicates that the contextual objects are an "or" relationship. "At least one of the following" or similar expressions refer to any combination of these items, including any combination of single or plural items. For example, at least one item (piece) of a, b or c can mean: a, b, c, "a and b", "a and c", "b and c", or "a and b and c ", where a, b, c can be single or multiple.

In the several embodiments provided in this application, it should be understood that the disclosed system, device and method can be implemented in other ways. For example, the device embodiments described above are only illustrative. For example, the division of the units is only a logical function division. In actual implementation, there may be other division methods. For example, multiple units or components can be combined or May be integrated into another system, or some features may be ignored, or not implemented. In another point, the mutual coupling or direct coupling or communication connection shown or discussed may be through some interfaces, and the indirect coupling or communication connection of devices or units may be in electrical, mechanical or other forms.

The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place, or may be distributed to multiple network units. Part or all of the units can be selected according to actual needs to achieve the purpose of the solution of this embodiment.

In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, each unit may exist separately physically, or two or more units may be integrated into one unit. The above-mentioned integrated units can be implemented in the form of hardware or in the form of software functional units.

If the integrated unit is realized in the form of a software function unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application is essentially or part of the contribution to the prior art or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium , including several instructions to make a computer device (which may be a personal computer, a server, or a network device, etc.) execute all or part of the steps of the methods described in the various embodiments of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (English full name: Read-OnlyMemory, English abbreviation: ROM), random access memory (English full name: RandomAccess Memory, English abbreviation: RAM), magnetic disk or CDs and other media that can store program codes.

As mentioned above, the above embodiments are only used to illustrate the technical solutions of the present application, and are not intended to limit them; although the present application has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that: it can still understand the foregoing The technical solutions described in each embodiment are modified, or some of the technical features are equivalently replaced; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the various embodiments of the application.

Claims (10)

1. A data migration processing method, comprising:

s1, creating a temporary intermediate original table with the same table structure as a first system database original table of a first system database;

s2, creating a temporary intermediate table with the same table structure as the original table of the second system database;

s3, importing data in a first database original table of the first system database into the temporary intermediate original table;

s4, migrating the data in the temporary intermediate original table to the temporary intermediate table by executing a field mapping relation script of the first system database and the second system database;

s5, after preprocessing the temporary intermediate table, importing the data in the temporary intermediate table into the original table of the second system database.

2. The data migration processing method according to claim 1, further comprising, before the step S4:

s6, creating a field mapping relation script of the first system database and the second system database.

3. The data migration processing method according to claim 1, wherein the preprocessing of the temporary intermediate table in step S5 specifically includes:

and checking, cleaning and correcting the data in the temporary intermediate table.

4. The data migration processing method according to claim 1, wherein after the step S6, further comprising:

and updating the time condition in the field mapping relation script, so that the data in the temporary intermediate original table is migrated to the temporary intermediate table according to the time condition in a time period.

5. A data migration processing apparatus, comprising:

a first creation unit configured to create a temporary intermediate original table having the same table structure as the first system database original table of the first system database;

a second creating unit for creating a temporary intermediate table having the same table structure as the original table of the second system database;

the first synchronization unit is used for importing the data in the first database original table of the first system database into the temporary intermediate original table;

the data migration unit is used for migrating the data in the temporary intermediate original table to the temporary intermediate table by executing the field mapping relation script of the first system database and the second system database;

and the second synchronization unit is used for importing the data in the temporary intermediate table into the original table of the second system database after preprocessing the temporary intermediate table.

6. The data migration processing apparatus according to claim 5, further comprising:

and the third creating unit is used for creating a field mapping relation script of the first system database and the second system database.

7. The data migration processing apparatus according to claim 5, wherein the preprocessing of the temporary intermediate table is specifically:

and checking, cleaning and correcting the data in the temporary intermediate table.

8. The data migration processing apparatus according to claim 5, further comprising:

and the updating unit is used for updating the time condition in the field mapping relation script so that the data in the temporary intermediate original table is migrated to the temporary intermediate table according to the time condition in a time period.

9. A data migration processing apparatus, the apparatus comprising a processor and a memory:

the memory is used for storing program codes and transmitting the program codes to the processor;

the processor is configured to perform the data migration processing method according to any one of claims 1-4 according to instructions in the program code.

10. A computer-readable storage medium storing a program code for executing the data migration processing method according to any one of claims 1 to 4.

Images