A method, device and medium for migrating business configuration data

Abstract

The present application discloses a method, device, and medium for migrating business configuration data, which is used to solve the technical problem in the prior art that different databases support different data formats and SQL syntaxes, requiring manual selection, which is cumbersome and prone to errors. The method includes: determining the export rules corresponding to the current database to determine the field information corresponding to the current database; uniformly converting the field information corresponding to the current database into data in a preset format, and parsing the data in the preset format through a data import tool to obtain a parsing result; setting the preset field information in the target database as a protected column; if the field of the corresponding field information of the current database is the same as the field of the preset field information corresponding to the protected column, directly adding the field information corresponding to the current database to the target database; and achieving data migration to the target database based on the parsing result without overwriting the field value of the preset field information corresponding to the protected column.

Description

Technical Field

[0001] The present application relates to the technical field of data migration, and in particular to a method, device, and medium for migrating business configuration data. Background Art

[0002] Society is currently in an era of domestic information replacement. Because products previously relied primarily on international mainstream databases for development, the transition to domestic databases often requires a significant amount of cross-database migration for business data. During this data migration process, different databases support different data formats, requiring manual processing based on the database being migrated. This wastes human resources, increases costs, and fails to ensure that data in the target database is not overwritten by the current database during the migration process. Furthermore, manual processing is cumbersome and prone to errors such as missed or overly selected data. Summary of the Invention

[0003] The embodiments of the present application provide a method, device, and medium for migrating business configuration data to solve the technical problem in the prior art that different databases support different data formats and SQL syntaxes, which requires manual selection and is cumbersome and prone to errors.

[0004] On the one hand, an embodiment of the present application provides a method for migrating business configuration data, including: determining the export rules corresponding to the current database from preset export rules, so as to determine the field information corresponding to the current database in the data export page according to the export rules corresponding to the current database; uniformly converting the field information corresponding to the current database into data in a preset format, and parsing the data in the preset format through a data import tool to obtain a parsing result; setting the preset field information in the target database as a protection column; wherein the protection column is set to avoid the field value of the preset field information being overwritten by the field value of the corresponding field information in the current database; if the field of the corresponding field information of the current database is the same as the field of the preset field information corresponding to the protection column, then the field information corresponding to the current database is directly added to the target database; wherein the field information includes fields and corresponding field values; without overwriting the field value of the preset field information corresponding to the protection column, data migration to the target database is realized according to the parsing result.

[0005] In one implementation of the present application, in the data export page, before determining the field information corresponding to the current database according to the export rules corresponding to the current database, it also includes: determining the basic field information corresponding to the data export page in the current database; wherein the basic field information includes at least: timestamp, modifier; in the data export page, the basic field information is set as a display field.

[0006] In one implementation of the present application, before determining the export rule corresponding to the current database from the preset export rules, it also includes: creating export rules corresponding to each database, and entering the rule number, rule name and description information of the data association relationship between each table in the database in the corresponding export rule; and determining the database table object corresponding to the current database from a number of database table objects, and adding the corresponding database table object to the corresponding export rule to implement the setting of the export rules for each database.

[0007] In one implementation of the present application, after determining the field information corresponding to the current database, the method further includes: setting the field information corresponding to the current database into one or more data DATA files for export.

[0008] In one implementation of the present application, after the field information corresponding to the current database is set as one or more data DATA files for export, it also includes: inputting the connection information between the current database and the target database and the path corresponding to the exported DATA file into a data import tool; parsing the DATA file through the data import tool to generate a database SQL statement corresponding to the target database; and realizing data migration to the target database by executing the SQL statement.

[0009] In one implementation of the present application, the field information corresponding to the current database is uniformly converted into data in a preset format, and the data in the preset format is parsed by a data import tool. Before obtaining the parsing result, it also includes: querying according to the export rules from a preset data export menu to obtain the field information corresponding to the export rules; verifying the data in the corresponding field information by a data import tool. If the verification result is that the corresponding field information is consistent with the imported data corresponding to the data import tool, it is determined that the export rule is set correctly.

[0010] In one implementation of the present application, the field information corresponding to the current database is uniformly converted into data in a preset format, and the data in the preset format is parsed by a data import tool. Before obtaining the parsing result, it also includes: returning to the data export menu by clicking the selection button in the data export page, and continuing to select field information from the data export menu according to the export rules corresponding to the current database, and adding the selected field information to the field information corresponding to the current database that has been determined; by clicking the delete button in the data export page, the field information corresponding to the current database that has been determined is deselected.

[0011] In one implementation of the present application, it also includes: when exporting the field information corresponding to the current database, according to the query conditions corresponding to the main query object in the current database, querying the field information in the secondary object table that has an association relationship with the main query object to realize the export of the associated field information.

[0012] On the other hand, an embodiment of the present application also provides a device for migrating business configuration data, the device comprising: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can: determine the export rule corresponding to the current database from the preset export rule, so as to determine the field information corresponding to the current database in the data export page according to the export rule corresponding to the current database; uniformly convert the field information corresponding to the current database into data in a preset format, and parse the data in the preset format through a data import tool to obtain a parsing result; set the preset field information in the target database as a protection column; wherein the protection column is set to prevent the field value of the preset field information from being overwritten by the field value of the corresponding field information in the current database; if the field of the corresponding field information of the current database is the same as the field of the preset field information corresponding to the protection column, then the field information corresponding to the current database is directly added to the target database; wherein the field information includes fields and corresponding field values; without overwriting the field value of the preset field information corresponding to the protection column, data migration to the target database is achieved according to the parsing result.

[0013] On the other hand, an embodiment of the present application also provides a non-volatile computer storage medium storing computer executable instructions, wherein the computer executable instructions are configured to: determine the export rules corresponding to the current database from preset export rules, so as to determine the field information corresponding to the current database in the data export page according to the export rules corresponding to the current database; uniformly convert the field information corresponding to the current database into data in a preset format, and parse the data in the preset format through a data import tool to obtain a parsing result; set the preset field information in the target database as a protection column; wherein the protection column is set to avoid the field value of the preset field information being overwritten by the field value of the corresponding field information in the current database; if the field of the corresponding field information of the current database is the same as the field of the preset field information corresponding to the protection column, then the field information corresponding to the current database is directly added to the target database; wherein the field information includes fields and corresponding field values; without overwriting the field value of the preset field information corresponding to the protection column, data migration to the target database is realized according to the parsing result.

[0014] Embodiments of the present application provide a method, device, and medium for migrating business configuration data, which have at least the following beneficial effects: by determining the export rule corresponding to the current database from preset export rules, field information corresponding to the current database to be exported can be selected from the export menu according to the export rule, thereby realizing data export during data migration; converting the exported field information into a unified format, thereby making the data of the two databases common for data migration; parsing the data in the preset format using a data import tool to obtain a parsing result, thereby enabling the target database to obtain these field information according to its own storage format after obtaining the common data; setting the preset fields in the target database as protected columns, thereby preventing the field values ​​of the preset field information in the target database from being overwritten by the field values ​​of the corresponding field information in the current database during data migration; when the fields of the current database field information are the same as the fields of the target database field information, to avoid the field values ​​corresponding to the protected columns being overwritten, it is not necessary to replace the field information corresponding to the target database with the field information of the current database, and the field information corresponding to the current database can be directly stored in the target database; in this way, on the basis of ensuring that the field values ​​corresponding to the preset fields of the protected columns of the target database are not overwritten, data migration from the current database to the target database is realized based on the parsing result of the corresponding field information of the current database. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] The drawings described herein are used to provide a further understanding of the present application and constitute a part of the present application. The illustrative embodiments of the present application and their descriptions are used to explain the present application and do not constitute an improper limitation on the present application. In the drawings:

[0016] Figure 1 A flowchart of a method for migrating business configuration data provided in an embodiment of the present application;

[0017] Figure 2 A schematic diagram of database table object selection provided in an embodiment of the present application;

[0018] Figure 3 A schematic diagram of export rule selection provided in an embodiment of the present application;

[0019] Figure 4 A schematic diagram of selecting field information according to export rules provided in an embodiment of the present application;

[0020] Figure 5 Schematic diagram of the data export page provided in an embodiment of the present application;

[0021] Figure 6 A schematic diagram of the export method selection provided in the embodiment of the present application;

[0022] Figure 7 A schematic diagram of the internal structure of a device for migrating business configuration data provided in an embodiment of the present application. DETAILED DESCRIPTION

[0023] To make the purpose, technical solutions, and advantages of this application more clear, the technical solutions of this application will be clearly and completely described below in conjunction with the specific embodiments of this application and the corresponding drawings. Obviously, the embodiments described are only part of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of this application.

[0024] The embodiment of the present application provides a method, device and medium for migrating business configuration data. By determining the export rule corresponding to the current database from the preset export rule, the field information corresponding to the current database to be exported can be selected in the export menu according to the export rule to realize data export in data migration; the exported field information is converted into a unified format, which can make the data of the two databases for data migration common; the data in the preset format is parsed by the data import tool to obtain the parsing result, which can enable the target database to obtain these field information according to its own storage format after obtaining the common data; the preset field in the target database is set as a protection column, which can avoid the field value of the preset field information in the target database being overwritten by the field value of the corresponding field information in the current database during data migration; when the field of the current database field information is the same as the field of the target database field information, in order to avoid the field value corresponding to the protection column being overwritten, it is not necessary to replace the field information corresponding to the target database with the field information of the current database, and the field information corresponding to the current database can be directly stored in the target database. The technical problem that different databases support different data formats and SQL syntaxes in the prior art, which requires manual selection and is cumbersome and prone to errors is solved.

[0025] The technical solutions proposed in the embodiments of the present application are described in detail below with reference to the accompanying drawings.

[0026] Figure 1 This is a flow chart of a method for migrating business configuration data provided by an embodiment of the present application. Figure 1 As shown, the method for migrating service configuration data provided in the embodiment of the present application mainly includes the following steps:

[0027] Step 101: Determine the export rule corresponding to the current database from the preset export rules, so as to determine the field information corresponding to the current database on the data export page according to the export rule corresponding to the current database.

[0028] The server determines the export rule corresponding to the current database from the preset export rules corresponding to the data migration of the current database, and thus determines the field information corresponding to the current database according to the export rule corresponding to the current database on the data export page.

[0029] In one embodiment of the present application, before determining the export rule corresponding to the current database from the preset export rules, the server creates an export rule corresponding to each database that requires data migration. The server then enters the rule number, rule name, and description of the data association between each table in the corresponding database into the export rule corresponding to each database, thereby defining the export rule for the database. Furthermore, the server determines the database table object corresponding to the current database from among several database table objects and adds the determined database table object to the corresponding export rule, completing the configuration of the export rule for each database.

[0030] Figure 2 This is a diagram of database table object selection provided in the embodiment of the present application. Figure 2 As shown, the server selects an object corresponding to the current database from pre-stored database table objects, and adds the selected object to the export rule corresponding to the current database, completing the addition of objects when setting the export rule.

[0031] Figure 3 This is a schematic diagram of export rule selection provided in the embodiment of this application. Figure 3 As shown, the server selects the export rule corresponding to the current database from the preset export rules, and then selects the export rule on the data export page. This allows the field information corresponding to the current database to be exported according to the export rule corresponding to the current database. Specifically, the server needs to enter the rule number and rule name corresponding to the export rule of the current database. The page will then export the field information corresponding to the current database based on the selected rule number and rule name.

[0032] In one embodiment of the present application, the server needs to determine the basic field information corresponding to the data export page in the current database before determining the field information corresponding to the current database according to the export rules corresponding to the current database in the data export page. It should be noted that the basic field information in the embodiment of the present application is the field information that must be displayed in the export page, such as: timestamp, modifier and other field information. The server then sets the determined basic field information as a display field in the data export page. The purpose of setting whether the field is displayed in the data export page is to filter out field information that is useless for users to select data for export.

[0033] When the embodiment of the present application exports the field information corresponding to the current database, the supported basic data types are shown in Table 1 below.

[0034] Table 1 Basic data types of exported field information

[0035]

[0036]

[0037] The class structure corresponding to the export rules of this application is shown in Table 2 below.

[0038] Table 2 Export rule class structure

[0039]

[0040] Step 102: uniformly convert the field information corresponding to the current database into data in a preset format, and parse the data in the preset format using a data import tool to obtain a parsing result.

[0041] After obtaining the field information corresponding to the current database, the server converts the field information corresponding to the current database into data in a preset format. The server then uses the data import tool to parse the data in the preset format and obtain the corresponding parsing results. In this way, the target database can obtain the field information in its own corresponding format. It should be noted that the preset format of the data in the embodiment of the present application is JSON format. After converting the field information corresponding to the current database into JSON format, the exported data is more versatile.

[0042] In one embodiment of the present application, before the server uniformly converts the field information corresponding to the current database into data in a preset format and parses the data in the preset format through a data import tool to obtain the parsing result, it is necessary to perform data query according to the export rules from a preset data export menu and obtain the field information corresponding to the export rules of the current database; then, the data in the corresponding field information obtained is verified through the data import tool, and when the verification result is that the corresponding field information obtained is consistent with the import data corresponding to the data import tool, it is determined that the currently set export rules are correct, and the verification of the export rules before data migration is completed, so as to ensure that the export rules corresponding to the set database are consistent with the actual situation of the database.

[0043] Figure 4 This is a schematic diagram of selecting field information according to the export rules provided in the embodiment of the present application. Figure 4 As shown, in the server's preset data export menu, select the export rule and check whether the data loaded according to the current export rule is consistent with the defined information. After confirming that the data loading is correct, select several data items to export, and then use the independent data import tool to import the data and compare whether they are consistent. If the data is consistent, the rule definition is correct.

[0044] In one embodiment of the present application, before the server uniformly converts the field information corresponding to the current database into data in a preset format and parses the data in the preset format through a data import tool to obtain the parsing result, it can return to the data export menu by clicking the selection button in the data export page, and then continue to select the field information that needs to be added in the data export menu according to the export rules corresponding to the current database, and then add the selected field information to the field information corresponding to the current database that has been determined. At the same time, the server can also unselect the field information corresponding to the current database that has been determined by clicking the delete button in the data export page. By setting a selection button and a delete button in the data export page, the present application can re-operate on the content in the data export page in the event that the user makes a wrong selection or misses a selection, thereby ensuring the correctness of the field information corresponding to the current database in the data export page.

[0045] Figure 5 This is a schematic diagram of the data export page provided in the embodiment of this application. Figure 5 As shown, the upper right corner of the data export page has a Select Data button and a Delete Data button. By clicking the Select Data button, the server can return to the field information selection page, continue to select the field information corresponding to the database according to actual needs, and then add the selected field information to the field information corresponding to the current database that has been determined. By clicking the Delete Data button, the server can delete the field information of the current database that has been determined on the data export page and unselect it.

[0046] Step 103: Set the preset field information in the target database as a protected column.

[0047] To prevent field information in the current database from overwriting existing field information in the target database during data migration, this application introduces the concept of protected columns. This application sets the preset fields in the target database as protected columns. This way, when performing data migration, the preset fields corresponding to the protected columns that already exist in the target database will not be overwritten.

[0048] Step 104: If the fields of the field information corresponding to the current database are the same as the fields of the preset field information corresponding to the protection column, the field information corresponding to the current database is directly added to the target database.

[0049] When the server determines that the field corresponding to the field information of the current database is the same as the field corresponding to the field information of the protection column in the target database, in order to avoid the field information in the protection column from being overwritten, the server directly adds the field information corresponding to the current database to the target database. At this time, the field information corresponding to the protection column of the target database and the field information corresponding to the current database are stored in the target database at the same time.

[0050] In one embodiment of the present application, when exporting field information corresponding to the current database, the server also searches for field information in secondary object tables associated with the primary query object in the current database based on the query conditions corresponding to the primary query object in the current database. This adds the field information in the secondary object tables to the data export page, thereby exporting the field information associated with the primary query object. This application implements a single query export of business association tables and describes the relationships between multiple business association tables in rule units.

[0051] Step 105: Without overwriting the field value of the preset field information corresponding to the protection column, realize data migration to the target database according to the parsing result.

[0052] The server implements data migration from the current database to the target database by executing the SQL statement corresponding to the target database in the parsing result, while ensuring that the field information corresponding to the current database does not overwrite the preset field corresponding to the protection column of the target database.

[0053] In one embodiment of the present application, after determining the field information corresponding to the current database, the server exports the database table object to the current target database. The field information corresponding to the current database can be exported as one file, or the field information corresponding to the current database can be exported as multiple files. When exporting to multiple files, the field information corresponding to the current database can be set as multiple DATA files for export according to the database table object in the preset rules.

[0054] In one embodiment of the present application, after the server sets the field information corresponding to the current database into one or more data DATA files for export, the server inputs the database connection information between the current database and the target database, as well as the path information corresponding to the exported DATA files, into the data import tool, so that the exported DATA files are parsed by the data import tool to generate the database SQL statements corresponding to the target database; by executing the SQL statements corresponding to the target database, data migration to the target database is realized.

[0055] Figure 6 This is a schematic diagram of the export method selection provided in the embodiment of this application. Figure 6As shown, when the server exports the field information corresponding to the determined current database, it customizes the file name of the retaining wall export file in the export page, and also needs to select the export method corresponding to the data to be exported, thereby completing the entire export process.

[0056] The above is an embodiment of the method proposed in this application. Based on the same inventive concept, this application embodiment also provides a device for migrating business configuration data, the structure of which is as follows: Figure 7 shown.

[0057] Figure 7 This is a schematic diagram of the internal structure of a device for migrating business configuration data provided in an embodiment of the present application. Figure 7 As shown, the device includes at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can: determine the export rule corresponding to the current database from the preset export rule, so as to determine the field information corresponding to the current database in the data export page according to the export rule corresponding to the current database; uniformly convert the field information corresponding to the current database into data in a preset format, and parse the data in the preset format through a data import tool to obtain a parsing result; set the preset field information in the target database as a protection column; wherein the protection column is set to avoid the field value of the preset field information being overwritten by the field value of the corresponding field information in the current database; if the field of the corresponding field information of the current database is the same as the field of the preset field information corresponding to the protection column, the field information corresponding to the current database is directly added to the target database; wherein the field information includes fields and corresponding field values; without overwriting the field value of the preset field information corresponding to the protection column, data migration to the target database is realized according to the parsing result.

[0058] An embodiment of the present application also provides a non-volatile computer storage medium storing computer executable instructions, wherein the computer executable instructions are configured to: determine the export rule corresponding to the current database from preset export rules, so as to determine the field information corresponding to the current database in the data export page according to the export rule corresponding to the current database; uniformly convert the field information corresponding to the current database into data in a preset format, and parse the data in the preset format through a data import tool to obtain a parsing result; set the preset field information in the target database as a protection column; wherein the protection column is set to prevent the field value of the preset field information from being overwritten by the field value of the corresponding field information in the current database; if the field of the corresponding field information of the current database is the same as the field of the preset field information corresponding to the protection column, then directly add the field information corresponding to the current database to the target database; wherein the field information includes the field and the corresponding field value; without overwriting the field value of the preset field information corresponding to the protection column, data migration to the target database is achieved according to the parsing result.

[0059] The various embodiments in this application are described in a progressive manner. Similar portions between the various embodiments can be referred to in conjunction with each other. Each embodiment focuses on the differences between the other embodiments. In particular, the device and medium embodiments are generally similar to the method embodiments, so their descriptions are relatively simple. For relevant portions, refer to the descriptions of the method embodiments.

[0060] The devices and media provided in the embodiments of the present application correspond one-to-one to the methods. Therefore, the devices and media also have similar beneficial technical effects to their corresponding methods. Since the beneficial technical effects of the methods have been described in detail above, the beneficial technical effects of the devices and media will not be repeated here.

[0061] Those skilled in the art will appreciate that the embodiments of the present application can be provided as methods, systems, or computer program products. Therefore, the present application can adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application can adopt the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to magnetic disk storage, CD-ROM, optical storage, etc.) that contain computer-usable program code.

[0062] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the steps in the process. Figure 1 a process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0063] These computer program instructions may also be stored in a computer readable memory that can direct a computer or other programmable data processing device to work in a specific manner, so that the instructions stored in the computer readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 a process or multiple processes and / or boxes Figure 1 The function specified in one or more boxes.

[0064] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operational steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing the instructions executed on the computer or other programmable device for implementing the process. Figure 1 a process or multiple processes and / or boxes Figure 1 A step that specifies a function in one or more boxes.

[0065] In a typical configuration, a computing device includes one or more processors (CPUs), input / output interfaces, network interfaces, and memory.

[0066] Memory may include non-permanent storage in a computer-readable medium, random access memory (RAM) and / or non-volatile memory in the form of read-only memory (ROM) or flash RAM. Memory is an example of a computer-readable medium.

[0067] Computer-readable media includes permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology to store information. The information can be computer-readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disc read-only memory (CD-ROM), digital versatile disc (DVD) or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer-readable media does not include transitory computer-readable media (transitory media), such as modulated data signals and carrier waves.

[0068] It should also be noted that the terms "comprises," "includes," or any other variations thereof are intended to encompass non-exclusive inclusion, such that a process, method, commodity, or apparatus that includes a series of elements includes not only those elements but also other elements not explicitly listed, or includes elements inherent to such process, method, commodity, or apparatus. In the absence of further limitations, an element defined by the phrase "comprises a ..." does not exclude the presence of other identical elements in the process, method, commodity, or apparatus that includes the element.

[0069] The foregoing is merely an embodiment of the present application and is not intended to limit the present application. For those skilled in the art, the present application may have various changes and variations. Any modifications, equivalent replacements, improvements, etc. made within the spirit and principles of the present application should all be included within the scope of the claims of the present application.

Claims

1. A method for migrating business configuration data, characterized in that: The method comprises: Determine an export rule corresponding to the current database from preset export rules, so as to determine field information corresponding to the current database on the data export page according to the export rule corresponding to the current database; Convert the field information corresponding to the current database into data in a preset format, and parse the data in the preset format using a data import tool to obtain a parsing result; Setting the preset field information in the target database as a protected column; wherein the protected column is set to prevent the field value of the preset field information from being overwritten by the field value of the corresponding field information in the current database; If the field of the field information corresponding to the current database is the same as the field of the preset field information corresponding to the protection column, the field information corresponding to the current database is directly added to the target database; wherein the field information includes the field and the corresponding field value; Without overwriting the field value of the preset field information corresponding to the protected column, implementing data migration to the target database according to the parsing result; After determining the field information corresponding to the current database, the method further includes: The field information corresponding to the current database is set to one or more data DATA files for export; After exporting the field information corresponding to the current database into one or more data files, the method further includes: Input the connection information between the current database and the target database and the path corresponding to the exported DATA file into the data import tool; Parsing the DATA file through the data import tool to generate a database SQL statement corresponding to the target database; By executing the SQL statement, data migration to the target database is achieved.

2. A method for migrating business configuration data according to claim 1, characterized in that: In the data export page, before determining the field information corresponding to the current database according to the export rule corresponding to the current database, the method further includes: Determine basic field information corresponding to the data export page in the current database; wherein the basic field information includes at least: a timestamp and a modifier; In the data export page, the basic field information is set as a display field.

3. The method for migrating business configuration data according to claim 1, characterized in that: Before determining the export rule corresponding to the current database from the preset export rules, the method further includes: Create an export rule corresponding to each database, and enter the rule number, rule name, and description information of the association relationship between the data tables in the database in the corresponding export rule; And determining the database table object corresponding to the current database from the plurality of database table objects, and adding the corresponding database table object to the corresponding export rule to implement the setting of each database export rule.

4. The method for migrating business configuration data according to claim 1, characterized in that: Before uniformly converting the field information corresponding to the current database into data in a preset format and parsing the data in the preset format using a data import tool to obtain the parsing result, the method further includes: From the preset data export menu, query according to the export rule to obtain the field information corresponding to the export rule; The data in the corresponding field information is verified by a data import tool. If the verification result is that the corresponding field information is consistent with the imported data corresponding to the data import tool, it is determined that the export rule setting is correct.

5. The method for migrating business configuration data according to claim 1, characterized in that: Before uniformly converting the field information corresponding to the current database into data in a preset format and parsing the data in the preset format using a data import tool to obtain the parsing result, the method further includes: By clicking the selection button in the data export page, returning to the data export menu, continuing to select field information from the data export menu according to the export rules corresponding to the current database, and adding the selected field information to the determined field information corresponding to the current database; By clicking the delete button in the data export page, the field information corresponding to the current database that has been determined is deselected.

6. A method for migrating service configuration data according to any one of claims 1 to 5, characterized in that: The method further comprises: When exporting the field information corresponding to the current database, according to the query conditions corresponding to the main query object in the current database, the field information in the secondary object table associated with the main query object is queried to realize the export of the associated field information.

7. A device for migrating business configuration data, characterized in that: The device comprises: at least one processor; and, a memory communicatively connected to the at least one processor; wherein, The memory stores instructions executable by the at least one processor, the instructions being executed by the at least one processor to enable the at least one processor to: Determine an export rule corresponding to the current database from preset export rules, so as to determine field information corresponding to the current database on the data export page according to the export rule corresponding to the current database; Convert the field information corresponding to the current database into data in a preset format, and parse the data in the preset format using a data import tool to obtain a parsing result; Setting the preset field information in the target database as a protected column; wherein the protected column is set to prevent the field value of the preset field information from being overwritten by the field value of the corresponding field information in the current database; If the field of the field information corresponding to the current database is the same as the field of the preset field information corresponding to the protection column, the field information corresponding to the current database is directly added to the target database; wherein the field information includes the field and the corresponding field value; Without overwriting the field value of the preset field information corresponding to the protected column, implementing data migration to the target database according to the parsing result; After determining the field information corresponding to the current database, the method further includes: The field information corresponding to the current database is set to one or more data DATA files for export; After the field information corresponding to the current database is configured as one or more data files for export, the method further includes: Input the connection information between the current database and the target database and the path corresponding to the exported DATA file into the data import tool; Parsing the DATA file through the data import tool to generate a database SQL statement corresponding to the target database; By executing the SQL statement, data migration to the target database is achieved.

8. A non-volatile computer storage medium storing computer-executable instructions, characterized in that: The computer executable instructions are configured to: Determine an export rule corresponding to the current database from preset export rules, so as to determine field information corresponding to the current database on the data export page according to the export rule corresponding to the current database; Convert the field information corresponding to the current database into data in a preset format, and parse the data in the preset format using a data import tool to obtain a parsing result; Setting the preset field information in the target database as a protected column; wherein the protected column is set to prevent the field value of the preset field information from being overwritten by the field value of the corresponding field information in the current database; If the field of the field information corresponding to the current database is the same as the field of the preset field information corresponding to the protection column, the field information corresponding to the current database is directly added to the target database; wherein the field information includes the field and the corresponding field value; Without overwriting the field value of the preset field information corresponding to the protected column, implementing data migration to the target database according to the parsing result; After determining the field information corresponding to the current database, the method further includes: The field information corresponding to the current database is set to one or more data DATA files for export; After the field information corresponding to the current database is configured as one or more data files for export, the method further includes: Input the connection information between the current database and the target database and the path corresponding to the exported DATA file into the data import tool; Parsing the DATA file through the data import tool to generate a database SQL statement corresponding to the target database; By executing the SQL statement, data migration to the target database is achieved.

Images