The request was to make a HRMIS(HR management information system) web application that was developed initially with DB2 database as back end to work with Oracle database, preserving existing data.
We do the following actions:
migrate database schema from DB2 and make compatible with Oracle, including stored procedures, views, triggers
rewrite all sql from java web application to be ansi compatible
migrate existing data from DB2 to new Oracle schema