CN107943889A - A kind of migration scheme of MySQL to KDB databases - Google Patents
A kind of migration scheme of MySQL to KDB databases Download PDFInfo
- Publication number
- CN107943889A CN107943889A CN201711136718.3A CN201711136718A CN107943889A CN 107943889 A CN107943889 A CN 107943889A CN 201711136718 A CN201711136718 A CN 201711136718A CN 107943889 A CN107943889 A CN 107943889A
- Authority
- CN
- China
- Prior art keywords
- database
- migration
- mysql
- kdb
- oracle
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to database technology, moving method and system between more particularly to a kind of database.First, first database is moved into the second database, secondly, by the second database migration to the 3rd database.It is mainly graphical operation process in transition process, operating procedure is simple and clear, simplifies migration step.
Description
Technical field
The present invention relates to database technology, moving method and system between more particularly to a kind of database.
Background technology
Mysql has suitable occupation rate as PostgreSQL database product, existing market；KDB is as Domestic Database, mesh
It is preceding to have there are multiple clients to run production application system in KDB database environments, and obtain the consistent accreditation of client.
After client purchases KDB databases, often it is related to data migration task, KDB databases have oracle database
Open interface, can use kdMigrator Migration tools to carry out Data Migration, but for MySQL database, KDB is not
Have it is open for interface, migrated, i.e., exported to the data in MySQL database frequently with smooth file mode at present
Smooth file (such as txt file), then performs importing in KDB databases using kdloader, and the process is not only time-consuming longer,
And the easy product bad files in transition process.
In the prior art, there are one bond migration instrument of kdMigrator KDB databases, it is possible to achieve Oracle to KDB's
Rapid data migrates work, and there is also sql developer Oracle client utilities, it is possible to achieve mysql to Oracle
The migration of database.
The content of the invention
The present invention proposes a kind of moving method and device of Mysql to KDB databases, and operating procedure is simple and clear, simplifies
Migration step, quickly realizes the migration of Mysql to KDB databases.
The present invention is achieved through the following technical solutions, a kind of moving method of database, first, by first database
The second database is moved to, secondly, by the second database migration to the 3rd database.Further, first database is
Mysql.Further, the second database is Oracle.Further, the 3rd database is KDB.
The present invention also provides a kind of device for realizing database migration, including the first module and the second module；Wherein first
Module, for first database to be moved to the second database；Second module, for by the second database migration to the 3rd data
Storehouse.Further, first database Mysql.Further, the second database is Oracle.Further, the 3rd number
It is KDB according to storehouse.
The present invention also provides a kind of method of test database migration, first, by Environment Design database software and instrument
Software installation, secondly, starts database environment and prepares, finally, perform database migration.Specifically, database environment prepares bag
Include MySQL database environmental preparation, Oracle environmental preparations, KDB environmental preparations.
Brief description of the drawings
A kind of flow chart for database migration method that Fig. 1 one embodiment of the invention is provided
Embodiment
Presently preferred embodiments of the present invention is described in detail below in conjunction with the accompanying drawings.Following embodiments are only used for clearer
Ground illustrates technical scheme, and is not intended to limit the protection scope of the present invention and limits the scope of the invention.
In one embodiment of the invention, there is provided a kind of moving method of MySQL to KDB databases, first, by first database
The second database is moved to, secondly, by the second database migration to the 3rd database.Specifically, first database can be
Mysql, the second database are Oracle, and the 3rd database is KDB.
One embodiment of the invention additionally provides a kind of device for realizing database migration, it is characterised in that：Including the first mould
Block and the second module；Wherein the first module, for first database to be moved to the second database；Second module, for by
Two database migrations to the 3rd database.Specifically, first database can be Mysql, the second database is Oracle, the 3rd
Database is KDB.
In one embodiment of the invention, the migration of Mysql databases to oracle database can use oracle sql
Developer instruments realize simple and quick migration, and the migration of Oracle to kdb databases can be migrated using kdMigrator
Instrument realizes a bond migration, so as to fulfill the migration work of MySQL to kdb.
In one embodiment of the invention, the migration of the database, database software needed for the present invention are realized using a computer
And tool software is all stored in the storage medium of the computer, foregoing storage medium includes：ROM, RAM, magnetic disc or light
Disk etc. is various can be with the medium of store program codes.
The present invention also provides a kind of according to Data Migration work, simulation test environment and the side for performing Data Migration
Method, first, Environment Design database software and tool software are installed, and secondly, start environmental preparation, finally, perform database
Migration.Specifically, environmental preparation includes MySQL database environmental preparation, Oracle environmental preparations, KDB environmental preparations, sql
Developer prepares, dMigrator prepares.
And MySQL database environmental preparation includes herein below：
1) database is created：create database mv_test；
2) user is created：create user’mv_test’@’10.156.11.2’identified by’mv_test’；
3) power is assigned：grant all on mv_test.*to’mv_test’@’10.156.11.2’；
4) test table is created, is inserted into test data：
Mysql ＞ use mv_test
Mysql ＞ create table t1as select*from mysql.user；
5) database table is checked：show tables.
Oracle environmental preparations include herein below：
1) table space is created：create tablespace mv_test datafile size 100M autoextend
on；
2) user is created：create user mv_test identified by mv_test default
tablespace mv_test；
3) power is assigned：Grant resource, connect, dba to mv_test.
KDB environmental preparations include herein below：
1) table space is created：create tablespace mv_test datafile size 100M autoextend
on；
2) user is created：create user mv_test identified by mv_test default
tablespacemv_test；
3) power is assigned：Grant resource, connect, dba to mv_test.
Sql developer prepare to include herein below：
1) sql developer instruments are opened, select jdk (being preferably selected the jdk that oracle is carried) to add one first
Mysql jdbc drive, for connecting mysql databases：
2) connection of Oracle and mysql is respectively created.
DMigrator prepares to include herein below：
Source connects oracle database, the connection kdb databases of target.
So far, the environmental preparation stage completes.
The migration step of MySQL to Oracle data is as follows：
1) in oracle connections, right button -- the transplanting association transplanting repository of repository one, can eject pair at this time
Frame is talked about, waits after being successfully associated, has successfully prompt message；
2) in mysql connections, right button -- it is transplanted to Oracle：
3) according to the prompting of migration wizard, the information of needs is inputted, corresponding prompting is had after the completion of transplanting：
4) Oracle data are checked：Meet anticipatory data situation, so far complete the migration step of MySQL to Oracle；
Oracle to kdb Data Migration steps are as follows：
1) migration work is performed using kdmigrator instruments, clicks on selection mv_test user, clicked on operation and perform a key
Migration：
Complete migration：
1) kdb data are checked：
By contrast, confirm that data are consistent with mysql data, so far entirely migration flow finishes, and migrates successfully.
The present invention is a kind of MySQL to KDB database data migrations scheme.By being used as centre by oracle database
Medium, completes whole migration flow, is mainly graphical operation process in transition process, operating procedure is simple and clear, simplifies
Migration step.From flow, more than once migration operation, and by means of oracle database, but overall complexity and
More optimize on operation complexity, migration work can be completed faster.
The foregoing is merely illustrative of the preferred embodiments of the present invention, is not intended to limit the invention, all essences in the present invention
All any modification, equivalent and improvement made within refreshing and principle etc., should all be included in the protection scope of the present invention.
Claims (10)
- A kind of 1. moving method of database, it is characterised in that：First, first database is moved into the second database, secondly, By the second database migration to the 3rd database.
- 2. the moving method of database according to claim 1, it is characterised in that：First database is Mysql.
- 3. the moving method of database according to claim 1, it is characterised in that：Second database is Oracle.
- 4. the moving method of database according to claim 1, it is characterised in that：3rd database is KDB.
- A kind of 5. device for realizing database migration, it is characterised in that：Including the first module and the second module；Wherein the first mould Block, for first database to be moved to the second database；Second module, for by the second database migration to the 3rd data Storehouse.
- 6. the device according to claim 5 for realizing database migration, it is characterised in that：First database is Mysql.
- 7. the device according to claim 5 for realizing database migration, it is characterised in that：Second database is Oracle.
- 8. the device according to claim 5 for realizing database migration, it is characterised in that：3rd database is KDB.
- A kind of 9. method of test database migration, it is characterised in that：This method comprises the following steps：First, by Environment Design Database software and tool software installation；Secondly, environmental preparation is started；Finally, database migration is performed.
- 10. the method for test database migration according to claim 9, it is characterised in that：Environmental preparation includes MySQL numbers Prepare according to lab environment, Oracle environmental preparations, KDB environmental preparations.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711136718.3A CN107943889A (en) | 2017-11-16 | 2017-11-16 | A kind of migration scheme of MySQL to KDB databases |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711136718.3A CN107943889A (en) | 2017-11-16 | 2017-11-16 | A kind of migration scheme of MySQL to KDB databases |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107943889A true CN107943889A (en) | 2018-04-20 |
Family
ID=61931414
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711136718.3A Pending CN107943889A (en) | 2017-11-16 | 2017-11-16 | A kind of migration scheme of MySQL to KDB databases |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107943889A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110659255A (en) * | 2018-06-28 | 2020-01-07 | 武汉斗鱼网络科技有限公司 | Data migration method, device and system and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105740462A (en) * | 2016-03-02 | 2016-07-06 | 上海新炬网络信息技术有限公司 | Method for supporting data migration between different environments |
| CN106446166A (en) * | 2016-09-23 | 2017-02-22 | 郑州云海信息技术有限公司 | Method and device for migrating data from DB2 database to K-DB database |
| CN107066261A (en) * | 2017-03-09 | 2017-08-18 | 郑州云海信息技术有限公司 | The system and method for data-base cluster are built in a kind of K UX operating systems |
| CN107133244A (en) * | 2016-02-29 | 2017-09-05 | 阿里巴巴集团控股有限公司 | The method of testing and device of a kind of database migration |
-
2017
- 2017-11-16 CN CN201711136718.3A patent/CN107943889A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107133244A (en) * | 2016-02-29 | 2017-09-05 | 阿里巴巴集团控股有限公司 | The method of testing and device of a kind of database migration |
| CN105740462A (en) * | 2016-03-02 | 2016-07-06 | 上海新炬网络信息技术有限公司 | Method for supporting data migration between different environments |
| CN106446166A (en) * | 2016-09-23 | 2017-02-22 | 郑州云海信息技术有限公司 | Method and device for migrating data from DB2 database to K-DB database |
| CN107066261A (en) * | 2017-03-09 | 2017-08-18 | 郑州云海信息技术有限公司 | The system and method for data-base cluster are built in a kind of K UX operating systems |
Non-Patent Citations (2)
| Title |
|---|
| ZJ_MADDDOG: "使用Oracle SQL Developer迁移MySQL至Oracle数据库", 《HTTPS://BLOG.CSDN.NET/ZJ_MADDOG/ARTICLE/DETAILS/75222516》 * |
| 中关村在线: "K-DB干货：如何做到6GB数据迁移15分钟?", 《HTTP://SERVER.ZOL.COM.CN/555/555682又ALL.HTML#P5556864》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110659255A (en) * | 2018-06-28 | 2020-01-07 | 武汉斗鱼网络科技有限公司 | Data migration method, device and system and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103544323B (en) | A kind of data-updating method and device | |
| US8589336B1 (en) | Framework for automated storage processes and flexible workflow | |
| CN103093000A (en) | Database query modeling system and database query modeling method | |
| TW200903324A (en) | Systems and methods for modeling partitioned tables as logical indexes | |
| US9619492B2 (en) | Data migration | |
| US10205730B2 (en) | Access control for database | |
| CN108897874B (en) | Method and apparatus for processing data | |
| CN110990274B (en) | Data processing method, device and system for generating test cases | |
| CN109716321B (en) | N-way hash connection | |
| US20120330988A1 (en) | Systems And Methods For Performing Index Joins Using Auto Generative Queries | |
| CN104516864A (en) | Report generating method and report generating device | |
| CN110716960B (en) | Database query method, device, equipment and storage medium | |
| CN112269785B (en) | Method and system for dynamically filling field in subject state details in EDC (electronic data communication) system | |
| CN107943889A (en) | A kind of migration scheme of MySQL to KDB databases | |
| CN108874871B (en) | Real-time PNT service data tracing method and device | |
| CN104598661B (en) | For the method and apparatus for changing requirement analysis for the project for being related to IT system | |
| CN109597824A (en) | The efficient write method of SQL statement | |
| CN104424525B (en) | Auxiliary is identified project the method and apparatus of scope | |
| Yaish et al. | A multi-tenant database architecture design for software applications | |
| CN108959454A (en) | A kind of prompt clause designation method, device, equipment and storage medium | |
| WO2020201830A1 (en) | Systems and methods for generating, monitoring, and analyzing event networks from event data | |
| CN112667598A (en) | Data model rapid construction system based on business demand change | |
| US9201937B2 (en) | Rapid provisioning of information for business analytics | |
| CN108132802B (en) | Application method of configuration model in system development | |
| US10558668B2 (en) | Result set output criteria |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180420 |