How to develop a secure database migration software? [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit 开发者_开发问答the help center. Closed 11 years ago.

I want to develop a secure database migration software. My objective is the software must be able to migrate data from an Oracle 11g database to a MySQL database. I know Java and would like to do in that.

---

You'll need to develop an application to read Oracle database structure, identifying tables, views, constraints, etc and their structures (types, null-ability, lengths, etc) translating that to your target database platform. First phase should be DDL migration.

After that, you must read all source data and import it to target database. Consider scenarios like keeping source records IDs. Second phase should be DML migration.

Notice not all database objects are simple to migrate. For instance, stored procedures could contains code targeting specifically that Oracle database and should be translated manually.