List of Compatibility Checklist to Migrate Oracle to DB2

Here is a checklist helpful for migrating the Oracle database to the DB2 database. Read the below article for compatibility.

Checklist to migrate

DB2 supports NUMBER, VARCHAR2, and VARRAY of Oracle. Similarly, several Oracle proprietary SQL statements: such as CONNECT BY, ROWNUM, and more. DB2 also supports these.

Oracle’s date-and-time arithmetic functions, string-manipulation functions, and other functions DB2 also support. The same applies to packages, built-in packages, and SQL*PLus scripts.



Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.

One thought

Comments are closed.