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
- create development and test environment