Method and device for transferring data from Oracle database to DB2 database

Abstract

The embodiment of the invention provides a method and device for transferring data from an Oracle database to a DB2 database.The method includes the steps that source connecting information, given by a user through a man-machine interactive interface, of the source Oracle database of data to be transferred and destination connecting information of the destination DB2 database of transferred data to be received are received; according to the source connecting information, connection to the source Oracle database is performed, and a DDL object and / or data in the source Oracle database are / is extracted; according to the connecting information of the destination database, connection to the destination DB2 database is performed, a table and indexes are created in the destination DB2 database, and the DDL object and / or data extracted from the source Oracle database are / is loaded.Operation is easy, the manual operation fault rate and error rate are reduced, the data is transferred into the DB2 database from the Oracle database automatically, data transferring is more accurate and efficient, the risk of losing the data resources is reduced, and higher safety is achieved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and a device for migrating data from an Oracle database to a DB2 database. Background technique [0002] Both Oracle database and DB2 database are relational databases used by many applications in the market. As the application functions become more and more powerful, the version upgrade and reinstallation of the application will require the original data to be retained. In this way, the migration between different types of databases has become the focus of the data migration part of the application function. [0003] At present, data in the Oracle database is migrated to the DB2 database usually by a DBA (Database Administrator, database administrator) in a completely manual manner. The amount of data stored in the database is often large and the structure is relatively complex. DBAs often need to perform a large number of complex data migration operations to migrate...

AI Technical Summary

Problems solved by technology

[0004] In view of this, the embodiment of the present invention provides a method and device for migrating data from an Oracle database to a DB2 database, so as to solve the problem of migrating data in an Oracle database to a DB2 database in a completely manual manner in the prior art. The DBA operation error rate and error rate are high, the efficiency is also low, and it may face the risk of data resource loss and low security.

Images