CN112148713A - Data migration method and device between heterogeneous databases - Google Patents
Data migration method and device between heterogeneous databases Download PDFInfo
- Publication number
- CN112148713A CN112148713A CN202011051973.XA CN202011051973A CN112148713A CN 112148713 A CN112148713 A CN 112148713A CN 202011051973 A CN202011051973 A CN 202011051973A CN 112148713 A CN112148713 A CN 112148713A
- Authority
- CN
- China
- Prior art keywords
- database
- migrated
- target
- name field
- data
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 59
- 230000005012 migration Effects 0.000 title claims abstract description 48
- 238000013508 migration Methods 0.000 title claims abstract description 48
- 238000004519 manufacturing process Methods 0.000 claims abstract description 38
- 238000005192 partition Methods 0.000 claims abstract description 24
- 238000004590 computer program Methods 0.000 claims description 18
- 230000008569 process Effects 0.000 claims description 16
- 238000012544 monitoring process Methods 0.000 claims description 14
- 238000012545 processing Methods 0.000 claims description 14
- 238000010586 diagram Methods 0.000 description 14
- 238000004891 communication Methods 0.000 description 7
- 230000008676 import Effects 0.000 description 7
- 230000006870 function Effects 0.000 description 4
- 238000003672 processing method Methods 0.000 description 3
- 230000007704 transition Effects 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000001514 detection method 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
- 238000006467 substitution reaction Methods 0.000 description 1
Images
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 method and a device for data migration 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 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 into a plurality of texts in batches; 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 invention can realize the automatic migration of data among heterogeneous data and has high efficiency.
Description
Technical Field
The invention relates to the technical field of databases, in particular to a method and a device for data migration between heterogeneous databases.
Background
Heterogeneous database migration is a problem often encountered by existing projects, for example, migration from an oracle database to a gbase relational database requires migration of a stored process originally in the oracle database to the gbase database together with a table structure, table data and the like. 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 of database migration. Data migration requires migrating the data of the oracle database to the database of gbase.
The existing defects of data migration between the existing heterogeneous databases are as follows: due to different architectures, data migration of the heterogeneous database is time-consuming and labor-consuming for general enterprises or individuals, a detailed migration method is not available, and data migration cannot be automatically realized. Secondly, the time for importing and exporting the data is increased when the data volume is large, and the efficiency of data migration is greatly influenced.
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 databases 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 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 into a plurality of texts in batches;
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 provides a data migration device between heterogeneous databases, which is used for realizing automatic migration of data between heterogeneous databases and has high efficiency, and the device comprises:
the system comprises a first module, a second module and a third module, wherein the first module is used for importing a table to be migrated in a production database into an intermediate database based on a first configuration table, and 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 present invention further provides a computer device, which includes a memory, a processor, and a computer program that is stored in the memory and can be run on the processor, and when the processor executes the computer program, the data migration method between the heterogeneous databases is implemented.
The embodiment of the invention also provides a computer readable storage medium, and the computer readable storage medium stores a computer program for executing the data migration method between the heterogeneous databases.
In the embodiment of the invention, a table to be migrated in a production database is imported into a middle 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 middle database is located, a middle 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 into a plurality of texts in batches; 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. In the process, the intermediate database is used for data transition, so that 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 present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts. 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 data migration method between heterogeneous databases according to an embodiment of the present invention;
FIG. 3 is a diagram illustrating an apparatus for data migration 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 diagram of a computer device in an embodiment of the invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. The exemplary embodiments and descriptions of the present invention are provided to explain the present invention, but not to limit the present invention.
In the description of the present specification, the terms "comprising," "including," "having," "containing," and the like are used in an open-ended fashion, i.e., to mean including, but not limited to. Reference to the description of 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 application. In this specification, the schematic representations of the terms used above do not necessarily refer to the same embodiment or example. 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 for illustrative purposes to illustrate the implementation of the present application, and the sequence of steps is not limited and can be adjusted as needed.
Fig. 1 is a flowchart of a data migration method between heterogeneous databases according to an embodiment of the present invention, and as shown in fig. 1, the method includes:
102, when the table to be migrated is a partition table, exporting the table to be migrated in the intermediate database into a plurality of texts in batches;
According to the method provided by the embodiment of the invention, the intermediate database is used for excessive data, so that 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 specific implementation, the first configuration table includes a name field of a table to be migrated, a name field of a server where the middle database is located, a name field of the middle database, and a priority field, specific fields are shown in table 1, and table 1 may be referred to as an IMP _ TAB table.
TABLE 1
| Field identification | Field(s)Name of Chinese |
| table_name | To-be-migrated table name |
| rachostname | Name of server in intermediate database |
| tabowner | Intermediate database name |
| youxianji | Priority level |
The priority field is used for indicating the priority of the table to be migrated, and the table to be migrated in the production database is imported into the intermediate database based on the first configuration table, wherein the priority field is specifically divided into two steps:
the method comprises the following steps: exporting a table to be migrated in a production database;
step two: and importing the exported table to be migrated into the intermediate database.
In step 102, when the table to be migrated is a partition table, exporting the table to be migrated in the intermediate database as a plurality of texts in batch, 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 | Name of Chinese character |
| 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 all the related variations are within the scope of the present invention.
When the table to be migrated in the middle database is exported in batches to be a plurality of texts, the texts may adopt TXT texts, for example, if the target database adopts gbase and the middle database is oracle, the table to be migrated in the middle database may be exported to be TXT texts by using an orato8a tool provided by gbase, and then the TXT texts are loaded to the gbase database by using a load data tool of the gbase database. The table to be migrated in the intermediate database is exported into a plurality of texts in batches, so that the export efficiency can be improved.
In one embodiment, the staging database is of the same type as the production database.
When the types of the intermediate database and the production database are consistent, the table to be migrated in the production database can be led into the intermediate database with higher efficiency.
Moreover, the plurality of texts exported in batches are merged into the target table and then imported based on the second configuration table, so that the import efficiency can be improved.
In an embodiment, the method further comprises:
monitoring the process of importing a table to be migrated in a production database into an intermediate database, and processing data with errors according to a preset method corresponding to a preset error type when the table to be migrated is imported with errors;
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 a preset error type when the errors are imported.
In the embodiment, the status information of import and export can be tracked through monitoring, and an error processing method is provided, so that the accuracy of data migration is improved.
Based on the above embodiment, the present invention provides the following embodiment to explain a 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:
Of course, it is understood that other variations of the above detailed flow can be made, and all such variations are intended to fall within the scope of the present invention.
In summary, in the method provided in the embodiment of the present invention, a table to be migrated in a production database is imported into 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 into a plurality of texts in batches; 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. In the process, the intermediate database is used for data transition, so that 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, a processing method for migration errors is provided, and data migration between heterogeneous databases can be accurately completed.
The embodiment of the invention also provides a device for data migration between heterogeneous databases, which has a similar principle to the method for data migration between heterogeneous databases and is not described herein again.
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 into 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 export the table to be migrated in the intermediate database into multiple texts in batch when the table to be migrated is a partition table;
a third module 303, configured to merge multiple texts exported in batch into a target table based on a second configuration table, and import the target table into a 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 one embodiment, the staging database is of the same type as the 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 the apparatus for migrating data between heterogeneous databases in an embodiment of the present invention, where the monitoring module 304 is configured to:
monitoring the process of importing a table to be migrated in a production database into an intermediate database, and processing data with errors according to a preset method corresponding to a preset error type when the table to be migrated is imported with errors;
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 a preset error type when the errors are imported.
In summary, in the apparatus 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 into a plurality of texts in batches; 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. In the process, the intermediate database is used for data transition, so that 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, a processing method for migration errors is provided, and data migration between heterogeneous databases can be accurately completed.
An embodiment of the present application further provides a computer device, and fig. 5 is a schematic diagram of a computer device in an embodiment of the present invention, where the computer device is capable of implementing all 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;
the processor 501, the memory 502 and the communication interface 503 complete mutual communication through the communication bus 504; the communication interface 503 is used for implementing information transmission between related devices such as server-side devices, detection devices, and user-side devices;
the processor 501 is configured to call the computer program in the memory 502, and when the processor executes the computer program, the processor implements all the steps of the data migration method between heterogeneous databases in the above embodiments.
An embodiment of the present application further provides a computer-readable storage medium, which is capable of implementing all steps of the data migration method between heterogeneous databases in the foregoing embodiment, where the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the computer program implements all steps of the data migration method between heterogeneous databases in the foregoing embodiment.
As will be appreciated by one skilled in the art, 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 flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams 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 above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (10)
1. A method for data migration between heterogeneous databases is characterized by comprising 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 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 into a plurality of texts in batches;
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.
2. The method of data migration between disparate databases of claim 1, wherein the staging database is of a type consistent with the production database.
3. The method for data migration between heterogeneous databases of claim 1, wherein the production database is an oracle database and the target database is a gbase database.
4. The method for data migration between heterogeneous databases of claim 1, further comprising:
monitoring the process of importing a table to be migrated in a production database into an intermediate database, and processing data with errors according to a preset method corresponding to a preset error type when the table to be migrated is imported with errors;
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 a preset error type when the errors are imported.
5. An apparatus for migrating data between heterogeneous databases, comprising:
the system comprises a first module, a second module and a third module, wherein the first module is used for importing a table to be migrated in a production database into an intermediate database based on a first configuration table, and 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.
6. The inter-heterogeneous database data migration apparatus of claim 5, wherein the staging database is of a type consistent with the production database.
7. The device for data migration between heterogeneous databases of claim 5, wherein the production database is an oracle database and the target database is a gbase database.
8. The apparatus for data migration between heterogeneous databases of claim 5, further comprising a monitoring module configured to:
monitoring the process of importing a table to be migrated in a production database into an intermediate database, and processing data with errors according to a preset method corresponding to a preset error type when the table to be migrated is imported with errors;
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 a preset error type when the errors are imported.
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 true CN112148713A (en) | 2020-12-29 |
| CN112148713B 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) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113590594A (en) * | 2021-08-25 | 2021-11-02 | 中国银行股份有限公司 | Bank database migration method and device |
| CN114138714A (en) * | 2022-02-08 | 2022-03-04 | 上海金仕达软件科技有限公司 | Data migration method and device, storage medium and electronic equipment |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150006476A1 (en) * | 2013-06-26 | 2015-01-01 | Sap Ag | Upgrading and migrating a database |
| 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 |
| US20170344433A1 (en) * | 2016-05-27 | 2017-11-30 | Samsung Sds Co., Ltd. | Apparatus and method for data migration |
| 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 |
-
2020
- 2020-09-29 CN CN202011051973.XA patent/CN112148713B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150006476A1 (en) * | 2013-06-26 | 2015-01-01 | Sap Ag | Upgrading and migrating a database |
| CN106708902A (en) * | 2015-11-18 | 2017-05-24 | 青岛海日安电子有限公司 | Database data migration method and system |
| US20170344433A1 (en) * | 2016-05-27 | 2017-11-30 | Samsung Sds Co., Ltd. | Apparatus and method for data migration |
| 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 |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113590594A (en) * | 2021-08-25 | 2021-11-02 | 中国银行股份有限公司 | Bank database migration method and device |
| CN114138714A (en) * | 2022-02-08 | 2022-03-04 | 上海金仕达软件科技有限公司 | Data migration method and device, storage medium and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112148713B (en) | 2024-04-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9454574B2 (en) | Bloom filter costing estimation | |
| CN112148713B (en) | Method and device for data migration between heterogeneous databases | |
| CN111897808B (en) | Data processing method and device, computer equipment and storage medium | |
| CN110290166B (en) | Cross-cluster data interaction method, system and device and readable storage medium | |
| CN112818013B (en) | Time sequence database query optimization method, device, equipment and storage medium | |
| CN114461644A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| AU2019241002B2 (en) | Transaction processing method and system, and server | |
| CN112395307A (en) | Statement execution method, statement execution device, server and storage medium | |
| CN112486532A (en) | Method and device for managing configuration file, electronic equipment and storage medium | |
| CN109597819B (en) | Method and apparatus for updating a database | |
| CN112148705A (en) | Data migration method and device | |
| CN112000671B (en) | Database table processing method, device and system based on block chain | |
| CN111159311B (en) | Method, device, equipment and storage medium for integrating data mapping | |
| CN114153813A (en) | Method, system, equipment and medium for batch migration of large data tables between databases | |
| CN114610701A (en) | Task data processing method and device, electronic equipment and medium | |
| CN114328486A (en) | Data quality checking method and device based on model | |
| CN115905402B (en) | Method and device for processing transaction log | |
| US20180004619A1 (en) | Method and device for data center management | |
| CN107566478B (en) | Data pushing method, system and computer readable storage medium | |
| CN113362007B (en) | Zero inventory record processing method | |
| CN113204478B (en) | Method, device and equipment for operating test unit and storage medium | |
| CN114900531B (en) | Data synchronization method, device and system | |
| CN111611245B (en) | Method and system for processing data table | |
| CN110888929B (en) | Data processing method, data processing device, data node and storage medium | |
| US20220335039A1 (en) | Data file distribution method and equipment, smart device and computer storage medium |
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 |