Browse Prior Art Database

Automation of Oracle Database Creation from DB2 DDL/DML Statements

IP.com Disclosure Number: IPCOM000019905D
Original Publication Date: 2003-Oct-09
Included in the Prior Art Database: 2003-Oct-09

Publishing Venue

IBM

Abstract

The beckend database for Content Management (CM) v8.1 is DB2 and one of feature in CM v8.2 is Oracle porting so that Oracle users can also use CM v8 product. However, in order to maintain a single codebase and scripts to create database and load initial data, an automation to transfer DB2 SQL statements like DDL/DML, which are used to create CM database and load CM initial data, and then to create Oracle database is required. With this refinement, only a single set of database statements needs be maintained so that there is no inconsistency concern. The automation is modular and easy to extend to cover new feathers. Moreover, it is easy to be used for installation utility or post-install users by "one-click and fire".