2 Replies Latest reply: Apr 22, 2014 9:12 AM by Mkirtley-Oracle RSS

    Migration from Mysql to Oracle

    543516

      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