![Migrate webapp from DB2 to ORACLE](https://www.dynamicpuzzle.ro/wp-content/uploads/projects/dataase-independent-724x1024.jpg)
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