DB2 Universal Database versus Oracle data movement

Monday May 9th 2005 by DatabaseJournal.com Staff

If you've had experience with Oracle and now are starting to learn DB2® Universal Database(TM), this article will help you leverage your previous experience and put you on the fast track for learning how to move data from one machine to another, or from one platform to another.

[From IBM DeveloperWorks]

Data movement between two databases is a common daily DBA task. Most mature databases provide a means to move data from one database to another, either within the same platform or machine, or to other platforms or machines.

If you've experienced with Oracle and are now are beginning to learn DB2, this article will ease your learning process. The intention is to put Oracle DBAs into the DB2 Universal Database (DB2 UDB) fast track while keeping the differences between the two in mind. We'll take a look at the tools and commands you need to perform data movement, and compare and contrast the two database systems. We will also be looking at some scenarios for data movement.

Note that this article does not cover replication mechanisms for data movement such as Oracle Advanced Replication and WebSphere Information Integrator Q-Replication. Nor will we consider connectivity or data movement by using custom coding through JDBC, PERL DBI, and ODBC, as these interfaces are not meant for movement of large quantities of data.

The article continues at http://www-128.ibm.com/developerworks/.../index.html?ca=dgr-lnxw25DB2fromOracle

Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved