Hi
I need to migrate a MySQL database 5.6.13 (community edition) to Oracle 11.2.0.7. Both the MySQL and Oracle instances are running in amazon RDS.
The MySQL DB is 1287GB so its a fair size, which is part of the rationale in exploring Oracle.
Does anybody have an tips or tools that they can recommended ? The Oracle instance has 1500GB available storage so I need to do any migration from one db straight to the other, as I don't have capacity for a staging area.
I have seen that SQL developer has the DB migration workbench, does anyone have any experience on this, would it be able to manage migrating a terabyte sized database ?
Any help would be greatly appreciated
Daniel