Data migration method and device, electronic equipment and storage medium

Abstract

The present disclosure provides a data migration method and device, electronic equipment and storage medium, which can be applied to the fields of computer technology, big data, finance or other fields. The method comprises: in response to a data migration request, determining job information associated with a source database based on a first database view of the source database included in a source end device; determining trigger information and foreign key information associated with a target database based on a second database view of the target database included in a target end device; configuring a running environment of the source database and a running environment of the target database based on the job information, the trigger information and the foreign key information; and in the case that it is determined that the running environment of the source database and the running environment of the target database are both configured, running a data migration task carried in the data migration request to migrate to-be-migrated data included in the source database to the target database.

Description

Technical Field

[0001] This disclosure relates to the fields of computer technology, big data, and finance, and more specifically, to a data migration method, apparatus, electronic device, and storage medium. Background Technology

[0002] With the continuous development of information technology, the importance of data to companies or individuals is constantly increasing. Therefore, data migration technology is becoming increasingly important. Data migration refers to the process of data transfer between databases, and it has been widely used in areas such as database changes and system updates.

[0003] In realizing the concept disclosed herein, the inventors discovered that when using data migration tools in related technologies to perform data migration, problems such as abnormal task interruption and slow data writing may occur. Summary of the Invention

[0004] In view of the above, this disclosure provides a data migration method, apparatus, electronic device, readable storage medium, and computer program product.

[0005] One aspect of this disclosure provides a data migration method, comprising:

[0006] In response to a data migration request, based on a first database view of the source database included in the source device, job information associated with the aforementioned source database is determined;

[0007] Based on the second database view of the target database included in the target terminal device, determine the trigger information and foreign key information associated with the aforementioned target database;

[0008] Based on the above job information, trigger information, and foreign key information, configure the runtime environment of the source database and the target database respectively; and

[0009] Once it is confirmed that the operating environments of the source database and the target database are both configured, the data migration task carried in the data migration request is executed to migrate the data to be migrated from the source database to the target database.

[0010] According to embodiments of this disclosure, configuring the operating environment of the source database and the operating environment of the target database based on the job information, the trigger information, and the foreign key information includes: generating environment configuration scripts based on the job information, the trigger information, and the foreign key information; and sending the environment configuration scripts to the source device and the target device to configure the operating environment of the source database and the operating environment of the target database respectively.

[0011] According to embodiments of this disclosure, the environment configuration script includes a first configuration script, a second configuration script, and a third configuration script; wherein, generating the environment configuration script based on the job information, the trigger information, and the foreign key information includes: concatenating a first disable command with the identification information of at least one target system job included in the job information to obtain the first configuration script; concatenating a second disable command with the identification information of at least one target trigger included in the trigger information to obtain the second configuration script; and concatenating a third disable command with the identification information of at least one target foreign key included in the foreign key information to obtain the third configuration script.

[0012] According to embodiments of this disclosure, the aforementioned sending of environment configuration scripts to the source device and the target device to configure the operating environment of the source database and the target database respectively includes: sending the first configuration script to the source device, wherein the source device is configured to disable at least one target system job by running the first configuration script to configure the operating environment of the source database; and sending the second configuration script and the third configuration script to the target device respectively, wherein the target device is configured to disable at least one target trigger and at least one target foreign key by running the second configuration script and the third configuration script respectively to configure the operating environment of the target database.

[0013] According to embodiments of this disclosure, the method further includes: determining sequence number information associated with the source database based on a third database view of the source database; and repairing the operating environment of the target database based on the job information, the trigger information, the foreign key information, and the sequence number information when it is determined that the data migration task has been completed.

[0014] According to an embodiment of this disclosure, the above-mentioned repair of the operating environment of the target database based on the above-mentioned job information, the above-mentioned trigger information, the above-mentioned foreign key information and the above-mentioned serial number information includes: generating an environment repair script based on the above-mentioned job information, the above-mentioned trigger information, the above-mentioned foreign key information and the above-mentioned serial number information respectively; and sending the environment repair script to the target terminal device to repair the operating environment of the target database.

[0015] According to embodiments of this disclosure, the aforementioned environment remediation script includes a first initialization script, a second initialization script, a third initialization script, and a fourth initialization script. Specifically, generating the environment remediation script based on the aforementioned job information, trigger information, foreign key information, and serial number information includes: concatenating a first initialization command with the identification information and job configuration information of at least one target system job included in the job information to obtain the first initialization script; concatenating a second initialization command with the identification information and serial number configuration information of at least one target serial number included in the serial number information to obtain the second initialization script; concatenating a third initialization command with the identification information of at least one target trigger included in the trigger information to obtain the third initialization script; and concatenating a fourth initialization command with the identification information of at least one target foreign key included in the foreign key information to obtain the fourth initialization script.

[0016] According to embodiments of this disclosure, sending the environment repair script to the target device to repair the operating environment of the target database includes: sending the first initialization script, the second initialization script, the third initialization script, and the fourth initialization script to the target device respectively, wherein the target device is configured to start at least one target trigger and at least one target foreign key by running the third initialization script and the fourth initialization script respectively, and, if it is determined that the third initialization script and the fourth initialization script have both run successfully, to initialize at least one target system job and at least one target serial number by running the first initialization script and the second initialization script respectively, thereby repairing the operating environment of the target database.

[0017] Another aspect of this disclosure provides a data migration apparatus, comprising:

[0018] The job information determination module is used to determine the job information associated with the source database based on a first database view of the source database included in the source device in response to the data migration request.

[0019] The trigger and foreign key information determination module is used to determine the trigger information and foreign key information associated with the target database based on a second database view of the target database included in the target terminal device.

[0020] The runtime environment configuration module is used to configure the runtime environment of the source database and the target database respectively based on the above-mentioned job information, trigger information, and foreign key information; and

[0021] The data migration module is used to run the data migration task carried in the data migration request after confirming that the operating environment of the source database and the operating environment of the target database are both configured, so as to migrate the data to be migrated in the source database to the target database.

[0022] Another aspect of this disclosure provides an electronic device, including: one or more processors; and a memory for storing one or more instructions, wherein when the one or more instructions are executed by the one or more processors, the one or more processors cause the one or more processors to perform the method as described above.

[0023] Another aspect of this disclosure provides a computer-readable storage medium storing computer-executable instructions, which, when executed, are used to implement the method described above.

[0024] Another aspect of this disclosure provides a computer program product including computer-executable instructions that, when executed, implement the method described above.

[0025] According to embodiments of this disclosure, upon receiving a request to migrate data from a source database to a target database, running job information, trigger information, and foreign key information can be obtained from the database views of both the source and target databases. The operating environments of the source and target databases are configured by configuring the system jobs, triggers, and foreign keys associated with the job information, trigger information, and foreign key information, respectively. Therefore, during the execution of the data migration task, the configuration of system jobs in the source database can at least partially overcome the problem of sudden task interruption, thereby better ensuring data consistency in the source database and reducing the probability of abnormal interruption of the data migration task. Meanwhile, the configuration of triggers and foreign keys in the target database can at least partially overcome the problem of slow data writing speed to the target database, thereby reducing the frequency of information interaction during data writing and improving the efficiency of data migration. Attached Figure Description

[0026] The above and other objects, features and advantages of this disclosure will become clearer from the following description of embodiments with reference to the accompanying drawings, in which:

[0027] Figure 1 An exemplary system architecture for which the methods and apparatus for data migration of this disclosure can be applied is illustrated schematically;

[0028] Figure 2 A flowchart illustrating a data migration method according to an embodiment of the present disclosure is shown schematically.

[0029] Figure 3This illustration schematically shows a flowchart of the runtime environment configuration for the source database and the target database according to an embodiment of the present disclosure;

[0030] Figure 4 A flowchart illustrating the repair of the target database operating environment according to an embodiment of this disclosure is shown schematically;

[0031] Figure 5 A block diagram illustrating an environment remediation method based on data migration according to an embodiment of the present disclosure is shown schematically;

[0032] Figure 6 A block diagram of a data migration apparatus according to embodiments of the present disclosure is schematically shown; and

[0033] Figure 7 A block diagram of an electronic device suitable for implementing a data migration method according to an embodiment of the present disclosure is shown schematically. Detailed Implementation

[0034] The embodiments of the present disclosure will now be described with reference to the accompanying drawings. However, it should be understood that these descriptions are exemplary only and are not intended to limit the scope of the disclosure. In the following detailed description, numerous specific details are set forth to provide a thorough understanding of the embodiments of the present disclosure for ease of explanation. However, it will be apparent that one or more embodiments may be practiced without these specific details. Furthermore, descriptions of well-known structures and techniques are omitted in the following description to avoid unnecessarily obscuring the concepts of the present disclosure.

[0035] The terminology used herein is for the purpose of describing particular embodiments only and is not intended to limit this disclosure. The terms “comprising,” “including,” etc., as used herein indicate the presence of the stated features, steps, operations, and / or components, but do not exclude the presence or addition of one or more other features, steps, operations, or components.

[0036] All terms used herein (including technical and scientific terms) have the meanings commonly understood by those skilled in the art, unless otherwise defined. It should be noted that the terms used herein are to be interpreted in a manner consistent with the context of this specification, and not in an idealized or overly rigid way.

[0037] When using expressions such as "at least one of A, B, and C," the expression should generally be interpreted in accordance with the meaning commonly understood by a person skilled in the art (e.g., "a system having at least one of A, B, and C" should include, but is not limited to, systems having A alone, having B alone, having C alone, having A and B, having A and C, having B and C, and / or having A, B, and C, etc.). Similarly, when using expressions such as "at least one of A, B, or C," the expression should generally be interpreted in accordance with the meaning commonly understood by a person skilled in the art (e.g., "a system having at least one of A, B, or C" should include, but is not limited to, systems having A alone, having B alone, having C alone, having A and B, having A and C, having B and C, and / or having A, B, and C, etc.).

[0038] Research on data migration revealed that when using the Data Replication Service (DRS) tool for data migration, assuming a migration from Oracle Database (OD) to Gauss Database (GD), failure to pause relevant database jobs in Oracle can lead to inconsistencies between the version transferred and the final stored version, potentially causing task interruptions during migration. Furthermore, failing to disable Gauss Database triggers and foreign keys can result in extremely slow writes to Gauss Database. If system jobs and sequence numbers are not initialized after migration, related functionalities will not function correctly.

[0039] In view of the above, embodiments of this disclosure provide a data migration method, a data migration apparatus, an electronic device, a readable storage medium, and a computer program product. The method includes, in response to a data migration request, determining job information associated with the source database based on a first database view of a source database included in a source device; determining trigger information and foreign key information associated with the target database based on a second database view of a target database included in a target device; configuring the operating environment of the source database and the operating environment of the target database based on the job information, the trigger information, and the foreign key information; and, upon determining that the operating environments of both the source database and the target database are configured, executing a data migration task carried in the data migration request to migrate the data to be migrated from the source database to the target database.

[0040] It should be noted that the data migration method and apparatus determined in the embodiments of this disclosure can be used in the fields of computer technology, big data, or finance. The data migration method and apparatus determined in the embodiments of this disclosure can also be used in any field other than computer technology, big data, and finance, such as the field of data migration technology. The application fields of the data migration method and apparatus determined in the embodiments of this disclosure are not limited.

[0041] In the technical solutions disclosed herein, the collection, storage, use, processing, transmission, provision, disclosure, and application of data (including but not limited to user personal information) comply with the provisions of relevant laws and regulations, necessary confidentiality measures have been taken, and they do not violate public order and good morals.

[0042] Figure 1 This illustration schematically depicts an exemplary system architecture to which data migration methods and apparatus can be applied according to embodiments of this disclosure. It should be noted that... Figure 1 The examples shown are merely examples of system architectures that can be applied to the embodiments of this disclosure, in order to help those skilled in the art understand the technical content of this disclosure, but do not mean that the embodiments of this disclosure cannot be used in other devices, systems, environments or scenarios.

[0043] like Figure 1 As shown, the system architecture 100 according to this embodiment may include a first database 101, a first terminal device 102, a server 103, a second terminal device 104, and a second database 105. The first database 101 may be located in the first terminal device 102, and the second database 105 may be located in the second terminal device 104. The first terminal device 102 and the second terminal device 104, and the server 103 can be connected via a network. The network is a medium that can provide a communication link, including various connection types, such as wired and / or wireless communication links, etc.

[0044] The first terminal device 102 may be equipped with a first database 101, and the second terminal device 104 may be equipped with a second database 105. The first terminal device 102 and the second terminal device 104 can interact with the server 103 via a network to receive or send data, etc. Various communication client applications can be installed on the terminal devices 102 and 104, such as shopping applications, web browser applications, search applications, instant messaging tools, email clients and / or social platform software, etc. (for example only).

[0045] Terminal devices 102 and 104 can be various electronic devices with displays and support web browsing, including but not limited to smartphones, tablets, laptops, and desktop computers.

[0046] The first database 101 can be a source database storing data to be migrated; the second database 105 can be a target database receiving the migrated data.

[0047] Server 103 can be a server that provides various services. It may have DRS tools or other migration tools installed, such as a backend management server that supports data migration requests issued by users using the first terminal device 101 and the second terminal device 104 (this is just an example). The backend management server can analyze and process the received user requests and other data, and feed back the processing results (such as web pages, information, or data obtained or generated according to user requests) to the terminal devices.

[0048] It should be noted that the data migration method provided in this embodiment can generally be executed by server 105. Correspondingly, the data migration device provided in this embodiment can generally be located in server 105. The data migration method provided in this embodiment can also be executed by a server or server cluster that is different from server 105 and capable of communicating with the first terminal device 101, the second terminal device 104, and / or server 105. Correspondingly, the data migration device provided in this embodiment can also be located in a server or server cluster that is different from server 105 and capable of communicating with the first terminal device 101, the second terminal device 104, and / or server 105. Alternatively, the data migration method provided in this embodiment can also be executed by the first terminal device 102 or the second terminal device 104, or by other terminal devices different from the first terminal device 102 and the second terminal device 104. Correspondingly, the data migration device provided in this embodiment can also be located in the first terminal device 102 and the second terminal device 104, or in other terminal devices different from the first terminal device 102 and the second terminal device 104.

[0049] For example, the DRS data migration tool can be installed on server 103. Then, terminal device 102, terminal device 104, and server 103 can execute the data migration method provided in the embodiments of this disclosure locally.

[0050] It should be understood that Figure 1 The number of terminal devices and servers shown is merely illustrative. Depending on implementation needs, any number of terminal devices and servers can be used.

[0051] Figure 2 A flowchart illustrating a data migration method according to an embodiment of the present disclosure is shown schematically.

[0052] like Figure 2 As shown, the method includes operations S201 to S204.

[0053] In operation S201, in response to a data migration request, job information associated with the source database is determined based on a first database view of the source database included in the source device.

[0054] According to embodiments of this disclosure, if a data migration request is received, a first command can be used to log in to the source database of the source device in order to query a first database view. The first command can be the sqlplus command, and the first database view can include a job list information view, for example, the job list information view can be the dba_scheduler_jobs view.

[0055] According to embodiments of this disclosure, the source data can be an Oracle database.

[0056] According to embodiments of this disclosure, by querying a job list information view using a source database and then using the job list information view to determine job information associated with the source database, job information associated with the source database can be obtained quickly and comprehensively.

[0057] In operation S202, based on the second database view of the target database included in the target terminal device, trigger information and foreign key information associated with the target database are determined.

[0058] According to embodiments of this disclosure, a second command can be used to log in to the target database in order to query a second database view. Then, trigger information and foreign key information associated with the target database can be determined based on the second database view. The second command can be a gsql command, and the second database view can include at least one trigger key information view and a foreign key information view. For example, the trigger key information view and the foreign key information view can be an adm_triggers view, a pg_trigger view, and an adm_constraints view.

[0059] According to embodiments of this disclosure, the target database can be a Gauss database.

[0060] According to embodiments of this disclosure, by querying a trigger key information view and a foreign key information view in the target database, and then using the trigger key information view and the foreign key information view to determine the trigger information and foreign key information associated with the target database, the trigger information and foreign key information associated with the source database can be obtained quickly and comprehensively.

[0061] In operation S203, the runtime environment of the source database and the runtime environment of the target database are configured based on job information, trigger information, and foreign key information.

[0062] According to embodiments of this disclosure, configuring the operating environment of the source database based on the acquired job information can be a process of configuring the source device using the job information.

[0063] Based on the obtained trigger and foreign key information, the operating environment of the target database is configured. This can be described as the process of configuring the target end using trigger and foreign key information.

[0064] According to embodiments of this disclosure, configuring the operating environment of the source database based on job information can ensure data consistency in the source database and reduce the probability of abnormal interruption of the data migration task. Configuring the operating environment of the target database based on trigger information and foreign key information can reduce the frequency of information interaction during data writing, thereby improving the efficiency of data migration.

[0065] In operation S204, after confirming that the operating environments of both the source database and the target database are configured, the data migration task carried in the data migration request is executed to migrate the data to be migrated from the source database to the target database.

[0066] According to embodiments of this disclosure, once the operating environment configuration for the two databases is determined, data migration from the source database to the target database can be performed.

[0067] According to embodiments of this disclosure, data migration tasks can be performed using the DRS tool.

[0068] According to embodiments of this disclosure, upon receiving a request to migrate data from a source database to a target database, running job information, trigger information, and foreign key information can be obtained from the database views of both the source and target databases. The operating environments of the source and target databases are configured by configuring the system jobs, triggers, and foreign keys associated with the job information, trigger information, and foreign key information, respectively. Therefore, during the execution of the data migration task, the configuration of system jobs in the source database can at least partially overcome the problem of sudden task interruption, thereby better ensuring data consistency in the source database and reducing the probability of abnormal interruption of the data migration task. Meanwhile, the configuration of triggers and foreign keys in the target database can at least partially overcome the problem of slow data writing speed to the target database, thereby reducing the frequency of information interaction during data writing and improving the efficiency of data migration.

[0069] The following is for reference. Figures 3-4 In conjunction with specific embodiments, Figure 2 The method shown will be further explained.

[0070] Figure 3The schematic diagram illustrates the runtime environment configuration flowchart for the source database and the target database according to an embodiment of the present disclosure.

[0071] like Figure 3 As shown, based on job information, trigger information, and foreign key information, the operating environment of the source database and the operating environment of the target database are configured respectively, including: operation S301 to operation S302.

[0072] When operating S301, an environment configuration script is generated based on job information, trigger information, and foreign key information, respectively.

[0073] In operation S302, environment configuration scripts are sent to the source device and the target device respectively to configure the operating environment of the source database and the operating environment of the target database respectively.

[0074] According to embodiments of this disclosure, an environment configuration script is generated by combining relevant commands with at least one system job-related information included in the job information, at least one trigger-related information included in the trigger-related information, and at least one foreign key-related information included in the foreign key information.

[0075] According to embodiments of this disclosure, an environment configuration script generated based on job information is sent to a source device; an environment configuration script generated based on trigger information and foreign key information is sent to a target device.

[0076] According to embodiments of this disclosure, the process of generating an environment configuration script using job information, trigger information, and foreign key information, and then sending the environment configuration script to the source device and the target device respectively, can configure the source device and the target device to obtain a suitable operating environment for data migration between the source database and the target database.

[0077] According to embodiments of this disclosure, the environment configuration script includes a first configuration script, a second configuration script, and a third configuration script; wherein, operation S301, generating the environment configuration script based on job information, trigger information, and foreign key information respectively, may include: concatenating a first disable command with the respective identification information of at least one target system job included in the job information to obtain a first configuration script; concatenating a second disable command with the respective identification information of at least one target trigger included in the trigger information to obtain a second configuration script; and concatenating a third disable command with the respective identification information of at least one target foreign key included in the foreign key information to obtain a third configuration script.

[0078] According to the embodiments of this disclosure, the splicing method of the first disable command and the target system operation identifier information, the splicing method of the second disable command and the target trigger identifier information, and the splicing method of the third disable command and the target foreign key identifier information are not limited. Different splicing methods can be used depending on the specific situation, for example, using the connecting pipe symbol ||.

[0079] According to embodiments of this disclosure, the identification information of all target system jobs is obtained from the job information. A first disabling command is concatenated with the identification information of at least one target system job to output a first configuration script. The first disabling command is not limited and can be any command or set of commands capable of stopping the target system job. For example, the `select` command can be used to represent the command to disable the target system job as a string. The command used to output the first configuration script is not limited and can be a `spool` command.

[0080] According to embodiments of this disclosure, identification information of all target triggers is obtained from trigger information, and the second disable command is concatenated with the identification information of at least one target trigger to output a second configuration script. The second disable command is not limited and can be any command or set of commands that can disable the target triggers. For example, the select command can be used to represent the command to disable the target triggers in string form.

[0081] According to embodiments of this disclosure, the identification information of all target foreign keys is obtained from the trigger information, and the third disabling command is concatenated with the identification information of at least one target foreign key to output a third configuration script. The third disabling command is not limited and can be any command or set of commands that can disable the target foreign key. For example, the select command can be used to represent the command that disables the target foreign key in string form.

[0082] According to embodiments of this disclosure, the identification information of the target system job, target trigger, and target foreign key may include an identification number and a name.

[0083] According to embodiments of this disclosure, the output commands of the second configuration script and the third configuration script are not limited, and can be output commands with path filenames.

[0084] According to embodiments of this disclosure, disabling system jobs in the source database can ensure data consistency in the source database and reduce the probability of abnormal interruption of data migration tasks. Disabling triggers and foreign keys in the target database can reduce the frequency of information interaction during data writing, thereby improving the efficiency of data migration.

[0085] According to an embodiment of this disclosure, operation S302, sending environment configuration scripts to the source device and the target device respectively to configure the operating environment of the source database and the target database respectively, may include: sending a first configuration script to the source device, wherein the source device is configured to disable at least one target system job by running the first configuration script to configure the operating environment of the source database; and sending a second configuration script and a third configuration script to the target device respectively, wherein the target device is configured to disable at least one target trigger and at least one target foreign key by running the second configuration script and the third configuration script respectively to configure the operating environment of the target database.

[0086] According to embodiments of this disclosure, the source device executes a first configuration script through a first execution command to disable at least one target system job, thereby completing the configuration of the source database's operating environment. The first execution command can be any command capable of executing the first configuration script, such as the sqlplus command.

[0087] According to embodiments of this disclosure, the target device executes a second configuration script and a third configuration script respectively through a second execution command to disable at least one target trigger and at least one target foreign key, thereby completing the configuration of the target database's operating environment. The second execution command can be any command capable of executing the second configuration script and the third configuration script, such as the gsql -f command.

[0088] Figure 4 A flowchart illustrating the repair of the target database operating environment according to an embodiment of the present disclosure is shown.

[0089] like Figure 4 As shown, the target database operating environment repair includes: operations S401 to S402.

[0090] In operation S401, based on the third database view of the source database, the sequence number information associated with the source database is determined.

[0091] In operation S402, after confirming that the data migration task has been completed, the target database's operating environment is repaired based on job information, trigger information, foreign key information, and sequence number information.

[0092] According to an embodiment of this disclosure, a first command is used to log in to the source database of the source device, and then a third database view in the source database is queried to determine the serial number information associated with the source database. The first command can be the sqlplus command, and the third database view can include a serial number information view, for example, the serial number information view can be the dba_sequences view.

[0093] According to embodiments of this disclosure, serial number information can be obtained quickly and comprehensively by using a third database view to query serial number information associated with the source database.

[0094] According to embodiments of this disclosure, after the data migration task is completed, the operating environment of the target database is repaired to ensure that the target database can operate normally.

[0095] According to embodiments of this disclosure, operation S402, which repairs the operating environment of the target database based on job information, trigger information, foreign key information, and sequence number information, may include the following operations:

[0096] An environment repair script is generated based on the job information, the trigger information, the foreign key information, and the serial number information, respectively; and the environment repair script is sent to the target terminal device to repair the operating environment of the target database.

[0097] According to embodiments of this disclosure, relevant information about the target system job, target trigger, target foreign key, and target serial number is obtained using job information, trigger information, foreign key information, and serial number information. Environment repair scripts are generated using the aforementioned relevant information and related commands, and the operating environment of the target database is repaired based on the environment repair scripts.

[0098] According to embodiments of this disclosure, an environment repair script is generated using job information, trigger information, foreign key information, and serial number information, and the environment repair script is used to repair the operating environment of the target database, which can better ensure the security and availability of the target database after data migration.

[0099] According to embodiments of this disclosure, the environment remediation script includes a first initialization script, a second initialization script, a third initialization script, and a fourth initialization script. The step of generating the environment remediation script based on the job information, the trigger information, the foreign key information, and the serial number information may include the following operations:

[0100] The first initialization command is concatenated with the identification information and job configuration information of at least one target system job included in the job information to obtain the first initialization script.

[0101] The second initialization command is concatenated with the identification information and serial number configuration information of at least one target serial number included in the serial number information to obtain the second initialization script.

[0102] The third initialization command is concatenated with the identification information of at least one target trigger included in the trigger information to obtain the third initialization script.

[0103] The fourth initialization command is concatenated with the identification information of at least one target foreign key included in the foreign key information to obtain the fourth initialization script.

[0104] According to embodiments of this disclosure, identification information and job configuration information of all target system jobs are obtained from job information. A first initialization command is concatenated with the identification information and job configuration information of at least one target system job to output a first initialization script. The first initialization command is not limited and can be any command or command set that can initialize the target system job.

[0105] According to embodiments of this disclosure, job configuration information may include: system job startup information, system job call history information, and system job call interval.

[0106] According to embodiments of this disclosure, the identification information and serial number configuration information of each of the target serial numbers are obtained from the serial number information. The second initialization command is concatenated with the identification information and serial number configuration information of each of the at least one target serial number to output the second initialization script. The second initialization command is not limited and can be any command that can initialize the target serial number.

[0107] According to embodiments of this disclosure, the serial number configuration information may include: serial number step size.

[0108] According to embodiments of this disclosure, the output commands of the first initialization script and the second initialization script are not limited and can be spool commands.

[0109] According to embodiments of this disclosure, identification information of all target triggers is obtained from trigger information, and a third initialization command is concatenated with the identification information of at least one target trigger to output a third initialization script. The third initialization script can be any command or set of commands capable of initializing target triggers.

[0110] According to an embodiment of this disclosure, the identification information of all target foreign keys is obtained from the foreign key information, and the fourth initialization command is concatenated with the identification information of at least one target foreign key included in the foreign key information to output the fourth initialization script. The fourth initialization script can be any command or set of commands capable of initializing the target foreign keys.

[0111] According to embodiments of this disclosure, the output method of the third initialization script and the fourth initialization script is not limited, and can be a command output using the \o path file name.

[0112] According to embodiments of this disclosure, the first initialization script, the second initialization script, the third initialization script, and the fourth initialization script can all utilize the select command. For example, the first initialization script can use the select command to represent the command that can initialize the target system job in the form of a string.

[0113] According to the embodiments of this disclosure, the concatenation method for obtaining the first initialization script, the second initialization script, the third initialization script, and the fourth initialization script is not limited. Different concatenation methods can be used depending on the specific situation, such as using the pipe symbol ||.

[0114] According to embodiments of this disclosure, sending the environment repair script to the target terminal device to repair the operating environment of the target database may include the following operations:

[0115] The target device is sent a first initialization script, a second initialization script, a third initialization script, and a fourth initialization script, respectively. The target device is configured to start at least one target trigger and at least one target foreign key by running the third initialization script and the fourth initialization script, respectively. If the third initialization script and the fourth initialization script are both successfully executed, the target device will initialize at least one target system job and at least one target serial number by running the first initialization script and the second initialization script, respectively, in order to repair the operating environment of the target database.

[0116] According to embodiments of this disclosure, the target device uses a third execution command to execute a third initialization script and a fourth initialization script to start at least one target trigger and at least one target foreign key. If the third and fourth initialization scripts are successfully executed, the fourth execution command is used to execute a first initialization script and a second initialization script to initialize at least one target system job and at least one target serial number, thereby repairing the target database's operating environment. The third and fourth execution commands can be any commands that respectively execute the third and fourth initialization scripts, the first and second initialization scripts. For example, the third execution command can be the `gsql -f` command, and the fourth execution command can be the `sqlplus` command.

[0117] According to embodiments of this disclosure, an environment repair script is sent to a target device, which then executes the script to restart the target triggers and foreign keys, as well as initialize the target system jobs and target serial numbers. This can repair the operating environment of the target database, prevent related functions from malfunctioning, and enable the target database to operate normally after data migration.

[0118] Figure 5 A block diagram illustrating an environment remediation method based on data migration according to an embodiment of the present disclosure is shown schematically.

[0119] in, Figure 5 for Figures 2-4 The methods shown are different ways of describing the same method.

[0120] like Figure 5 As shown, the environment repair method based on data migration includes: program startup 510, system job shutdown 521, trigger and foreign key shutdown 522, migration task startup 530, trigger and foreign key activation 540, system job and serial number initialization 550, and program termination 560.

[0121] Program Startup 510: When a data migration request is received, the program starts.

[0122] System job shutdown 521: After the program starts, it performs relevant view queries on the source database to obtain job information and serial number information associated with the source database. It uses the job information to generate a system job shutdown script and executes the system job shutdown script on the source device as needed.

[0123] Trigger and foreign key shutdown 522: While shutting down system operations, triggers and foreign keys are also shut down. Relevant view queries are performed on the target database to obtain trigger and foreign key information associated with the target database. Trigger and foreign key shutdown scripts are generated using the trigger and foreign key information, and the trigger and foreign key shutdown scripts are executed on the target device as needed.

[0124] The migration task starts at 530. After the system jobs, triggers, and foreign keys are shut down, the data migration task can be started. Data migration tools can be used to perform the data migration.

[0125] With triggers and foreign keys enabled (540), after the data migration task is completed, trigger restart scripts and foreign key restart scripts are generated based on the trigger and foreign key information, and then executed on the target device.

[0126] System job and serial number initialization 550: After the trigger and foreign key are opened, job information and serial number information are generated to generate job information initialization script and serial number initialization script, and the job information initialization script and serial number initialization script are executed on the target device.

[0127] Program terminated 560. The target database runtime environment has been repaired and the program has terminated.

[0128] It should be noted that, unless it is explicitly stated that there is a sequential order of execution between different operations, or that there is a sequential order of execution between different operations in terms of technical implementation, the execution order between multiple operations may not be significant, and multiple operations may be executed simultaneously.

[0129] Figure 6 A block diagram of a data migration apparatus according to an embodiment of the present disclosure is shown schematically.

[0130] like Figure 6 As shown, the data migration device 600 includes a job information determination module 610, a trigger and foreign key information determination module 620, an operating environment configuration module 630, and a data migration module 640.

[0131] The job information determination module 610 is used to determine the job information associated with the source database based on a first database view of the source database included in the source device in response to a data migration request.

[0132] The trigger and foreign key information determination module 620 is used to determine trigger information and foreign key information associated with the target database based on a second database view of the target database included in the target terminal device.

[0133] The runtime environment configuration module 630 is used to configure the runtime environment of the source database and the target database based on job information, trigger information and foreign key information, respectively.

[0134] The data migration module 640 is used to run the data migration task carried in the data migration request, after confirming that the operating environment of both the source database and the target database has been configured, so as to migrate the data to be migrated from the source database to the target database.

[0135] According to embodiments of this disclosure, the runtime environment configuration module 630 includes an environment configuration script generation submodule and a runtime environment configuration submodule.

[0136] The environment configuration script generation submodule is used to generate environment configuration scripts based on job information, trigger information, and foreign key information, respectively.

[0137] The runtime environment configuration submodule is used to send environment configuration scripts to the source device and the target device respectively, so as to configure the runtime environment of the source database and the runtime environment of the target database respectively.

[0138] According to embodiments of this disclosure, the environment configuration script includes a first configuration script, a second configuration script, and a third configuration script. The environment configuration script generation submodule includes a first configuration script generation unit, a second configuration script generation unit, and a third configuration script generation unit.

[0139] The first configuration script generation unit is used to concatenate the first disable command with the identification information of at least one target system job included in the job information to obtain the first configuration script.

[0140] The second configuration script generation unit is used to concatenate the identification information of the second disable command and at least one target trigger included in the trigger information to obtain the second configuration script.

[0141] The third configuration script generation unit is used to concatenate the third disable command with the identification information of at least one target foreign key included in the foreign key information to obtain the third configuration script.

[0142] According to embodiments of this disclosure, the runtime environment configuration submodule includes: a source device configuration unit and a target device configuration unit.

[0143] The source device configuration unit is used to send a first configuration script to the source device, wherein the source device is configured to disable at least one target system job by running the first configuration script in order to configure the runtime environment of the source database.

[0144] The target device configuration unit is used to send a second configuration script and a third configuration script to the target device, respectively. The target device is configured to disable at least one target trigger and at least one target foreign key by running the second configuration script and the third configuration script, respectively, in order to configure the operating environment of the target database.

[0145] According to embodiments of this disclosure, the data migration apparatus 600 further includes a serial number information determination module and an operating environment determination module.

[0146] The serial number information determination module is used to determine the serial number information associated with the source database based on a third database view of the source database.

[0147] The runtime environment determination module is used to repair the runtime environment of the target database based on job information, trigger information, foreign key information, and sequence number information, after confirming that the data migration task has been completed.

[0148] According to embodiments of this disclosure, the runtime environment determination module includes an environment repair script generation submodule and a runtime environment repair submodule.

[0149] The environment remediation script generation submodule is used to generate environment remediation scripts based on job information, trigger information, foreign key information, and serial number information, respectively.

[0150] The runtime environment repair submodule is used to send environment repair scripts to the target device to repair the runtime environment of the target database.

[0151] According to embodiments of this disclosure, the environment remediation script includes a first initialization script, a second initialization script, a third initialization script, and a fourth initialization script. The environment remediation script generation submodule includes: a first initialization script generation unit, a second initialization script generation unit, a third initialization script generation unit, a fourth initialization script generation unit, and an environment remediation unit.

[0152] The first initialization script generation unit is used to concatenate the first initialization command with the identification information and job configuration information of at least one target system job included in the job information to obtain the first initialization script.

[0153] The second initialization script generation unit is used to concatenate the second initialization command with the identification information and serial number configuration information of at least one target serial number included in the serial number information to obtain the second initialization script.

[0154] The third initialization script generation unit is used to concatenate the third initialization command with the identification information of at least one target trigger included in the trigger information to obtain the third initialization script.

[0155] The fourth initialization script generation unit is used to concatenate the fourth initialization command with the identification information of at least one target foreign key included in the foreign key information to obtain the fourth initialization script.

[0156] According to embodiments of this disclosure, the operating environment repair submodule includes an environment repair unit.

[0157] The environment repair unit is used to send a first initialization script, a second initialization script, a third initialization script, and a fourth initialization script to the target device, respectively. The target device is configured to start at least one target trigger and at least one target foreign key by running the third initialization script and the fourth initialization script, respectively. If it is determined that the third initialization script and the fourth initialization script have both run successfully, the target device will initialize at least one target system job and at least one target serial number by running the first initialization script and the second initialization script, respectively, in order to repair the operating environment of the target database.

[0158] Any one or more of the modules, submodules, units, and subunits according to embodiments of the present disclosure, or at least part of the functions of any one or more of them, can be implemented in one module. Any one or more of the modules, submodules, units, and subunits according to embodiments of the present disclosure can be implemented by dividing them into multiple modules. Any one or more of the modules, submodules, units, and subunits according to embodiments of the present disclosure can be at least partially implemented as hardware circuitry, such as Field Programmable Gate Arrays (FPGAs), Programmable Logic Arrays (PLAs), Systems-on-Chip, Systems-on-Substrate, Systems-on-Package, Application-Specific Integrated Circuits (ASICs), or implemented in hardware or firmware by any other reasonable means of integrating or packaging circuitry, or implemented in software, hardware, or firmware, or in any suitable combination of any of these three implementation methods. Alternatively, one or more of the modules, submodules, units, and subunits according to embodiments of the present disclosure can be at least partially implemented as computer program modules, which, when run, can perform corresponding functions.

[0159] For example, any plurality of the job information determination module 610, trigger and foreign key information determination module 620, runtime environment configuration module 630, and data migration module 640 can be combined into one module / unit / subunit, or any one of these modules / units / subunits can be split into multiple modules / units / subunits. Alternatively, at least part of the functionality of one or more of these modules / units / subunits can be combined with at least part of the functionality of other modules / units / subunits and implemented in one module / unit / subunit. According to embodiments of the present disclosure, at least one of the job information determination module 610, trigger and foreign key information determination module 620, runtime environment configuration module 630, and data migration module 640 can be at least partially implemented as hardware circuitry, such as a field-programmable gate array (FPGA), a programmable logic array (PLA), a system-on-a-chip, a system-on-a-substrate, a system-on-package, an application-specific integrated circuit (ASIC), or any other reasonable means of integrating or packaging the circuitry, or implemented in software, hardware, or firmware, or in any suitable combination of any of these three implementation methods. Alternatively, at least one of the job information determination module 610, trigger and foreign key information determination module 620, runtime environment configuration module 630, and data migration module 640 can be at least partially implemented as a computer program module, which can perform corresponding functions when the computer program module is run.

[0160] It should be noted that the data migration device part in the embodiments of this disclosure corresponds to the data migration method part in the embodiments of this disclosure. The specific description of the data migration device part is referred to in the data migration method part, and will not be repeated here.

[0161] Figure 7 A block diagram of an electronic device suitable for implementing a data migration method according to an embodiment of the present disclosure is shown schematically. Figure 7 The electronic device shown is merely an example and should not be construed as limiting the functionality and scope of the embodiments disclosed herein.

[0162] like Figure 7 As shown, an electronic device 700 according to an embodiment of the present disclosure includes a processor 701, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 702 or a program loaded from a storage portion 708 into a random access memory (RAM) 703. The processor 701 may include, for example, a general-purpose microprocessor (e.g., a CPU), an instruction set processor and / or an associated chipset and / or a special-purpose microprocessor (e.g., an application-specific integrated circuit (ASIC)), etc. The processor 701 may also include onboard memory for caching purposes. The processor 701 may include a single processing unit or multiple processing units for performing different actions of the method flow according to an embodiment of the present disclosure.

[0163] RAM 703 stores various programs and data required for the operation of electronic device 700. Processor 701, ROM 702, and RAM 703 are interconnected via bus 704. Processor 701 performs various operations of the method flow according to embodiments of the present disclosure by executing programs in ROM 702 and / or RAM 703. It should be noted that programs may also be stored in one or more memories other than ROM 702 and RAM 703. Processor 701 may also perform various operations of the method flow according to embodiments of the present disclosure by executing programs stored in one or more memories.

[0164] According to embodiments of this disclosure, the electronic device 700 may further include an input / output (I / O) interface 705, which is also connected to a bus 704. The electronic device 700 may also include one or more of the following components connected to the I / O interface 705: an input section 707 including a keyboard, mouse, etc.; an output section 706 including a cathode ray tube (CRT), liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 708 including a hard disk, etc.; and a communication section 709 including a network interface card such as a LAN card, modem, etc. The communication section 709 performs communication processing via a network such as the Internet. A drive 710 is also connected to the I / O interface 705 as needed. A removable medium 711, such as a disk, optical disk, magneto-optical disk, semiconductor memory, etc., is installed on the drive 710 as needed so that computer programs read from it can be installed into the storage section 708 as needed.

[0165] According to embodiments of this disclosure, the method flow according to embodiments of this disclosure can be implemented as a computer software program. For example, embodiments of this disclosure include a computer program product comprising a computer program carried on a computer-readable storage medium, the computer program containing program code for performing the methods shown in the flowchart. In such embodiments, the computer program can be downloaded and installed from a network via communication section 709, and / or installed from removable medium 711. When the computer program is executed by processor 701, it performs the functions defined in the system of embodiments of this disclosure. According to embodiments of this disclosure, the systems, devices, apparatuses, modules, units, etc., described above can be implemented by computer program modules.

[0166] This disclosure also provides a computer-readable storage medium, which may be included in the device / apparatus / system described in the above embodiments; or it may exist independently and not assembled into the device / apparatus / system. The computer-readable storage medium carries one or more programs that, when executed, implement the method according to the embodiments of this disclosure.

[0167] According to embodiments of this disclosure, the computer-readable storage medium can be a non-volatile computer-readable storage medium. Examples include, but are not limited to: portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof. In this disclosure, the computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.

[0168] For example, according to embodiments of this disclosure, a computer-readable storage medium may include the ROM 702 and / or RAM 703 described above and / or one or more memories other than ROM 702 and RAM 703.

[0169] Embodiments of this disclosure also include a computer program product comprising a computer program containing program code for performing the methods provided in the embodiments of this disclosure. When the computer program product is run on an electronic device, the program code is used to enable the electronic device to implement the data migration methods provided in the embodiments of this disclosure.

[0170] When the computer program is executed by the processor 701, it performs the functions defined in the system / apparatus of this disclosure embodiments. According to embodiments of this disclosure, the systems, apparatuses, modules, units, etc., described above can be implemented by computer program modules.

[0171] In one embodiment, the computer program may rely on a tangible storage medium such as an optical storage device or a magnetic storage device. In another embodiment, the computer program may also be transmitted and distributed in the form of signals over a network medium, and may be downloaded and installed via the communication section 709, and / or installed from a removable medium 711. The program code contained in the computer program can be transmitted using any suitable network medium, including but not limited to: wireless, wired, etc., or any suitable combination thereof.

[0172] According to embodiments of this disclosure, program code for executing the computer programs provided in embodiments of this disclosure can be written in any combination of one or more programming languages. Specifically, these computational programs can be implemented using high-level procedural and / or object-oriented programming languages, and / or assembly / machine languages. Programming languages ​​include, but are not limited to, languages ​​such as Java, C++, Python, "C", or similar programming languages. The program code can execute entirely on the user's computing device, partially on the user's device, partially on a remote computing device, or entirely on a remote computing device or server. In cases involving remote computing devices, the remote computing device can be connected to the user's computing device via any type of network, including a local area network (LAN) or a wide area network (WAN), or it can be connected to an external computing device (e.g., via the Internet using an Internet service provider).

[0173] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of the present disclosure. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in a block diagram or flowchart, and combinations of blocks in a block diagram or flowchart, may be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions. Those skilled in the art will understand that the features recited in the various embodiments and / or claims of this disclosure can be combined and / or combined in various ways, even if such combinations or combinations are not expressly described in this disclosure. In particular, the features described in the various embodiments and / or claims of this disclosure may be combined and / or combined in various ways without departing from the spirit and teachings of this disclosure. All such combinations and / or combinations fall within the scope of this disclosure.

[0174] The embodiments of this disclosure have been described above. However, these embodiments are for illustrative purposes only and are not intended to limit the scope of this disclosure. Although various embodiments have been described above, this does not mean that the measures in the various embodiments cannot be used advantageously in combination. The scope of this disclosure is defined by the appended claims and their equivalents. Various substitutions and modifications can be made by those skilled in the art without departing from the scope of this disclosure, and all such substitutions and modifications should fall within the scope of this disclosure.

Claims

1. A data migration method, comprising: In response to a data migration request, job information associated with the source database is determined based on a first database view of the source database included in the source device. Based on a second database view of the target database included in the target terminal device, determine the trigger information and foreign key information associated with the target database; Based on the job information, the trigger information, and the foreign key information, configure the operating environment of the source database and the operating environment of the target database respectively; as well as If the operating environment of the source database and the operating environment of the target database are both configured, the data migration task carried in the data migration request is executed to migrate the data to be migrated from the source database to the target database. The runtime environment is configured based on an environment configuration script, which includes a first configuration script, a second configuration script, and a third configuration script. The operation of generating the environment configuration script includes: The first disable command is concatenated with the identification information of at least one target system job included in the job information to obtain the first configuration script; The second disable command is concatenated with the identification information of at least one target trigger included in the trigger information to obtain the second configuration script; and The third disable command is concatenated with the identification information of at least one target foreign key included in the foreign key information to obtain the third configuration script.

2. The method according to claim 1, wherein, The step of configuring the operating environment of the source database and the target database based on the job information, the trigger information, and the foreign key information includes: Based on the job information, the trigger information, and the foreign key information, respectively, generate an environment configuration script; and The environment configuration scripts are sent to the source device and the target device respectively to configure the operating environment of the source database and the operating environment of the target database respectively.

3. The method according to claim 2, wherein, The step of sending the environment configuration script to the source device and the target device respectively to configure the operating environment of the source database and the target database respectively includes: Send the first configuration script to the source device, wherein the source device is configured to disable the at least one target system job by running the first configuration script to configure the runtime environment of the source database; and The second configuration script and the third configuration script are sent to the target terminal device, respectively, wherein the target terminal device is configured to disable the at least one target trigger and the at least one target foreign key by running the second configuration script and the third configuration script, respectively, in order to configure the operating environment of the target database.

4. The method according to claim 1, further comprising: Based on the third database view of the source database, determine the serial number information associated with the source database; as well as Once the data migration task is confirmed to be complete, the operating environment of the target database is repaired based on the job information, the trigger information, the foreign key information, and the sequence number information.

5. The method according to claim 4, wherein, The method of repairing the target database's operating environment based on the job information, the trigger information, the foreign key information, and the sequence number information includes: Based on the job information, the trigger information, the foreign key information, and the serial number information, respectively, generate an environment repair script; and The environment repair script is sent to the target device to repair the operating environment of the target database.

6. The method according to claim 5, wherein, The environment repair script includes a first initialization script, a second initialization script, a third initialization script, and a fourth initialization script; The step of generating an environment repair script based on the job information, the trigger information, the foreign key information, and the serial number information includes: The first initialization command is concatenated with the identification information and job configuration information of at least one target system job included in the job information to obtain the first initialization script; The second initialization command is concatenated with the identification information and serial number configuration information of each of the at least one target serial number included in the serial number information to obtain the second initialization script; The third initialization command is concatenated with the identification information of at least one target trigger included in the trigger information to obtain the third initialization script; The fourth initialization command is concatenated with the identification information of at least one target foreign key included in the foreign key information to obtain the fourth initialization script.

7. The method according to claim 6, wherein, Sending the environment repair script to the target terminal device to repair the operating environment of the target database includes: The first initialization script, the second initialization script, the third initialization script, and the fourth initialization script are sent to the target terminal device, respectively. The target terminal device is configured to start the at least one target trigger and the at least one target foreign key by running the third initialization script and the fourth initialization script, respectively. If it is determined that the third initialization script and the fourth initialization script have both run successfully, the first initialization script and the second initialization script are run to initialize the at least one target system job and the at least one target serial number, respectively, so as to repair the operating environment of the target database.

8. A data migration apparatus, comprising: The job information determination module is used to determine the job information associated with the source database based on a first database view of the source database included in the source device in response to a data migration request. The trigger and foreign key information determination module is used to determine trigger information and foreign key information associated with the target database based on a second database view of the target database included in the target terminal device. The runtime environment configuration module is used to configure the runtime environment of the source database and the runtime environment of the target database based on the job information, the trigger information, and the foreign key information, respectively. as well as The data migration module is used to run the data migration task carried in the data migration request when it is determined that the operating environment of the source database and the operating environment of the target database are both configured, so as to migrate the data to be migrated in the source database to the target database. The runtime environment is configured based on an environment configuration script, which includes a first configuration script, a second configuration script, and a third configuration script. The operation of generating the environment configuration script includes: The first disable command is concatenated with the identification information of at least one target system job included in the job information to obtain the first configuration script; The second disable command is concatenated with the identification information of at least one target trigger included in the trigger information to obtain the second configuration script; and The third disable command is concatenated with the identification information of at least one target foreign key included in the foreign key information to obtain the third configuration script.

9. An electronic device, comprising: One or more processors; Memory, used to store one or more instructions. When the one or more instructions are executed by the one or more processors, the one or more processors cause the one or more processors to implement the method of any one of claims 1 to 7.

10. A computer-readable storage medium having executable instructions stored thereon, which, when executed by a processor, cause the processor to perform the method of any one of claims 1 to 7.

11. A computer program product comprising computer-executable instructions, which, when executed, are used to implement the method of any one of claims 1 to 7.

Images