CN106446166A - Method and device for migrating data from DB2 database to K-DB database - Google Patents
Method and device for migrating data from DB2 database to K-DB database Download PDFInfo
- Publication number
- CN106446166A CN106446166A CN201610849225.3A CN201610849225A CN106446166A CN 106446166 A CN106446166 A CN 106446166A CN 201610849225 A CN201610849225 A CN 201610849225A CN 106446166 A CN106446166 A CN 106446166A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- source
- migrating
- link information
- 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
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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
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)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for migrating data from a DB2 database to a K-DB database. The method comprises the following steps: receiving source connection information and destination connection information; according to the connection of the source connection information to the source DB2 database, extracting the migration data from the source DB2 database; modifying the migration data into first migration data to support a K-DB syntax structure; according to the connection of the destination connection information to the source DB2 database, creating a table and index in the destination K-DB database and loading the first migration data. According to the method, the work of a DBA achieves automation, the operation is simple, the error rate of a database administrator is reduced, and data migration is thus more simple, more efficient and safer. The invention further discloses a device for migrating the data from the DB2 database to the K-DB database, and the device has above-mentioned advantages.
Description
Technical field
The present invention relates to database technical field, move to K-DB data base particularly to a kind of data from DB2 database
Method and apparatus.
Background technology
DB2 database is a set of relevant database of IBM Corporation's exploitation, is in the market using a lot of one kind passes
It is type data base;K-DB data base is the Enterprise Data base management system that LANGCHAO is released;DB2 and K-DB data base is different
Structure data base, currently, Data Migration between the two, generally by DBA (Data base Administrator, data base administration
Member) realize migrating DB2 database to K-DB data base using completely artificial manual mode.
With the development of application, in data base, the data volume of storage is also increasing, and structure also becomes more complicated, is counting
According to during migration, DBA needs to do substantial amounts of manual operations to complete Data Migration within the of short duration business outage window time.This
Mode complex operation, risk is high, and efficiency is low, and labor intensive and other resources are more, is not suitable for using in actual production.
Content of the invention
It is an object of the invention to provide a kind of data moves to the method and device of K-DB data base from DB2 database, will
The work of DBA is converted to automatic method, simple to operate, and the error of minimizing data base administrator operation and error rate are so that count
Simpler according to migrating, more efficiently, safer.
For solving above-mentioned technical problem, the present invention provides a kind of data to move to the side of K-DB data base from DB2 database
Method, including:
The source link information of reception source DB2 database and the purpose link information of purpose K-DB data base;
Described source DB2 database is connected to according to described source link information, extracts the transport number in the DB2 database of described source
According to;Wherein, described migrating data includes DDL, object and/or data;
Described migrating data is revised as supporting the first migrating data of K-DB grammatical structure;
Described purpose K-DB data base is connected to according to described purpose link information, creates in described purpose K-DB data base
Build table and index, and load described first migrating data.
Optionally, after receiving the source link information of source DB2 database and the purpose link information of purpose K-DB data base,
Also include:
Test described source link information and whether described purpose link information is correct;
If incorrect, point out user to confirm and change corresponding link information, and return error code.
Optionally, after extracting the migrating data in the DB2 database of described source, also include:
Whether the migrating data that detection is extracted is complete;
If imperfect, preserve detection daily record, and return error message.
Optionally, extract the migrating data in the DB2 database of described source, including:
Extract the migrating data that the user in the DB2 database of described source specifies, and the migrating data of extraction is stored finger
Determine catalogue.
Optionally, also include:
Monitor the extraction progress of described migrating data, and be presented to user in the form of progress bar;And/or,
Monitor the loading progress of described first migrating data, and be presented to user in the form of progress bar.
Optionally, after loading described first migrating data, also include:
Judge whether successfully to load according to load result, and record loading daily record;
If unsuccessful loading, return the daily record of described loading and miscue information.
Optionally, if after loading success, also including:
Consistency checking is carried out to the data of described source DB2 database and described purpose K-DB data base;
When failing the authentication, confirm Data Migration failure, and output error message.
The present invention also provides a kind of data to move to the device of K-DB data base from DB2 database, including:
Information receiving module, the purpose of source link information and purpose K-DB data base for receiving source DB2 database connects
Connect information;
Data extraction module, for being connected to described source DB2 database according to described source link information, extracts described source
Migrating data in DB2 database;Wherein, described migrating data includes DDL, object and/or data;
Data correction module, for being revised as supporting the first migrating data of K-DB grammatical structure by described migrating data;
Data loading module, for being connected to described purpose K-DB data base according to described purpose link information, described
Create table and index in purpose K-DB data base, and load described first migrating data.
Optionally, this device also includes:
Load result judge module, for judging whether successfully to load according to load result, and records loading daily record;If not
Success loads, then return the daily record of described loading and miscue information.
Optionally, this device also includes:
Authentication module, tests for carrying out concordance to the data of described source DB2 database and described purpose K-DB data base
Card;When failing the authentication, confirm Data Migration failure, and output error message.
The method that data provided by the present invention moves to K-DB data base from DB2 database, including:Reception source DB2 number
According to the source link information in storehouse and the purpose link information of purpose K-DB data base;Described source is connected to according to described source link information
DB2 database, extracts the migrating data in the DB2 database of described source;Wherein, described migrating data includes DDL, object and/or
Data;Described migrating data is revised as supporting the first migrating data of K-DB grammatical structure;According to described purpose link information
It is connected to described purpose K-DB data base, create table and index in described purpose K-DB data base, and load described first and move
Move data;
It can be seen that, the method user operation is simple, automatically executes transition process, decreases human operational error and lead and malfunction
Data is moved to K-DB data base from DB2 database by rate automatically, Data Migration more precise and high efficiency, reduces data money
The danger that source is lost, has higher safety;The present invention also provides a kind of data to move to K-DB data base from DB2 database
Device, there is above-mentioned beneficial effect, will not be described here.
Brief description
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
Have technology description in required use accompanying drawing be briefly described it should be apparent that, drawings in the following description be only this
Inventive embodiment, for those of ordinary skill in the art, on the premise of not paying creative work, can also basis
The accompanying drawing providing obtains other accompanying drawings.
The data that Fig. 1 is provided by the embodiment of the present invention moves to the flow process of the method for K-DB data base from DB2 database
Figure;
The whether correct schematic flow sheet of test link information that Fig. 2 is provided by the embodiment of the present invention;
The schematic flow sheet judging whether correctly to load that Fig. 3 is provided by the embodiment of the present invention;
The data that Fig. 4 is provided by the embodiment of the present invention carries out the schematic flow sheet of consistency checking;
The data that Fig. 5 is provided by the embodiment of the present invention moves to the structure of the device of K-DB data base from DB2 database
Block diagram.
Specific embodiment
The core of the present invention is the method and device providing a kind of data to move to K-DB data base from DB2 database, will
The work of DBA is converted to automatic method, simple to operate, and the error of minimizing data base administrator operation and error rate are so that count
Simpler according to migrating, more efficiently, safer.
Purpose, technical scheme and advantage for making the embodiment of the present invention are clearer, below in conjunction with the embodiment of the present invention
In accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described it is clear that described embodiment is
The a part of embodiment of the present invention, rather than whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art
The every other embodiment being obtained under the premise of not making creative work, broadly falls into the scope of protection of the invention.
Refer to Fig. 1, the data that Fig. 1 is provided by the embodiment of the present invention moves to K-DB data base's from DB2 database
The flow chart of method;The method can include:
The purpose link information of S100, the source link information of reception source DB2 database and purpose K-DB data base;
Specifically, the source link information in this step and purpose link information are by user input;For example receive and use
The purpose of the source link information of the source DB2 database that family is given by human-computer interaction interface and purpose K-DB data base connects letter
Breath;
Here source link information and purpose link information specifically can include:The IP address of source DB2 database, port,
Database name, user name, password, character set etc.;The IP address of purpose K-DB data, port, database name, user name, password,
Character set etc..
If it is also noted that also not building storehouse in purpose K-DB data during Data Migration, need first to create purpose K-DB number
According to storehouse.
In order to further ensure that accuracy and the reliability of migration, here can be to source DB2 database and purpose K-DB number
Correctness according to the link information in storehouse is verified, prevents from leading to subsequently due to the mistake of source link information or purpose link information
The failure of data migration process, wastes user time.After these information of user input, need these information to be verified, such as
Fruit connecting test is unsuccessful, then return error message.Receive source link information and the purpose K-DB data base of source DB2 database
Purpose link information after, also include:
Test described source link information and whether described purpose link information is correct;
If correct, execute follow-up data migration step;
If incorrect, point out user to confirm and change corresponding link information, and return error code.
Here the error code returning is can to include possible error reason and solution in error message, transfers to use
Link information is re-entered for example to facilitate the modification to two link informations for the DBA in family, saves modification time.Detailed process is permissible
With reference to Fig. 2.
S110, it is connected to described source DB2 database according to described source link information, extract in the DB2 database of described source
Migrating data;Wherein, described migrating data includes DDL, object and/or data;
Specifically, this step purpose is to extract migrating data, and migrating data here can be DDL, object and/or
Data combination in any, participates in convenience and the availability of transition process to increase user, and the present embodiment is extracting described source DB2
During the migrating data of data base, but user oneself selects in this migration operation, needs which DDL is the migrating data extracting be,
Object or data, improve ease for use and the interactivity of the present embodiment;Extract the migrating data that user oneself specifies.
Further for the accuracy guaranteeing migrating data and reliability, need to ensure the complete of the migrating data of extraction
Property, that is, after extracting the migrating data in the DB2 database of described source, also include:
Whether the migrating data that detection is extracted is complete;
If complete, execute follow-up data migration operation;
If imperfect, preserve detection daily record, and return error message.
S120, by described migrating data be revised as support K-DB grammatical structure the first migrating data;
Specifically, because source DB2 database and purpose K-DB data base belong to heterogeneous database, in grammer, data type
Etc. aspect have larger difference, when extracting migrating data, need according to the corresponding table of grammer of DB2 with K-DB, data structure
Corresponding table is revised as the migrating data of K-DB support to the migrating data extracting, and exports detailed modification daily record.
Specifically, if migrating data is complete or migrating data extract after the completion of or migrating data modification after obtain the
The migrating data of extraction can also be stored assigned catalogue after one migrating data, so that follow-up use.
S130, described purpose K-DB data base is connected to according to described purpose link information, in described purpose K-DB data
Create table and index in storehouse, and load described first migrating data.
Specifically, during this, need to record detailed daily record, so that follow-up DBA searches to the reason loading unsuccessfully.
After loading described first migrating data further, also include:
Judge whether successfully to load according to load result, and record loading daily record;
If unsuccessful loading, return the daily record of described loading and miscue information.
Specifically, the daily record recording here includes loading process and load result judge process;Refer to Fig. 3, due to
In fact it could happen that loading the situation of failure during loading, therefore in loading process, need load result is sentenced
Disconnected, if loading unsuccessfully, return failure information, transfer to DBA to remodify DDL object and/or data again according to loading daily record
Load and remodify the first migrating data.Loading completes, and after confirming success, needs in source DB2 storehouse and purpose K-DB storehouse
Data carry out coupling checking, if authentication failed, Data Migration failure.
Further, if after loading success, also including:
Consistency checking is carried out to the data of described source DB2 database and described purpose K-DB data base;
When failing the authentication, confirm Data Migration failure, and output error message.
Specifically, refer to Fig. 4, in having DB2 to K-DB Data Migration, finally need the result of migration is tested
Card, verifies migration results by mating the data in DB2 and K-DB storehouse.If verifying unsuccessfully, can confirm that and migrate unsuccessfully, output
Error message.
Based on technique scheme, data provided in an embodiment of the present invention moves to K-DB data base's from DB2 database
Method, the migration of DB2 to K-DB data is changed to Autonomic Migration Framework by manual migration by the method, more efficiently;Offer source is be provided
DB2 database and the link information of purpose K-DB data base, remaining work will be automatically performed, and use manpower and material resources sparingly, and improve data
The work efficiency of migration;Utilize machine batch operation, reliability is higher, has more preferable Information Security.
Based on above-mentioned any embodiment, in order to make user understand the progress of Data Migration further, the method can also be by
The loading progress of the extraction progress of migrating data and/or the first migrating data be shown to user (for example using cake chart, numeral,
Progress bar etc.), make user understand migrating processes at any time, be easy to user and make rational planning for the time of oneself, that is, preferably:
Monitor the extraction progress of described migrating data, and be presented to user in the form of progress bar;And/or,
Monitor the loading progress of described first migrating data, and be presented to user in the form of progress bar.
Specifically, this supervision process is carried out in real time, and in control station window, this extraction progress can be carried out with progress bar
Display.The form of progress bar is more vivid compared to numeral grade.
Based on technique scheme, data provided in an embodiment of the present invention moves to K-DB data base's from DB2 database
Method, the method is simple to operate, decreases human operational error and leads and error rate, automatically moves to data from DB2 database
In K-DB data base, Data Migration more precise and high efficiency, reduce the danger of data resource loss, there is higher safety.
The device moving to K-DB data base to data provided in an embodiment of the present invention from DB2 database below is situated between
Continue, data described below moves to the device of K-DB data base with above-described data from DB2 database from DB2 database
The method moving to K-DB data base can be mutually to should refer to.
Refer to Fig. 5, the data that Fig. 5 is provided by the embodiment of the present invention moves to K-DB data base's from DB2 database
The structured flowchart of device;This device can include:
Information receiving module 100, for receiving the source link information of source DB2 database and the purpose of purpose K-DB data base
Link information;
Data extraction module 200, for being connected to described source DB2 database according to described source link information, extracts described
Migrating data in the DB2 database of source;Wherein, described migrating data includes DDL, object and/or data;
Data correction module 300, for being revised as supporting the first transport number of K-DB grammatical structure by described migrating data
According to;
Data loading module 400, for being connected to described purpose K-DB data base according to described purpose link information, in institute
State establishment table and index in purpose K-DB data base, and load described first migrating data.
Based on above-described embodiment, this device also includes, and connects and confirms module, for testing described source link information and described
Whether purpose link information is correct;If incorrect, point out user to confirm and change corresponding link information, and return wrong generation
Code.
Specifically, whether correct by judging the link information that user is provided by human-computer interaction interface, if it is not, returning wrong
False information and possible solution, to user, are pointed out user's modification link information or are guaranteed source DB2 database and purpose K-DB
Data base correctly configures.
Based on above-mentioned any embodiment, this device also includes, memory module, for by source database DB2 extract
Migrating data stores assigned catalogue.
Specifically, the first migrating data that amended migrating data supports K-DB grammatical structure is stored by this module
Assigned catalogue, so that follow-up use.
Based on above-mentioned any embodiment, this device also includes, load result judge module, for being judged according to load result
Whether successfully load, and record loading daily record;If unsuccessful loading, return the daily record of described loading and miscue information.
Specifically, complete load in the DB2 database of described source extract migrating data to purpose K-DB data base it
Afterwards, need load result is judged, if it is not, then providing error reason prompting, by user's such as (DBA) modification error
After DDL, object and/or data, re-start loading.
Based on above-described embodiment, this device also includes, and also includes:Authentication module, for described source DB2 database and institute
The data stating purpose K-DB data base carries out consistency checking;When failing the authentication, confirm Data Migration failure, and output error
Information.
Specifically, after completing data and loading and pass through the judgement of load result judge module, need to source DB2 data
Data in storehouse and purpose K-DB data base carries out consistency checking, if authentication failed, it is determined that Data Migration failure, exports wrong
False information.To guarantee the correct of Data Migration.
In description, each embodiment is described by the way of going forward one by one, and what each embodiment stressed is real with other
Apply the difference of example, between each embodiment identical similar portion mutually referring to.For device disclosed in embodiment
Speech, because it corresponds to the method disclosed in Example, so description is fairly simple, referring to method part illustration in place of correlation
?.
Professional further appreciates that, in conjunction with the unit of each example of the embodiments described herein description
And algorithm steps, can with electronic hardware, computer software or the two be implemented in combination in, in order to clearly demonstrate hardware and
The interchangeability of software, generally describes composition and the step of each example in the above description according to function.These
Function to be executed with hardware or software mode actually, the application-specific depending on technical scheme and design constraint.Specialty
Technical staff can use different methods to each specific application realize described function, but this realization should
Think beyond the scope of this invention.
The step of the method in conjunction with the embodiments described herein description or algorithm can directly be held with hardware, processor
The software module of row, or the combination of the two is implementing.Software module can be placed in random access memory (RAM), internal memory, read-only deposit
Reservoir (ROM), electrically programmable ROM, electrically erasable ROM, depositor, hard disk, moveable magnetic disc, CD-ROM or technology
In known any other form of storage medium in field.
The method and device moving to K-DB data base to data provided by the present invention from DB2 database above is carried out
It is discussed in detail.Specific case used herein is set forth to the principle of the present invention and embodiment, above example
Illustrate that being only intended to help understands the method for the present invention and its core concept.It should be pointed out that the common skill for the art
For art personnel, under the premise without departing from the principles of the invention, the present invention can also be carried out with some improvement and modify, these change
Enter and modify in the protection domain also falling into the claims in the present invention.
Claims (10)
1. a kind of data moves to the method for K-DB data base it is characterised in that including from DB2 database:
The source link information of reception source DB2 database and the purpose link information of purpose K-DB data base;
Described source DB2 database is connected to according to described source link information, extracts the migrating data in the DB2 database of described source;
Wherein, described migrating data includes DDL, object and/or data;
Described migrating data is revised as supporting the first migrating data of K-DB grammatical structure;
Described purpose K-DB data base is connected to according to described purpose link information, described purpose K-DB data base creates table
And index, and load described first migrating data.
2. method according to claim 1 is it is characterised in that receive source link information and purpose K- of source DB2 database
After the purpose link information of DB data base, also include:
Test described source link information and whether described purpose link information is correct;
If incorrect, point out user to confirm and change corresponding link information, and return error code.
3. after method according to claim 2 is it is characterised in that extract the migrating data in the DB2 database of described source,
Also include:
Whether the migrating data that detection is extracted is complete;
If imperfect, preserve detection daily record, and return error message.
4. method according to claim 2, it is characterised in that extracting the migrating data in the DB2 database of described source, is wrapped
Include:
Extract the migrating data that the user in the DB2 database of described source specifies, and the migrating data of extraction is stored specified mesh
Record.
5. method according to claim 3 is it is characterised in that also include:
Monitor the extraction progress of described migrating data, and be presented to user in the form of progress bar;And/or,
Monitor the loading progress of described first migrating data, and be presented to user in the form of progress bar.
6. after the method according to any one of claim 1-5 is it is characterised in that load described first migrating data, also
Including:
Judge whether successfully to load according to load result, and record loading daily record;
If unsuccessful loading, return the daily record of described loading and miscue information.
If after 7. method according to claim 6 is it is characterised in that load success, also including:
Consistency checking is carried out to the data of described source DB2 database and described purpose K-DB data base;
When failing the authentication, confirm Data Migration failure, and output error message.
8. a kind of data moves to the device of K-DB data base it is characterised in that including from DB2 database:
Information receiving module, the purpose of source link information and purpose K-DB data base for receiving source DB2 database connects letter
Breath;
Data extraction module, for being connected to described source DB2 database according to described source link information, extracts described source DB2 number
According to the migrating data in storehouse;Wherein, described migrating data includes DDL, object and/or data;
Data correction module, for being revised as supporting the first migrating data of K-DB grammatical structure by described migrating data;
Data loading module, for being connected to described purpose K-DB data base according to described purpose link information, in described purpose
Create table and index in K-DB data base, and load described first migrating data.
9. device according to claim 8 is it is characterised in that also include:
Load result judge module, for judging whether successfully to load according to load result, and records loading daily record;If unsuccessful
Load, then return the daily record of described loading and miscue information.
10. device according to claim 9 is it is characterised in that also include:
Authentication module, for carrying out consistency checking to the data of described source DB2 database and described purpose K-DB data base;When
During authentication failed, confirm Data Migration failure, and output error message.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610849225.3A CN106446166A (en) | 2016-09-23 | 2016-09-23 | Method and device for migrating data from DB2 database to K-DB database |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610849225.3A CN106446166A (en) | 2016-09-23 | 2016-09-23 | Method and device for migrating data from DB2 database to K-DB database |
Publications (1)
Publication Number | Publication Date |
---|---|
CN106446166A true CN106446166A (en) | 2017-02-22 |
Family
ID=58169398
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610849225.3A Pending CN106446166A (en) | 2016-09-23 | 2016-09-23 | Method and device for migrating data from DB2 database to K-DB database |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106446166A (en) |
Cited By (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107315814A (en) * | 2017-06-29 | 2017-11-03 | 郑州云海信息技术有限公司 | Data consistency checking method and system after a kind of KDB database data migrations |
CN107943889A (en) * | 2017-11-16 | 2018-04-20 | 郑州云海信息技术有限公司 | A kind of migration scheme of MySQL to KDB databases |
CN109299072A (en) * | 2018-10-16 | 2019-02-01 | 郑州云海信息技术有限公司 | A kind of method and device that database migrates online |
CN109359085A (en) * | 2018-08-23 | 2019-02-19 | 平安科技(深圳)有限公司 | File migration method, apparatus, computer equipment and storage medium |
CN109614443A (en) * | 2018-11-06 | 2019-04-12 | 武汉达梦数据库有限公司 | For the DDL synchronous method and equipment of V9.7 version d B2 database |
CN110019135A (en) * | 2017-12-27 | 2019-07-16 | 航天信息股份有限公司 | It is a kind of to migrate relational data to the method and device of HBase database |
CN110659255A (en) * | 2018-06-28 | 2020-01-07 | 武汉斗鱼网络科技有限公司 | Data migration method, device and system and storage medium |
CN111708753A (en) * | 2020-05-18 | 2020-09-25 | 北京金山云网络技术有限公司 | Method, device and equipment for evaluating database migration and computer storage medium |
CN113409015A (en) * | 2021-06-21 | 2021-09-17 | 浙江省能源集团有限公司 | ERP system and use method of ERP system in double-activity deployment of double data centers |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104462119A (en) * | 2013-09-18 | 2015-03-25 | 腾讯科技(深圳)有限公司 | Data migration method and device |
CN105095507A (en) * | 2015-08-31 | 2015-11-25 | 浪潮(北京)电子信息产业有限公司 | DB2 database migration method, device and system |
CN105550258A (en) * | 2015-12-09 | 2016-05-04 | 浪潮电子信息产业股份有限公司 | DB2 database migration tool for migration between platforms |
CN105760517A (en) * | 2016-02-25 | 2016-07-13 | 浪潮(北京)电子信息产业有限公司 | Method and device for transferring data from Oracle database to DB2 database |
-
2016
- 2016-09-23 CN CN201610849225.3A patent/CN106446166A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104462119A (en) * | 2013-09-18 | 2015-03-25 | 腾讯科技(深圳)有限公司 | Data migration method and device |
CN105095507A (en) * | 2015-08-31 | 2015-11-25 | 浪潮(北京)电子信息产业有限公司 | DB2 database migration method, device and system |
CN105550258A (en) * | 2015-12-09 | 2016-05-04 | 浪潮电子信息产业股份有限公司 | DB2 database migration tool for migration between platforms |
CN105760517A (en) * | 2016-02-25 | 2016-07-13 | 浪潮(北京)电子信息产业有限公司 | Method and device for transferring data from Oracle database to DB2 database |
Non-Patent Citations (3)
Title |
---|
何清法等: "《国产神通数据库教程》", 30 September 2012 * |
常彦文: ""满满的干货!浪潮高级数据库工程师常彦文: DB2迁移到K-DB最佳实践"", 《HTTP://WWW.ITPUB.NET/THREAD-2059650-1-1.HTML》 * |
陈沛帅等: "《电子商务技术支撑体系研究与应用》", 31 December 2008, 浙江工商大学出版社 * |
Cited By (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107315814A (en) * | 2017-06-29 | 2017-11-03 | 郑州云海信息技术有限公司 | Data consistency checking method and system after a kind of KDB database data migrations |
CN107315814B (en) * | 2017-06-29 | 2021-03-02 | 苏州浪潮智能科技有限公司 | Method and system for verifying data consistency after data migration of KDB (KDB) database |
CN107943889A (en) * | 2017-11-16 | 2018-04-20 | 郑州云海信息技术有限公司 | A kind of migration scheme of MySQL to KDB databases |
CN110019135A (en) * | 2017-12-27 | 2019-07-16 | 航天信息股份有限公司 | It is a kind of to migrate relational data to the method and device of HBase database |
CN110659255A (en) * | 2018-06-28 | 2020-01-07 | 武汉斗鱼网络科技有限公司 | Data migration method, device and system and storage medium |
CN109359085A (en) * | 2018-08-23 | 2019-02-19 | 平安科技(深圳)有限公司 | File migration method, apparatus, computer equipment and storage medium |
CN109299072A (en) * | 2018-10-16 | 2019-02-01 | 郑州云海信息技术有限公司 | A kind of method and device that database migrates online |
CN109299072B (en) * | 2018-10-16 | 2022-06-10 | 郑州云海信息技术有限公司 | Method and device for online migration of database |
CN109614443A (en) * | 2018-11-06 | 2019-04-12 | 武汉达梦数据库有限公司 | For the DDL synchronous method and equipment of V9.7 version d B2 database |
CN109614443B (en) * | 2018-11-06 | 2021-04-13 | 武汉达梦数据库有限公司 | DDL synchronization method and device for V9.7 version DB2 database |
CN111708753A (en) * | 2020-05-18 | 2020-09-25 | 北京金山云网络技术有限公司 | Method, device and equipment for evaluating database migration and computer storage medium |
CN113409015A (en) * | 2021-06-21 | 2021-09-17 | 浙江省能源集团有限公司 | ERP system and use method of ERP system in double-activity deployment of double data centers |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106446166A (en) | Method and device for migrating data from DB2 database to K-DB database | |
CN103365770B (en) | Mobile terminal software test macro and method for testing software | |
CN106502904A (en) | A kind of UI automated testing methods of intelligent appliance equipment application | |
CN109165170B (en) | Method and system for automatic request test | |
CN107463362A (en) | The method and system of lasting deployment based on multiple Jenkins | |
CN110013672B (en) | Method, device, apparatus and computer-readable storage medium for automated testing of machine-run games | |
CN110088744B (en) | Database maintenance method and system | |
CN103678124B (en) | Video surveillance platform auto-test method and device based on continuous integrated environment | |
CN107608902A (en) | Routine interface method of testing and device | |
CN105760517A (en) | Method and device for transferring data from Oracle database to DB2 database | |
CN107193730A (en) | A kind of interface test method of automation | |
CN108763056A (en) | A kind of automatic test bullet frame processing method and terminal | |
CN114691398A (en) | Rule-based fault analysis method, device, equipment and storage medium | |
CN104899134A (en) | Automatic domain name registration server testing system and method | |
CN103984633B (en) | A kind of bank main passes down the automatization test system of operation | |
CN110515755A (en) | Interface function verification method, device, equipment and computer readable storage medium | |
CN103778026A (en) | Object calling method and device | |
CN105550103B (en) | A kind of automated testing method based on self-defined test script | |
CN112274913B (en) | Method and device for merging game servers, storage medium and electronic device | |
CN103186465B (en) | The browser compatibility method of testing of web user interface and system | |
CN109840814A (en) | A method of it is logged in based on Golden Taxes disk control system synchronous with data | |
CN110198222A (en) | A kind of distribution power automation terminal plug and play test method and test main website | |
CN108427645A (en) | Unattended method and system are realized in no command line interface automatically testing platform | |
CN210016474U (en) | Distribution network test control equipment and system | |
CN107122408A (en) | Information association and its database audit method, auditing system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170222 |
|
RJ01 | Rejection of invention patent application after publication |