DB2 Universal Database versus Oracle data movement

May 9, 2005

[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