CN112749151A - Data migration method and device among different types of databases and storage medium - Google Patents
Data migration method and device among different types of databases and storage medium Download PDFInfo
- Publication number
- CN112749151A CN112749151A CN202110040373.1A CN202110040373A CN112749151A CN 112749151 A CN112749151 A CN 112749151A CN 202110040373 A CN202110040373 A CN 202110040373A CN 112749151 A CN112749151 A CN 112749151A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- source
- information
- target database
- 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.)
- Pending
Links
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
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)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method, a device and a storage medium for data migration among different types of databases, which are used for migrating data in a source database to a target database and comprise the following steps: acquiring source table structure information in a source database; acquiring a stored data rule of a target database, and generating a corresponding table construction script based on the stored data rule and the source table structure information; the corresponding table construction script runs in a target database, and data in a source database is migrated to the target database and is converted and stored; and carrying out visualization processing on the process of migrating the data in the source database to the target database. Compared with the method that the table building script is directly exported and executed after being manually modified, the workload is greatly reduced, the error risk caused by a large amount of manual operations is avoided to a certain extent, the difficulty of database migration work is reduced, and the practicability is high.
Description
Technical Field
The present invention relates to data migration technologies, and in particular, to a method and an apparatus for data migration between different types of databases, and a storage medium.
Background
With the development of the times, people can generate a large amount of data in the processes of production, life and scientific research, then the large amount of data is stored in different databases respectively, and different database products are selected for data storage in different scenes due to different advantages of the different database products.
However, in the actual use process, data (such as Oracle to MySQL) needs to be migrated between database products of different manufacturers, at this time, a table structure needs to be created in a new database in advance, however, syntax of a table building script is different between different databases, and creation of a database table cannot be completed through simple import and export.
Disclosure of Invention
The embodiment of the invention provides a data migration method, a data migration device and a storage medium for different databases, which greatly reduce the workload, avoid the error risk caused by a large amount of manual operations to a certain extent and reduce the difficulty of database migration.
In a first aspect of the embodiments of the present invention, a method for migrating data between different types of databases is provided, where data in a source database is migrated to a target database, and the method includes the following steps:
acquiring source table structure information in a source database;
acquiring a stored data rule of a target database, and generating a corresponding table construction script based on the stored data rule and the source table structure information;
the corresponding table construction script runs in a target database, and data in a source database is migrated to the target database and is converted and stored;
and carrying out visualization processing on the process of migrating the data in the source database to the target database.
Optionally, in a possible implementation manner of the first aspect, the source table structure information is a data type;
the step of running the corresponding table construction script in the target database and migrating the data in the source database to the target database for conversion and then storing comprises:
when the data type is judged to be any one or more of datetime or mediatext, a default value is not added;
and judging that the data type is any one or more of number, binary _ float and binary _ double, and the default value is a digital sum or a convertible number, and adding the default value converted into the number.
Optionally, in a possible implementation manner of the first aspect, the visualizing the process of migrating the data in the source database to the target database includes:
the corresponding table construction script is a Shell script, the Shell script triggers a main program, and a file path is configured;
reading configuration file information, wherein the configuration file information comprises any one or more of a source database, a target database and a synchronization table;
and finishing the steps of extracting, converting and executing the source table structure according to the configuration information.
Optionally, in a possible implementation manner of the first aspect, the visualizing the process of migrating the data in the source database to the target database includes:
triggering a table structure synchronization guide based on an Eclipse toolbar and/or a menu;
receiving input source database information and synchronization table information;
completing the operations of extracting, converting and executing the source table structure according to the configuration information to generate a table establishing script;
receiving input target database information;
and the table building script completes the table structure building step in the target database based on the source database information, the synchronous table information and the target database information.
In a second aspect of the embodiments of the present invention, a data migration apparatus suitable for different databases is provided, which migrates data in a source database to a target database, and includes the following modules:
the acquisition module is used for acquiring the source table structure information in the source database;
the generating module is used for acquiring a stored data rule of a target database and generating a corresponding table construction script based on the stored data rule and the source table structure information;
the migration module is used for operating the corresponding table construction script in the target database, migrating the data in the source database to the target database, converting and storing the data;
and the visualization module is used for performing visualization processing on the process of migrating the data in the source database to the target database.
Optionally, in a possible implementation manner of the second aspect, the source table structure information is a data type;
the migration module includes:
the first judging unit is used for judging whether the data type is any one or more of datetime or mediatext or not, and not adding a default value;
and the second judging unit is used for judging whether the data type is any one or more of number, binary _ float and binary _ double, and the default value is a digital sum \ or a convertible number, and at the moment, the default value converted into the number is added.
Optionally, in a possible implementation manner of the second aspect, the visualization module includes:
the corresponding table construction script is a Shell script and is used for triggering a main program and configuring a file path;
the reading unit is used for reading configuration file information, and the configuration file information comprises any one or more of a source database, a target database and a synchronization table;
and the processing unit is used for completing the steps of extracting, converting and executing the source table structure according to the configuration information.
Optionally, in a possible implementation manner of the second aspect, the visualization module includes:
the synchronous guiding unit is used for triggering a table structure synchronous guiding based on an Eclipse toolbar and/or a menu;
the receiving unit is used for receiving input source database information, synchronization table information and target database information;
the script generating unit is used for finishing the operations of extracting, converting and executing the source table structure according to the configuration information to generate a table building script;
and the table structure creating unit is used for completing the table structure creating step in the target database by the table creating script based on the source database information, the synchronous table information and the target database information.
In a third aspect of embodiments of the present invention, a computer-readable storage medium is provided, where computer instructions are stored, and the computer instructions are configured to cause the computer to execute the method for data migration according to any one of the above first aspects.
In a fourth aspect of the embodiments of the present invention, there is provided an electronic device, including: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores a computer program executable by the at least one processor, the computer program being executable by the at least one processor to cause the at least one processor to perform the method of data migration according to any one of the first aspect.
Compared with the prior art that the execution mode is carried out after the table building script is directly exported and modified, the data migration method, the device and the storage medium among different types of databases greatly reduce the workload, avoid the error risk caused by a large amount of manual operations to a certain extent and reduce the difficulty of database migration work.
Compared with the method for migrating the table structure by using a database client (such as Navicat), the method provided by the invention supports the structure migration of the database table of the cross-manufacturer (for example, migration from Oracle to MySQL), increases more use scenes and has strong practicability.
Moreover, the invention supports visual operation in an Eclipse plug-in mode, has low difficulty in hands and convenient operation, and also supports execution in a Linux system through a command line, thereby solving the problem that the structure change authority of some company databases cannot be distributed to individuals and can only be executed in a server, and having stronger functionality and practicability. .
Drawings
FIG. 1 is a diagram illustrating a data migration structure between databases;
FIG. 2 is a flow chart of a first embodiment of a method for data migration between different types of databases;
FIG. 3 is a flow chart of a first embodiment of a data migration apparatus between different types of databases.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The terms "first," "second," "third," "fourth," and the like in the description and in the claims, as well as in the drawings, if any, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein.
It should be understood that, in various embodiments of the present invention, the sequence numbers of the processes do not mean the execution sequence, and the execution sequence of the processes should be determined by the functions and the internal logic of the processes, and should not constitute any limitation on the implementation process of the embodiments of the present invention.
It should be understood that in the present application, "comprising" and "having" and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
It should be understood that, in the present invention, "a plurality" means two or more. "and/or" is merely an association describing an associated object, meaning that three relationships may exist, for example, and/or B, may mean: a exists alone, A and B exist simultaneously, and B exists alone. The character "/" generally indicates that the former and latter associated objects are in an "or" relationship. "comprises A, B and C" and "comprises A, B, C" means that all three of A, B, C comprise, "comprises A, B or C" means that one of A, B, C comprises, "comprises A, B and/or C" means that any 1 or any 2 or 3 of A, B, C comprises.
It should be understood that in the present invention, "B corresponding to a", "a corresponds to B", or "B corresponds to a" means that B is associated with a, and B can be determined from a. Determining B from a does not mean determining B from a alone, but may be determined from a and/or other information. And the matching of A and B means that the similarity of A and B is greater than or equal to a preset threshold value.
As used herein, "if" may be interpreted as "at … …" or "when … …" or "in response to a determination" or "in response to a detection", depending on the context.
The technical solution of the present invention will be described in detail below with specific examples. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments.
In the present invention, the conventional words in the art include:
load Configuration Load table synchronization Configuration information
Source database
Target db Target database
Extract: table structure data extraction
Convert: table structure conversion and script generation
Execution: the table building script is executed.
As shown in fig. 1, which is a schematic diagram of a structure of data migration between databases, a source database and a target database are first confirmed, and data in the source database is migrated into the target database by a data migration tool. In the process of data migration, firstly, table structure data extraction is carried out on source data, then table structure conversion and script generation are carried out, and finally, a table building script is executed to migrate data in a source database to a target database.
The invention provides a data migration method among different types of databases, which migrates data in a source database to a target database, as shown in fig. 2, and comprises the following steps:
step S110, acquiring source information: and acquiring the structure information of the source table in the source database. The source table structure information comprises any one or more of table basic information, field information, a primary key, an index and constraint information.
Step S120, sentence structure conversion: and acquiring a stored data rule of the target database, and generating a corresponding table construction script based on the stored data rule and the source table structure information.
Step S130, writing into the target database: and operating the corresponding table construction script in the target database, and migrating the data in the source database to the target database for conversion and then storing.
In one possible implementation of step S130, the following steps are included:
the source table structure information is a data type.
Step S1301, the running the mapping table building script in the target database, and migrating the data in the source database to the target database for conversion and storing includes:
step S1302, when the data type is judged to be any one or more of datetime or mediatext, no default value is added;
step S1303, it is determined that the data type is any one or more of number, binary _ float, and binary _ double, and the default value is a sum of numbers and/or is convertible to numbers, and at this time, the default value converted to numbers is added.
And step S1303, if the data type is not the case in step S1302 and step S1303, directly adding a default value.
The following example is performed in a conversion mode between a main database Oracle and MySQL of the database, for example, the field type conversion comparison table shown in Table 1 is converted according to a comparison method in a conventional case:
| oracle data type | Oracle data precision | Decimal place | Column name | mysql data type |
| VARchar2(n) | -- | -- | -- | varchar(n) |
| NVARchar2(n) | -- | -- | -- | varchar(n) |
| char(n) | -- | -- | -- | char(n) |
| Nchar(n) | -- | -- | -- | char(n) |
| NUMBER | -- | 0||null | id | bigint |
| NUMBER | (0-3) | 0 | -- | tinyint |
| NUMBER | [3-5) | 0 | -- | smallint |
| NUMBER | [5-10) | 0 | -- | int |
| NUMBER | 10+ | 0 | -- | bigint |
| NUMBER | ！＝null | ！＝null | -- | decimal(p,s) |
| NUMBER | -- | -- | -- | decimal |
| DATE | datatime | |||
| CLOB | -- | -- | -- | mediumtext |
| NCLOB | -- | -- | -- | mediumtext |
| LONG | -- | -- | -- | mediumtext |
| BLOB | -- | -- | -- | blob |
| LONG RAW | -- | -- | -- | blob |
| BINARY_FLOAT | -- | -- | -- | float |
| BINARY_DOUBLE | -- | -- | -- | double |
The method also comprises the following judgment method:
1. if the column name is equal to id and is of integer number type, and the user selects the main key to self-INCREMENT, the AUTO _ INCREANT attribute is increased;
2. if the column is NOT empty, increasing a NOT NULL attribute;
3. if the data type is datatime or mediatext, no default value is added;
4. if the data type is NUMBER, BINARY _ FLOAT, BINARY _ DOUBLE, and the default value is a NUMBER or is convertible to a NUMBER, adding the default value converted to a NUMBER;
5. otherwise, directly adding default values;
6. if the column remark is not empty, adding the column remark;
7. if the primary key is contained, PRIMARY KEY attributes are added, the varchar type primary key has a length of 191 max;
8. if the UNIQUE constraint is contained, the UNIQUE KEY attribute is spliced, and the maximum length of the varchar type constraint is 191;
9. if the INDEX is contained, splicing INDEX, wherein the maximum length of the varchar type constraint is 191;
10. specifying a table ENGINE and character type Engine-InnodB CHARSET-utf 8mb4
Step S140, visually executing: and carrying out visualization processing on the process of migrating the data in the source database to the target database.
In one possible embodiment, step S140 includes the steps of:
s1401, the corresponding table construction script is a Shell script, the Shell script triggers a main program, and a file path is configured;
s1402, reading configuration file information, wherein the configuration file information comprises any one or more of a source database, a target database and a synchronization table;
and S1403, completing the steps of extracting, converting and executing the source table structure according to the configuration information.
In another possible embodiment, step S140 includes the following steps:
s1404, triggering a table structure synchronization guide based on an Eclipse toolbar and/or a menu;
s1405, receiving input source database information and synchronization table information;
s1406, completing the operations of extracting, converting and executing the source table structure according to the configuration information to generate a table building script;
s1407, receiving input target database information;
s1408, the table building script completes the table structure building step in the target database based on the source database information, the synchronous table information and the target database information.
The technical scheme of the invention provides two visual execution modes of different implementation modes, and can be selected according to actual working conditions and actual needs, so that the technical scheme provided by the invention has higher practicability.
Compared with the prior art, the method has the advantages that the execution mode of the modified table building script is directly exported, the workload is greatly reduced, the error risk caused by a large amount of manual operations is avoided to a certain extent, and the difficulty of database migration work is reduced.
Compared with the method for migrating the table structure by using a database client (such as Navicat), the method provided by the invention supports the structure migration of the database table of the cross-manufacturer (for example, migration from Oracle to MySQL), increases more use scenes and has strong practicability.
The invention supports visual operation in an Eclipse plug-in mode, has low difficulty in hands, is convenient to operate, and also supports execution in a Linux system through a command line, solves the problem that the structural change permission of a company database cannot be distributed to individuals and can only be executed in a server, and has stronger functionality and practicability.
The technical scheme of the invention is that the following conditions are required to be achieved:
1. compiling a java program, and inquiring the table structure information of a source database;
2. writing a java program, converting the structural information of the table according to a specified rule, and generating a script;
3. compiling a java program, opening a target database table building authority, and executing a table building script;
4. the command line mode needs to compile shell scripts to call java programs to perform table structure conversion and creation, and database and conversion table information are configured through configuration files;
5. the Eclipse plug-in mode needs to develop Eclipse plug-ins, pop up guide boxes, guide users to input information of databases and conversion tables, and perform table structure conversion, creation or export.
The present invention further provides a data migration apparatus suitable for different databases, as shown in fig. 3, for migrating data in a source database to a target database, including the following modules:
the acquisition module is used for acquiring the source table structure information in the source database;
the generating module is used for acquiring a stored data rule of a target database and generating a corresponding table construction script based on the stored data rule and the source table structure information;
the migration module is used for operating the corresponding table construction script in the target database, migrating the data in the source database to the target database, converting and storing the data;
and the visualization module is used for performing visualization processing on the process of migrating the data in the source database to the target database.
In one embodiment, the source table structure information is a data type;
the migration module includes:
the first judging unit is used for judging whether the data type is any one or more of datetime or mediatext or not, and not adding a default value;
and the second judging unit is used for judging whether the data type is any one or more of number, binary _ float and binary _ double, and the default value is a digital sum \ or a convertible number, and at the moment, the default value converted into the number is added.
In one embodiment, the visualization module comprises:
the corresponding table construction script is a Shell script and is used for triggering a main program and configuring a file path;
the reading unit is used for reading configuration file information, and the configuration file information comprises any one or more of a source database, a target database and a synchronization table;
and the processing unit is used for completing the steps of extracting, converting and executing the source table structure according to the configuration information.
In one embodiment, the visualization module comprises:
the synchronous guiding unit is used for triggering a table structure synchronous guiding based on an Eclipse toolbar and/or a menu;
the receiving unit is used for receiving input source database information, synchronization table information and target database information;
the script generating unit is used for finishing the operations of extracting, converting and executing the source table structure according to the configuration information to generate a table building script;
and the table structure creating unit is used for completing the table structure creating step in the target database by the table creating script based on the source database information, the synchronous table information and the target database information.
The readable storage medium may be a computer storage medium or a communication medium. Communication media includes any medium that facilitates transfer of a computer program from one place to another. Computer storage media may be any available media that can be accessed by a general purpose or special purpose computer. For example, a readable storage medium is coupled to the processor such that the processor can read information from, and write information to, the readable storage medium. Of course, the readable storage medium may also be an integral part of the processor. The processor and the readable storage medium may reside in an Application Specific Integrated Circuits (ASIC). Additionally, the ASIC may reside in user equipment. Of course, the processor and the readable storage medium may also reside as discrete components in a communication device. The readable storage medium may be a read-only memory (ROM), a random-access memory (RAM), a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, and the like.
The present invention also provides a program product comprising execution instructions stored in a readable storage medium. The at least one processor of the device may read the execution instructions from the readable storage medium, and the execution of the execution instructions by the at least one processor causes the device to implement the methods provided by the various embodiments described above.
In the above embodiments of the terminal or the server, it should be understood that the Processor may be a Central Processing Unit (CPU), other general-purpose processors, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), etc. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of a method disclosed in connection with the present invention may be embodied directly in a hardware processor, or in a combination of the hardware and software modules within the processor.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention.
Claims (10)
1. A data migration method between different types of databases migrates data in a source database to a target database, and is characterized by comprising the following steps:
acquiring source table structure information in a source database;
acquiring a stored data rule of a target database, and generating a corresponding table construction script based on the stored data rule and the source table structure information;
the corresponding table construction script runs in a target database, and data in a source database is migrated to the target database and is converted and stored;
and carrying out visualization processing on the process of migrating the data in the source database to the target database.
2. The data migration method according to claim 1,
the source table structure information is a data type;
the step of running the corresponding table construction script in the target database and migrating the data in the source database to the target database for conversion and then storing comprises:
when the data type is judged to be any one or more of datetime or mediatext, a default value is not added;
and judging that the data type is any one or more of number, binary _ float and binary _ double, and the default value is a digital sum or a convertible number, and adding the default value converted into the number.
3. The data migration method according to claim 1,
the process of migrating the data in the source database to the target database is visualized and processed by the following steps:
the corresponding table construction script is a Shell script, the Shell script triggers a main program, and a file path is configured;
reading configuration file information, wherein the configuration file information comprises any one or more of a source database, a target database and a synchronization table;
and finishing the steps of extracting, converting and executing the source table structure according to the configuration information.
4. The data migration method according to claim 1,
the process of migrating the data in the source database to the target database is visualized and processed by the following steps:
triggering a table structure synchronization guide based on an Eclipse toolbar and/or a menu;
receiving input source database information and synchronization table information;
completing the operations of extracting, converting and executing the source table structure according to the configuration information to generate a table establishing script;
receiving input target database information;
and the table building script completes the table structure building step in the target database based on the source database information, the synchronous table information and the target database information.
5. A data migration device suitable for different databases migrates data in a source database to a target database, and is characterized by comprising the following modules:
the acquisition module is used for acquiring the source table structure information in the source database;
the generating module is used for acquiring a stored data rule of a target database and generating a corresponding table construction script based on the stored data rule and the source table structure information;
the migration module is used for operating the corresponding table construction script in the target database, migrating the data in the source database to the target database, converting and storing the data;
and the visualization module is used for performing visualization processing on the process of migrating the data in the source database to the target database.
6. The data migration apparatus according to claim 5,
the source table structure information is a data type;
the migration module includes:
the first judging unit is used for judging whether the data type is any one or more of datetime or mediatext or not, and not adding a default value;
and the second judging unit is used for judging whether the data type is any one or more of number, binary _ float and binary _ double, and the default value is a digital sum \ or a convertible number, and at the moment, the default value converted into the number is added.
7. The data migration apparatus according to claim 5,
the visualization module includes:
the corresponding table construction script is a Shell script and is used for triggering a main program and configuring a file path;
the reading unit is used for reading configuration file information, and the configuration file information comprises any one or more of a source database, a target database and a synchronization table;
and the processing unit is used for completing the steps of extracting, converting and executing the source table structure according to the configuration information.
8. The data migration apparatus according to claim 5,
the visualization module includes:
the synchronous guiding unit is used for triggering a table structure synchronous guiding based on an Eclipse toolbar and/or a menu;
the receiving unit is used for receiving input source database information, synchronization table information and target database information;
the script generating unit is used for finishing the operations of extracting, converting and executing the source table structure according to the configuration information to generate a table building script;
and the table structure creating unit is used for completing the table structure creating step in the target database by the table creating script based on the source database information, the synchronous table information and the target database information.
9. A readable storage medium, in which a computer program is stored which, when being executed by a processor, is adapted to carry out the method of any one of claims 1 to 4.
10. An electronic device, comprising: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores a computer program executable by the at least one processor, the computer program being executable by the at least one processor to cause the at least one processor to perform the method of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110040373.1A CN112749151A (en) | 2021-01-13 | 2021-01-13 | Data migration method and device among different types of databases and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110040373.1A CN112749151A (en) | 2021-01-13 | 2021-01-13 | Data migration method and device among different types of databases and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112749151A true CN112749151A (en) | 2021-05-04 |
Family
ID=75651049
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110040373.1A Pending CN112749151A (en) | 2021-01-13 | 2021-01-13 | Data migration method and device among different types of databases and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112749151A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113297180A (en) * | 2021-06-01 | 2021-08-24 | 平安证券股份有限公司 | Data migration method and device, electronic equipment and storage medium |
| CN113535844A (en) * | 2021-09-15 | 2021-10-22 | 山东耕元数据科技有限公司 | Data aggregation method and system |
| CN115934684A (en) * | 2023-03-14 | 2023-04-07 | 布比（北京）网络技术有限公司 | Multi-source database data migration method, device, equipment and storage medium |
| CN118012845A (en) * | 2024-01-24 | 2024-05-10 | 成都虚谷伟业科技有限公司 | Data migration method, device, equipment and medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103440273A (en) * | 2013-08-06 | 2013-12-11 | 北京航空航天大学 | Data cross-platform migration method and device |
| CN110275914A (en) * | 2019-04-26 | 2019-09-24 | 武汉众邦银行股份有限公司 | Data migration method, device and the storage medium of integration across database |
| CN110704398A (en) * | 2019-09-30 | 2020-01-17 | 深圳前海环融联易信息科技服务有限公司 | Database migration method and device from MySQL to Oracle and computer equipment |
| CN111104393A (en) * | 2019-12-17 | 2020-05-05 | 深圳追一科技有限公司 | Data migration method and device, electronic equipment and storage medium |
| CN111752928A (en) * | 2020-06-30 | 2020-10-09 | 武汉虹信技术服务有限责任公司 | Database object migration method and system |
-
2021
- 2021-01-13 CN CN202110040373.1A patent/CN112749151A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103440273A (en) * | 2013-08-06 | 2013-12-11 | 北京航空航天大学 | Data cross-platform migration method and device |
| CN110275914A (en) * | 2019-04-26 | 2019-09-24 | 武汉众邦银行股份有限公司 | Data migration method, device and the storage medium of integration across database |
| CN110704398A (en) * | 2019-09-30 | 2020-01-17 | 深圳前海环融联易信息科技服务有限公司 | Database migration method and device from MySQL to Oracle and computer equipment |
| CN111104393A (en) * | 2019-12-17 | 2020-05-05 | 深圳追一科技有限公司 | Data migration method and device, electronic equipment and storage medium |
| CN111752928A (en) * | 2020-06-30 | 2020-10-09 | 武汉虹信技术服务有限责任公司 | Database object migration method and system |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113297180A (en) * | 2021-06-01 | 2021-08-24 | 平安证券股份有限公司 | Data migration method and device, electronic equipment and storage medium |
| CN113535844A (en) * | 2021-09-15 | 2021-10-22 | 山东耕元数据科技有限公司 | Data aggregation method and system |
| CN113535844B (en) * | 2021-09-15 | 2021-12-07 | 山东耕元数据科技有限公司 | Data aggregation method and system |
| CN115934684A (en) * | 2023-03-14 | 2023-04-07 | 布比（北京）网络技术有限公司 | Multi-source database data migration method, device, equipment and storage medium |
| CN118012845A (en) * | 2024-01-24 | 2024-05-10 | 成都虚谷伟业科技有限公司 | Data migration method, device, equipment and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112749151A (en) | Data migration method and device among different types of databases and storage medium | |
| CN115061721A (en) | Report generation method and device, computer equipment and storage medium | |
| CN108334609B (en) | Method, device, equipment and storage medium for realizing JSON format data access in Oracle | |
| CN106407111B (en) | Terminal test device, terminal test equipment and variable maintaining method | |
| AU2015331030A1 (en) | System generator module for electronic document and electronic file | |
| CN111291025B (en) | Method for supporting multi-physical model conversion by logic model and storage device | |
| CN113076167A (en) | Code processing method and related equipment | |
| CN111562907A (en) | Conversion method and system of user-defined interface data | |
| CN109325217B (en) | File conversion method, system, device and computer readable storage medium | |
| CN110941957A (en) | Traffic science and technology data indexing method and system | |
| CN114691643A (en) | Data migration method and system applied to domestic substitution | |
| CN113407565A (en) | Cross-database data query method, device and equipment | |
| CN110716913B (en) | Mutual migration method of Kafka and Elasticissearch database data | |
| CN115469849B (en) | Service processing system, method, electronic equipment and storage medium | |
| US20190278568A1 (en) | Recording medium recording generation program, information processing apparatus, and generation method | |
| CN116431481A (en) | Code parameter verification method and device based on multi-code condition | |
| CN111723580B (en) | Power dispatching station information graph validation method based on voice recognition and image recognition | |
| CN109785099B (en) | Method and system for automatically processing service data information | |
| CN110515913B (en) | Log processing method and device | |
| CN113569974B (en) | Programming statement error correction method, device, electronic equipment and storage medium | |
| CN113407164B (en) | Software code generation method and system based on mind map and tree structure technology | |
| CN117896373A (en) | File uploading method, device, equipment and medium | |
| CN114722107A (en) | Data calculation management method and device, electronic equipment and storage medium | |
| CN117931910A (en) | Data storage method, device, equipment and storage medium | |
| CN115421702A (en) | Method for realizing code development of dynamic form |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210504 |
|
| RJ01 | Rejection of invention patent application after publication |