Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Database News

Posted May 9, 2005

DB2 Universal Database versus Oracle data movement

By DatabaseJournal.com Staff

[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



Database News Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM