CN112148713B - Method and device for data migration between heterogeneous databases - Google Patents
Method and device for data migration between heterogeneous databases Download PDFInfo
- Publication number
- CN112148713B CN112148713B CN202011051973.XA CN202011051973A CN112148713B CN 112148713 B CN112148713 B CN 112148713B CN 202011051973 A CN202011051973 A CN 202011051973A CN 112148713 B CN112148713 B CN 112148713B
- Authority
- CN
- China
- Prior art keywords
- database
- migrated
- target
- name field
- importing
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 68
- 230000005012 migration Effects 0.000 title claims abstract description 40
- 238000013508 migration Methods 0.000 title claims abstract description 40
- 238000004519 manufacturing process Methods 0.000 claims abstract description 38
- 238000005192 partition Methods 0.000 claims abstract description 26
- 230000008569 process Effects 0.000 claims description 20
- 238000004590 computer program Methods 0.000 claims description 17
- 238000012544 monitoring process Methods 0.000 claims description 14
- 238000012545 processing Methods 0.000 claims description 14
- 238000010586 diagram Methods 0.000 description 12
- 238000004891 communication Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 4
- 230000008676 import Effects 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a data migration method and device between heterogeneous databases, wherein the method comprises the following steps: importing a table to be migrated in a production database into an intermediate database based on a first configuration table, wherein the first configuration table comprises a table name field to be migrated, a server name field in which the intermediate database is located, an intermediate database name field and a priority field; when the table to be migrated is a partition table, exporting the table to be migrated in the intermediate database in batches into a plurality of texts; and merging the texts exported in batches into a target table based on a second configuration table, and importing the target table into a target database, wherein the second configuration table comprises an intermediate database name field, a table name field to be migrated, a target database name field, a target table name field and partition information. The invention can realize the automatic migration of the data among heterogeneous data and has high efficiency.
Description
Technical Field
The present invention relates to the field of database technologies, and in particular, to a method and an apparatus for migrating data between heterogeneous databases.
Background
Heterogeneous database migration is a problem frequently encountered by existing projects, for example, migration from an oracle database to a gbase relational database, and it is necessary to migrate the stored procedures and table structures of the original oracle database, table data and the like to the gbase database together. Because the architecture of the oracle database is different from that of the gbase database, the specific implementation process is somewhat complex and cannot be realized through simple import and export in order to realize the requirement of database migration between different architectures. Wherein data migration is a key step in database migration. Data migration requires migrating the data of the oracle database to the database of gbase.
The existing disadvantages of data migration between existing heterogeneous databases are: (1) because of the different architecture, data migration of heterogeneous databases is time-consuming and labor-consuming for general enterprises or individuals, has no detailed migration method, and cannot be automatically realized. (2) When the data volume is large, the import and export time is also increased, and the efficiency of data migration is greatly affected.
Disclosure of Invention
The embodiment of the invention provides a data migration method between heterogeneous databases, which is used for realizing automatic migration of data between heterogeneous data and has high efficiency, and the method comprises the following steps:
importing a table to be migrated in a production database into an intermediate database based on a first configuration table, wherein the first configuration table comprises a table name field to be migrated, a server name field in which the intermediate database is located, an intermediate database name field and a priority field;
when the table to be migrated is a partition table, exporting the table to be migrated in the intermediate database in batches into a plurality of texts;
and merging the texts exported in batches into a target table based on a second configuration table, and importing the target table into a target database, wherein the second configuration table comprises an intermediate database name field, a table name field to be migrated, a target database name field, a target table name field and partition information.
The embodiment of the invention provides a data migration device between heterogeneous databases, which is used for realizing automatic migration of data between heterogeneous data and has high efficiency, and the device comprises:
the first module is used for importing a table to be migrated in the production database into the intermediate database based on a first configuration table, wherein the first configuration table comprises a table name field to be migrated, a server name field where the intermediate database is located, an intermediate database name field and a priority field;
the second module is used for exporting the tables to be migrated in the intermediate database into a plurality of texts in batches when the tables to be migrated are partition tables;
and the third module is used for merging a plurality of texts exported in batches into a target table based on a second configuration table, and importing the target table into a target database, wherein the second configuration table comprises a middle database name field, a table name field to be migrated, a target database name field, a target table name field and partition information.
The embodiment of the invention also provides computer equipment, which comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor realizes the data migration method between the heterogeneous databases when executing the computer program.
The embodiment of the invention also provides a computer readable storage medium, which stores a computer program for executing the data migration method between heterogeneous databases.
In the embodiment of the invention, a table to be migrated in a production database is imported to an intermediate database based on a first configuration table, wherein the first configuration table comprises a table name field to be migrated, a server name field in which the intermediate database is located, an intermediate database name field and a priority field; when the table to be migrated is a partition table, exporting the table to be migrated in the intermediate database in batches into a plurality of texts; and merging the texts exported in batches into a target table based on a second configuration table, and importing the target table into a target database, wherein the second configuration table comprises an intermediate database name field, a table name field to be migrated, a target database name field, a target table name field and partition information. In the process, the intermediate database is utilized to excessively data, so that the direct operation on the production database can be reduced, the data risk of the production database is further reduced, and a large amount of data can be efficiently migrated to the target database in a batch mode.
Drawings
In order to more clearly illustrate the embodiments of the invention or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art. In the drawings:
FIG. 1 is a flow chart of a method for migrating data between heterogeneous databases according to an embodiment of the present invention;
FIG. 2 is a detailed flowchart of a method for migrating data between heterogeneous databases according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of a data migration apparatus between heterogeneous databases according to an embodiment of the present invention;
FIG. 4 is another schematic diagram of a data migration apparatus between heterogeneous databases according to an embodiment of the present invention;
fig. 5 is a schematic diagram of a computer device according to an embodiment of the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention will be described in further detail with reference to the accompanying drawings. The exemplary embodiments of the present invention and their descriptions herein are for the purpose of explaining the present invention, but are not to be construed as limiting the invention.
In the description of the present specification, the terms "comprising," "including," "having," "containing," and the like are open-ended terms, meaning including, but not limited to. Reference to the terms "one embodiment," "a particular embodiment," "some embodiments," "for example," etc., means that a particular feature, structure, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the present application. In this specification, schematic representations of the above terms do not necessarily refer to the same embodiments or examples. Furthermore, the particular features, structures, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. The sequence of steps involved in the embodiments is used to schematically illustrate the practice of the present application, and is not limited thereto and may be appropriately adjusted as desired.
FIG. 1 is a flowchart of a method for migrating data between heterogeneous databases according to an embodiment of the present invention, as shown in FIG. 1, the method includes:
step 101, importing a table to be migrated in a production database into an intermediate database based on a first configuration table, wherein the first configuration table comprises a table name field to be migrated, a server name field where the intermediate database is located, an intermediate database name field and a priority field;
step 102, when the table to be migrated is a partition table, exporting the table to be migrated in the intermediate database in batches into a plurality of texts;
and 103, merging a plurality of texts exported in batches into a target table based on a second configuration table, and importing the target table into a target database, wherein the second configuration table comprises an intermediate database name field, a table name field to be migrated, a target database name field, a target table name field and partition information.
In the method provided by the embodiment of the invention, the intermediate database is utilized to excessively data, so that the direct operation on the production database can be reduced, the data risk of the production database is further reduced, and a large amount of data can be efficiently migrated to the target database in a batch mode.
In a specific implementation, the first configuration table includes a table name field to be migrated, a server name field where the intermediate database is located, an intermediate database name field, and a priority field, where specific fields are shown in table 1, and table 1 may be referred to as an imp_tab table.
TABLE 1
| Field identification | Field Chinese name |
| table_name | To-be-migrated table name |
| rachostname | Server name of intermediate database |
| tabowner | Intermediate database name |
| youxianji | Priority level |
The priority field is used for indicating the priority according to which the table to be migrated is migrated, and the table to be migrated in the production database is imported into the intermediate database based on the first configuration table, and the method specifically comprises the following two steps:
step one: exporting a table to be migrated in a production database;
step two: and importing the exported table to be migrated into an intermediate database.
In step 102, when the table to be migrated is a partition table, the table to be migrated in the intermediate database is exported in batches into a plurality of texts, where whether the table to be migrated is a partition table may be represented by grouping information in a second configuration table, which may be referred to as a sys_cmdtext table, see table 2.
TABLE 2
| Field identification | Field Chinese name |
| tabowner | Intermediate database name |
| tabname | To-be-migrated table name |
| gblibname | Target database name |
| gbtabname | Target table name |
| partandsubpart | Partition information |
In an embodiment, the production database is an oracle database and the target database is a gbase database. Of course, it is understood that the production database and the target database may be other databases, and the related variations should fall within the scope of the present invention.
When the to-be-migrated tables in the intermediate database are exported in batches into a plurality of texts, the texts can be TXT texts, for example, if the target database adopts gbase and the intermediate database is oracle, the to-be-migrated tables in the intermediate database can be exported into TXT texts by utilizing an operator 8a tool provided by the gbase, and then the TXT texts are loaded into the gbase database by utilizing a load data tool of the gbase database. And exporting the tables to be migrated in the intermediate database into a plurality of texts in batches, so that the exporting efficiency can be improved.
In an embodiment, the intermediate database is consistent with the type of production database.
When the type of the intermediate database is consistent with that of the production database, the method can ensure that the to-be-migrated tables in the production database are imported into the intermediate database with higher efficiency.
In addition, based on the second configuration table, a plurality of texts exported in batches are merged into a target table and then imported, so that the importing efficiency can be improved.
In an embodiment, the method further comprises:
monitoring a process of importing a table to be migrated in a production database into an intermediate database, and processing error data according to a preset method corresponding to a preset error type when errors occur in importing;
and monitoring the process of importing the target table into the target database, and processing the data with errors according to a preset method corresponding to the preset error type when the errors occur in the importing process.
In the above embodiment, the accuracy of data migration is improved by monitoring the state information that can be tracked and imported and exported, and providing an error processing method.
Based on the foregoing embodiments, the present invention proposes the following embodiment to illustrate the detailed flow of the data migration method between heterogeneous databases, and fig. 2 is a detailed flow chart of the data migration method between heterogeneous databases according to the embodiment of the present invention, as shown in fig. 2, including:
step 201, importing a table to be migrated in a production database to an intermediate database based on a first configuration table;
step 202, monitoring a process of importing a table to be migrated in a production database into an intermediate database, and processing error data according to a preset method corresponding to a preset error type when errors occur in importing;
step 203, when the table to be migrated is a partition table, exporting the table to be migrated in the intermediate database in batches into a plurality of texts;
step 204, merging the texts exported in batch into a target table based on the second configuration table, and importing the target table into a target database;
step 205, monitoring the process of importing the target table into the target database, and processing the data with errors according to a preset method corresponding to the preset error type when the errors occur in the importing process.
Of course, it is to be understood that other variations of the above detailed procedures are also possible, and all related variations should fall within the protection scope of the present invention.
In summary, in the method provided by the embodiment of the present invention, a table to be migrated in a production database is imported to an intermediate database based on a first configuration table, where the first configuration table includes a table name field to be migrated, a server name field where the intermediate database is located, an intermediate database name field, and a priority field; when the table to be migrated is a partition table, exporting the table to be migrated in the intermediate database in batches into a plurality of texts; and merging the texts exported in batches into a target table based on a second configuration table, and importing the target table into a target database, wherein the second configuration table comprises an intermediate database name field, a table name field to be migrated, a target database name field, a target table name field and partition information. In the process, the intermediate database is utilized to excessively data, so that the direct operation on the production database can be reduced, the data risk of the production database is further reduced, and a large amount of data can be efficiently migrated to the target database in a batch mode. In addition, the data migration method for the heterogeneous databases can accurately complete data migration among the heterogeneous databases.
The embodiment of the invention also provides a data migration device between heterogeneous databases, the principle of which is similar to that of the data migration method between heterogeneous databases, and the description is omitted here.
FIG. 3 is a schematic diagram of a data migration apparatus between heterogeneous databases according to an embodiment of the present invention, as shown in FIG. 3, including:
a first module 301, configured to import a table to be migrated in a production database to an intermediate database based on a first configuration table, where the first configuration table includes a table name field to be migrated, a server name field where the intermediate database is located, an intermediate database name field, and a priority field;
a second module 302, configured to, when the table to be migrated is a partition table, export the table to be migrated in the intermediate database in batch into a plurality of texts;
and a third module 303, configured to merge the plurality of texts derived in batch into a target table based on a second configuration table, and import the target table into the target database, where the second configuration table includes a middle database name field, a table name field to be migrated, a target database name field, a target table name field, and partition information.
In an embodiment, the intermediate database is consistent with the type of production database.
In an embodiment, the production database is an oracle database and the target database is a gbase database.
In an embodiment, the apparatus further includes a monitoring module 304, as shown in fig. 4, which is another schematic diagram of an apparatus for migrating data between heterogeneous databases in an embodiment of the present invention, where the monitoring module 304 is configured to:
monitoring a process of importing a table to be migrated in a production database into an intermediate database, and processing error data according to a preset method corresponding to a preset error type when errors occur in importing;
and monitoring the process of importing the target table into the target database, and processing the data with errors according to a preset method corresponding to the preset error type when the errors occur in the importing process.
In summary, in the device provided in the embodiment of the present invention, a table to be migrated in a production database is imported to an intermediate database based on a first configuration table, where the first configuration table includes a table name field to be migrated, a server name field where the intermediate database is located, an intermediate database name field, and a priority field; when the table to be migrated is a partition table, exporting the table to be migrated in the intermediate database in batches into a plurality of texts; and merging the texts exported in batches into a target table based on a second configuration table, and importing the target table into a target database, wherein the second configuration table comprises an intermediate database name field, a table name field to be migrated, a target database name field, a target table name field and partition information. In the process, the intermediate database is utilized to excessively data, so that the direct operation on the production database can be reduced, the data risk of the production database is further reduced, and a large amount of data can be efficiently migrated to the target database in a batch mode. In addition, the data migration method for the heterogeneous databases can accurately complete data migration among the heterogeneous databases.
The embodiment of the present application further provides a computer device, and fig. 5 is a schematic diagram of a computer device in the embodiment of the present invention, where the computer device can implement all the steps in the data migration method between heterogeneous databases in the foregoing embodiment, and the computer device specifically includes the following contents:
a processor (processor) 501, a memory (memory) 502, a communication interface (Communications Interface) 503, and a communication bus 504;
wherein the processor 501, the memory 502, and the communication interface 503 perform communication with each other through the communication bus 504; the communication interface 503 is configured to implement information transmission between related devices such as a server device, a detection device, and a user device;
the processor 501 is configured to invoke a computer program in the memory 502, where the processor executes the computer program to implement all the steps in the data migration method between heterogeneous databases in the above embodiment.
The embodiment of the present application further provides a computer readable storage medium, which can implement all the steps in the data migration method between heterogeneous databases in the above embodiment, and the computer readable storage medium stores a computer program, where the computer program is executed by a processor, to implement all the steps in the data migration method between heterogeneous databases in the above embodiment.
It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The foregoing description of the embodiments has been provided for the purpose of illustrating the general principles of the invention, and is not meant to limit the scope of the invention, but to limit the invention to the particular embodiments, and any modifications, equivalents, improvements, etc. that fall within the spirit and principles of the invention are intended to be included within the scope of the invention.
Claims (10)
1. A method for migrating data between heterogeneous databases, comprising:
importing a table to be migrated in a production database into an intermediate database based on a first configuration table, wherein the first configuration table comprises a table name field to be migrated, a server name field in which the intermediate database is located, an intermediate database name field and a priority field;
when the table to be migrated is a partition table, exporting the table to be migrated in the intermediate database in batches into a plurality of texts;
merging a plurality of texts exported in batches into a target table based on a second configuration table, and importing the target table into a target database, wherein the second configuration table comprises an intermediate database name field, a table name field to be migrated, a target database name field, a target table name field and partition information;
whether the table to be migrated is a partition table or not is indicated by grouping information in the second configuration table.
2. The method for migrating data between disparate databases of claim 1, wherein the intermediate database is of a type consistent with the production database.
3. The method for migrating data between heterogeneous databases according to claim 1, wherein the production database is an oracle database and the target database is a gbase database.
4. The method for migrating data between heterogeneous databases of claim 1, further comprising:
monitoring a process of importing a table to be migrated in a production database into an intermediate database, and processing error data according to a preset method corresponding to a preset error type when errors occur in importing;
and monitoring the process of importing the target table into the target database, and processing the data with errors according to a preset method corresponding to the preset error type when the errors occur in the importing process.
5. A data migration apparatus between heterogeneous databases, comprising:
the first module is used for importing a table to be migrated in the production database into the intermediate database based on a first configuration table, wherein the first configuration table comprises a table name field to be migrated, a server name field where the intermediate database is located, an intermediate database name field and a priority field;
the second module is used for exporting the tables to be migrated in the intermediate database into a plurality of texts in batches when the tables to be migrated are partition tables;
the third module is used for merging a plurality of texts exported in batches into a target table based on a second configuration table, and importing the target table into a target database, wherein the second configuration table comprises a middle database name field, a table name field to be migrated, a target database name field, a target table name field and partition information;
whether the table to be migrated is a partition table or not is indicated by grouping information in the second configuration table.
6. The data migration apparatus between heterogeneous databases of claim 5 wherein said intermediate database is of a type consistent with said production database.
7. The data migration apparatus between heterogeneous databases according to claim 5, wherein said production database is an oracle database and said target database is a gbase database.
8. The data migration apparatus between heterogeneous databases of claim 5, further comprising a monitoring module for:
monitoring a process of importing a table to be migrated in a production database into an intermediate database, and processing error data according to a preset method corresponding to a preset error type when errors occur in importing;
and monitoring the process of importing the target table into the target database, and processing the data with errors according to a preset method corresponding to the preset error type when the errors occur in the importing process.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method of any of claims 1 to 4 when executing the computer program.
10. A computer readable storage medium, characterized in that the computer readable storage medium stores a computer program for executing the method of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011051973.XA CN112148713B (en) | 2020-09-29 | 2020-09-29 | Method and device for data migration between heterogeneous databases |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011051973.XA CN112148713B (en) | 2020-09-29 | 2020-09-29 | Method and device for data migration between heterogeneous databases |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112148713A CN112148713A (en) | 2020-12-29 |
| CN112148713B true CN112148713B (en) | 2024-04-16 |
Family
ID=73895932
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011051973.XA Active CN112148713B (en) | 2020-09-29 | 2020-09-29 | Method and device for data migration between heterogeneous databases |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112148713B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113590594A (en) * | 2021-08-25 | 2021-11-02 | 中国银行股份有限公司 | Bank database migration method and device |
| CN114138714B (en) * | 2022-02-08 | 2022-05-24 | 上海金仕达软件科技有限公司 | Data migration method and device, storage medium and electronic equipment |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106570086A (en) * | 2016-10-19 | 2017-04-19 | 上海携程商务有限公司 | Data migration system and method |
| CN106708902A (en) * | 2015-11-18 | 2017-05-24 | 青岛海日安电子有限公司 | Database data migration method and system |
| CN108241632A (en) * | 2016-12-23 | 2018-07-03 | 航天星图科技（北京）有限公司 | A kind of data verification method of data base-oriented Data Migration |
| CN109284293A (en) * | 2018-10-08 | 2019-01-29 | 湖南工学院 | Data migration method for water utilities company operating charges system upgrade |
| CN110297813A (en) * | 2019-05-22 | 2019-10-01 | 平安银行股份有限公司 | Data migration method, device, computer equipment and storage medium |
| CN110659259A (en) * | 2019-09-03 | 2020-01-07 | 平安科技（深圳）有限公司 | Database migration method, server and computer storage medium |
| CN110737717A (en) * | 2018-07-03 | 2020-01-31 | 北京国双科技有限公司 | database migration method and device |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9519663B2 (en) * | 2013-06-26 | 2016-12-13 | Sap Se | Upgrading and migrating a database by a migration tool |
| KR20170133866A (en) * | 2016-05-27 | 2017-12-06 | 삼성에스디에스 주식회사 | Apparatus and method for data migration |
-
2020
- 2020-09-29 CN CN202011051973.XA patent/CN112148713B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106708902A (en) * | 2015-11-18 | 2017-05-24 | 青岛海日安电子有限公司 | Database data migration method and system |
| CN106570086A (en) * | 2016-10-19 | 2017-04-19 | 上海携程商务有限公司 | Data migration system and method |
| CN108241632A (en) * | 2016-12-23 | 2018-07-03 | 航天星图科技（北京）有限公司 | A kind of data verification method of data base-oriented Data Migration |
| CN110737717A (en) * | 2018-07-03 | 2020-01-31 | 北京国双科技有限公司 | database migration method and device |
| CN109284293A (en) * | 2018-10-08 | 2019-01-29 | 湖南工学院 | Data migration method for water utilities company operating charges system upgrade |
| CN110297813A (en) * | 2019-05-22 | 2019-10-01 | 平安银行股份有限公司 | Data migration method, device, computer equipment and storage medium |
| CN110659259A (en) * | 2019-09-03 | 2020-01-07 | 平安科技（深圳）有限公司 | Database migration method, server and computer storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112148713A (en) | 2020-12-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110908997B (en) | Data blood relationship construction method and device, server and readable storage medium | |
| CN112148713B (en) | Method and device for data migration between heterogeneous databases | |
| CN111767320B (en) | Data blood relationship determination method and device | |
| CN110290166B (en) | Cross-cluster data interaction method, system and device and readable storage medium | |
| AU2017279795A1 (en) | Metadata-driven program code generation for clinical data analysis | |
| CN111324781A (en) | Data analysis method, device and equipment | |
| US11544260B2 (en) | Transaction processing method and system, and server | |
| CN107977504A (en) | A kind of asymmetric in-core fuel management computational methods, device and terminal device | |
| CN107657050A (en) | One kind is based on " with the one-to-one join of conflation algorithm calculating, one-to-many join " contraposition segmentation parallel method | |
| CN109597819B (en) | Method and apparatus for updating a database | |
| CN109933771B (en) | Report automatic merging method, device, equipment and storage medium | |
| CN112000671B (en) | Database table processing method, device and system based on block chain | |
| CN115809228A (en) | Data comparison method and device, storage medium and electronic equipment | |
| CN111159213A (en) | Data query method, device, system and storage medium | |
| CN114020640A (en) | Automatic testing method and device | |
| CN114610701A (en) | Task data processing method and device, electronic equipment and medium | |
| CN111158994A (en) | Pressure testing performance testing method and device | |
| CN114900531B (en) | Data synchronization method, device and system | |
| US20220335039A1 (en) | Data file distribution method and equipment, smart device and computer storage medium | |
| CN107566478B (en) | Data pushing method, system and computer readable storage medium | |
| CN115250231B (en) | Application configuration method and device | |
| CN113722292B (en) | Disaster response processing method, device, equipment and storage medium of distributed data system | |
| US11347722B2 (en) | Big data regression verification method and big data regression verification apparatus | |
| CN116501593A (en) | Method and device for processing call record of service and micro-service architecture | |
| CN117009342A (en) | Data processing method, apparatus, device, medium and computer program product |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |