CN105550258A - DB2 database migration tool for migration between platforms - Google Patents
DB2 database migration tool for migration between platforms Download PDFInfo
- Publication number
- CN105550258A CN105550258A CN201510903066.6A CN201510903066A CN105550258A CN 105550258 A CN105550258 A CN 105550258A CN 201510903066 A CN201510903066 A CN 201510903066A CN 105550258 A CN105550258 A CN 105550258A
- Authority
- CN
- China
- Prior art keywords
- module
- migration
- communication port
- communication
- platform
- 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
Abstract
The invention discloses a DB2 database migration tool for migration between platforms, belonging to the technical field of cross-platform migration of a database in an information system. The DB2 database migration tool for migration between platforms comprises a source end and a destination end, a SPARC platform is the source end, a K-UX platform is the destination end, communication between the source end and the destination end is realized through an Ethernet, and the tool can be operated at both the source end and the destination end; and the tool comprises a migration tool software architecture and a migration algorithm. The DB2 database migration tool for migration between the platforms, provided by the invention, makes a database cross-platform migration method simple and relatively high-efficiency, and has very good popularization and application value.
Description
Technical field
The present invention relates to the cross-platform migrating technology field of database in infosystem, a kind of DB2 database migration instrument moved between platform is specifically provided.
Background technology
High-end server carries the core application of industry, is widely used in the crucial applications such as finance, telecommunications, the energy, traffic, and it runs and is directly connected to society, economic normal operation.For a long time, owing to lacking high-end server Design and manufacture ability, China's high-end server markets holds for foreign vendor always, and wherein Oracle occupies the home market of more than 20% for a long time.Under the support of Department of Science and Technology's Eleventh Five-Year Plan 863 Program, relevant departments, R&D institution actively coordinate, and successfully have developed 32 tunnel high-end fault-tolerant computer systems, availability reaches 99.999%, and system Transaction Processing ability reaches world-class levels.For improving the autonomous controllability of informatization Grand Equipments, increasing infosystem is tended to use from major product.Therefore, within following long period of time, domestic IT system construction is faced with the change of production domesticization, concrete Information System configuration and practice level, be presented as increasing cross-platform migration work, wherein have suitable migration work to be from SPARC platform to K-UX platform.
Database is the kernel software of IT system, and database migration is also a part very important during IT system is built.Due to the cpu instruction collection difference of heterogeneous server platforms, operating system difference and compiler difference, make database cross platform migration difficulty high, workload is large.How reducing transplanting difficulty, reduce workload, is the key issue that database cross platform migration needs to solve.
Summary of the invention
Technical assignment of the present invention is for above-mentioned Problems existing, provides one to make database cross-platform migration method simple, the DB2 database migration instrument that what efficiency was higher move between platform.
For achieving the above object, the invention provides following technical scheme:
The DB2 database migration instrument moved between platform, comprises source and destination end, and wherein SPARC platform is source, and K-UX platform is destination end, realizes source communicate with destination end by Ethernet, all can operate instrument in source or destination end; Source and destination end scan respective place platform environment, according to scanning result and migration algorithm, generate migration assessment report and migration scheme proposals; According to user, Migration Wizard is generated to the screening of migration scheme proposals and migration algorithm, by Migration Wizard to the prompting of user and guidance, realize the cross-platform cross version semi automatic migration of DB2 database data from other server platforms to K-UX platform; This instrument comprises Migration tools software architecture and migration algorithm.
As preferably, described source comprises communication module, analysis module, backup module and control desk module, control desk module first communication port is connected with communication module first communication port, control desk module second communication port is connected with analysis module first communication port, control desk module third communication port is connected with backup module, communication module second communication port is connected with analysis module second communication port, communication module third communication port is connected with backup module second communication port, communication module the 4th communication port is connected by Ethernet with destination end communication module the 4th port.
Communication module realizes source by Ethernet and communicates with destination end.Analysis module collects source platform information and database information, platform information comprises processor architecture information, instruction set information, syllable sequence information, compiler information, operation system information, system variable information and filesystem information, and database information comprises database version information, data amount information, table information, index information, storing process information, user profile, log information.The manual intervention that backup module sends according to Migration Wizard, migration algorithm and control desk performs source DB2 Database Backup operations, and feedback often walks the result of operation to control desk module and communication module.Control module is used for realizing man-machine interaction.
As preferably, destination end comprises communication module, analysis module, recover module and control desk module, wherein control desk module first communication port is connected with communication module first communication port, control desk module second communication port is connected with analysis module first communication port, control desk module third communication port is connected with recovery module, communication module second communication port is connected with analysis module second communication port, communication module third communication port is connected with recovery module two communication port, communication module the 4th communication port is connected by Ethernet with source communications module the 4th port.
Communication module is by Ethernet realize target end and source communications.Analysis module collects the database information of destination end platform information and recovery, platform information comprises processor architecture information, instruction set information, syllable sequence information, compiler information, operation system information, system variable information and filesystem information, and the database information of recovery comprises database version information, data amount information, table information, index information, storing process information, user profile, log information.Recover the manual intervention execution source DB2 database recovery operation that module sends according to Migration Wizard, migration algorithm and control desk, and feedback often walks the result of operation to control desk module and communication module.Control desk module is used for realizing man-machine interaction.
As preferably, described migration algorithm comprises Migration Wizard generating algorithm and Backup and Restore algorithm.
The present invention has following outstanding beneficial effect: described method makes database cross-platform migration method simple, and efficiency is higher, solves a difficult problem for database cross platform migration, has good practicality.
Embodiment
Below in conjunction with embodiment, the DB2 database migration instrument moved between platform of the present invention is described in further detail.
Embodiment
The DB2 database migration instrument moved between platform of the present invention, comprise source and destination end, wherein SPARC platform is source, and K-UX platform is destination end, realize source by Ethernet to communicate with destination end, all can operate instrument in source or destination end; Source and destination end scan respective place platform environment, according to scanning result and migration algorithm, generate migration assessment report and migration scheme proposals; According to user, Migration Wizard is generated to the screening of migration scheme proposals and migration algorithm, by Migration Wizard to the prompting of user and guidance, realize the cross-platform cross version semi automatic migration of DB2 database data from other server platforms to K-UX platform; This instrument comprises Migration tools software architecture and migration algorithm.Migration algorithm comprises Migration Wizard generating algorithm and Backup and Restore algorithm.Source comprises communication module, analysis module, backup module and control desk module, control desk module first communication port is connected with communication module first communication port, control desk module second communication port is connected with analysis module first communication port, control desk module third communication port is connected with backup module, communication module second communication port is connected with analysis module second communication port, communication module third communication port is connected with backup module second communication port, communication module the 4th communication port is connected by Ethernet with destination end communication module the 4th port.Destination end comprises communication module, analysis module, recover module and control desk module, wherein control desk module first communication port is connected with communication module first communication port, control desk module second communication port is connected with analysis module first communication port, control desk module third communication port is connected with recovery module, communication module second communication port is connected with analysis module second communication port, communication module third communication port is connected with recovery module two communication port, communication module the 4th communication port is connected by Ethernet with source communications module the 4th port.
Above-described embodiment, just the present invention's more preferably embodiment, the usual change that those skilled in the art carries out within the scope of technical solution of the present invention and replacement all should be included in protection scope of the present invention.
Claims (4)
1. the DB2 database migration instrument moved between platform, it is characterized in that: comprise source and destination end, wherein SPARC platform is source, and K-UX platform is destination end, realize source by Ethernet to communicate with destination end, all can operate instrument in source or destination end; Source and destination end scan respective place platform environment, according to scanning result and migration algorithm, generate migration assessment report and migration scheme proposals; According to user, Migration Wizard is generated to the screening of migration scheme proposals and migration algorithm, by Migration Wizard to the prompting of user and guidance, realize the cross-platform cross version semi automatic migration of DB2 database data from other server platforms to K-UX platform; This instrument comprises Migration tools software architecture and migration algorithm.
2. the DB2 database migration instrument moved between platform according to claim 1, it is characterized in that: described source comprises communication module, analysis module, backup module and control desk module, control desk module first communication port is connected with communication module first communication port, control desk module second communication port is connected with analysis module first communication port, control desk module third communication port is connected with backup module, communication module second communication port is connected with analysis module second communication port, communication module third communication port is connected with backup module second communication port, communication module the 4th communication port is connected by Ethernet with destination end communication module the 4th port.
3. the DB2 database migration instrument moved between platform according to claim 1 and 2, it is characterized in that: destination end comprises communication module, analysis module, recover module and control desk module, wherein control desk module first communication port is connected with communication module first communication port, control desk module second communication port is connected with analysis module first communication port, control desk module third communication port is connected with recovery module, communication module second communication port is connected with analysis module second communication port, communication module third communication port is connected with recovery module two communication port, communication module the 4th communication port is connected by Ethernet with source communications module the 4th port.
4. the DB2 database migration instrument moved between platform according to claim 3, is characterized in that: described migration algorithm comprises Migration Wizard generating algorithm and Backup and Restore algorithm.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510903066.6A CN105550258A (en) | 2015-12-09 | 2015-12-09 | DB2 database migration tool for migration between platforms |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510903066.6A CN105550258A (en) | 2015-12-09 | 2015-12-09 | DB2 database migration tool for migration between platforms |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105550258A true CN105550258A (en) | 2016-05-04 |
Family
ID=55829447
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510903066.6A Pending CN105550258A (en) | 2015-12-09 | 2015-12-09 | DB2 database migration tool for migration between platforms |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105550258A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106446166A (en) * | 2016-09-23 | 2017-02-22 | 郑州云海信息技术有限公司 | Method and device for migrating data from DB2 database to K-DB database |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104573056A (en) * | 2015-01-22 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Database large data volume online migration method based on oracle |
| CN104573122A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Oracle database migration tool migrating from AIX platform to K-UX platform |
| CN104573121A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | DB2 database migration tool migrating from AIX platform to K-UX platform |
| CN105095506A (en) * | 2015-08-31 | 2015-11-25 | 浪潮(北京)电子信息产业有限公司 | Sybase database migration method and system |
-
2015
- 2015-12-09 CN CN201510903066.6A patent/CN105550258A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104573056A (en) * | 2015-01-22 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Database large data volume online migration method based on oracle |
| CN104573122A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Oracle database migration tool migrating from AIX platform to K-UX platform |
| CN104573121A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | DB2 database migration tool migrating from AIX platform to K-UX platform |
| CN105095506A (en) * | 2015-08-31 | 2015-11-25 | 浪潮(北京)电子信息产业有限公司 | Sybase database migration method and system |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106446166A (en) * | 2016-09-23 | 2017-02-22 | 郑州云海信息技术有限公司 | Method and device for migrating data from DB2 database to K-DB database |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104573121A (en) | DB2 database migration tool migrating from AIX platform to K-UX platform | |
| CN104899333A (en) | Cross-platform migrating method and system for Oracle database | |
| CN104573122A (en) | Oracle database migration tool migrating from AIX platform to K-UX platform | |
| CN105138603A (en) | Oracle database migration tool for carrying out migration from HP-UX platform to K-UX platform | |
| CN104573123A (en) | Sybase database migration tool migrating from AIX platform to K-UX platform | |
| JP2022141957A (en) | Metadata snapshot method and snap device thereof | |
| CN104899332A (en) | Cross-platform migrating method and system for Sybase database | |
| CN102254021A (en) | Method for constructing database based on virtual machine management system | |
| CN104598233A (en) | Code generation method | |
| CN103530134A (en) | Configurable software platform structure | |
| CN105550258A (en) | DB2 database migration tool for migration between platforms | |
| CN106168793B (en) | A kind of method and system automatically generating control device | |
| CN102750610A (en) | Transaction control method in product lifecycle phase management-enterprise resource planning (PLM-ERP) integration process | |
| CN104346441A (en) | Dynamic integration and interaction method for information data of power distribution network | |
| CN104063598A (en) | Combined clamp assembly optimizing method based on assembly dimension path diagram | |
| CN105678472A (en) | Method for inverse building of product BOM | |
| CN105072052A (en) | Hybrid SDN (Software Defined Networking) switch by utilizing dynamic migration technology | |
| JP7253603B2 (en) | Ethereum virtual machine transaction processing method, apparatus, equipment, and medium | |
| CN104536798A (en) | C/C++application migration tool from SPARC platform to K-UX platform | |
| CN105045879A (en) | Parallel data processing method | |
| CN104765800A (en) | Big data based efficient search method | |
| CN105095507A (en) | DB2 database migration method, device and system | |
| CN114896655A (en) | Method, device, equipment and medium for determining component calculated amount in antique building project | |
| CN103440325B (en) | Operation method of high-efficiency multi-concurrence and auto-adaptation database | |
| CN104516766A (en) | C/C++ application migration tool from AIX platform to K-UX platform |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | 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: 20160504 |
|
| RJ01 | Rejection of invention patent application after publication |