We have two existing application; one in sql server database and another in oracle database. We need to integrate these two application into one. Target database would be oracle. New application is totally new system and contains whole bunch of new screens, tables, functions, procedures. New application is ready and we are testing it on sample data.
My job is to convert data from existing systems (sql server and oracle) to new system.I know that I have to write data mapping tables and scripts to load data to new system.
Please advise me what are the best practices to perform this task. Thanks in advance.........