Moving from Oracle to DB2
W.J.Chen 11000066R1 Visits (2023)
IBM DB2 10.5 for Linux, UNIX, and Windows operating systems offers extensive native support for Oracle compatibility, including native support for Oracle SQL and PL/SQL dialects. This support allows many applications that are written against Oracle to run against DB2 with minimal or no changes, allowing you to easily migrate your applications to DB2.
Traditionally, converting from one database vendor to another vendor was a manual, difficult, and time-consuming task. But today, IBM provides a set of enablement tools that simplify and partly automate the process. The tools make extraction and deployment of schema definitions and data movement more manageable, even when there are tens of thousands of DDL and procedural objects.
IBM Data Studio
IBM Data Studio is a comprehensive data management tool in the IBM InfoSphere Optim family of data lifecycle tools and solutions. Based on the Eclipse platform, Data Studio provides an integrated, modular environment for database development and administration of DB2 for Linux, UNIX, and Windows. It also aids in application development with support for Java, XML editors, and other technologies. Data Studio enables heterogeneous database environments through its support of collaborative database development tools for IBM DB2 for z/OS, IBM DB2 for i, and IBM Informix.
Data Studio aims to support the entire database development lifecycle from design, through implementation and application development, to change management, administration, and maintenance.
Data Studio helps you perform many typical database development and administration tasks:
Complete details about Data Studio, including an option to download it at no cost, are available at this address:
IBM Database Conversion Workbench
The IBM Database Conversion Workbench (DCW) provides an end-to-end solution through an integrated workbench of tools to facilitate your conversion to DB2. DCW is a no additional charge plug-in that can be easily installed to add database migration capabilities to Data Studio. Whether you are converting to DB2 from another relational database management system (RDBMS) or migrating from one version of DB2 to another version, DCW provides an easy-to-use framework to take you through the conversion process.
DCW combines many of the tools that are used for database conversion into a single graphical user environment and follows processes that are based on several leading practices that are identified by IBM data migration consultants.
DCW provides the following benefits to the user:
The conversion features in DCW can be used together to carry a user through all of the steps of a database conversion or, if the user prefers, each of the features can be used separately.
DCW offers several step-by-step functions to facilitate the conversion process:
For more information about DCW, see the DCW community at: http
For the detail information about moving from Oracle to DB2, see IBM Redbooks publication Orac