title: MySQL to Oracle DB Migration
body: <p>I have a task to Migrate MySQL DB to Oracle (its my requirement) i tried to Migrate using SQL developer as defined in below link. </p>
  
  <blockquote>
    <p><a href="https://www.packtpub.com/books/content/migrating-mysql-table-using-oracle-sql-developer-15" rel="nofollow">https://www.packtpub.com/books/content/migrating-mysql-table-using-oracle-sql-developer-15</a></p>
  </blockquote>
  
  <p>As the DB is huge, the constraints are not copied properly from MySQL to Oracle, i need to define/alter/add constraints explicitly, which is time consuming (SQL developer migrates data 300rec/min from mysql to Oracle) &amp; the entire procedure, views, functions is need to re write. </p>
  
  <ol>
  <li>How can i ensure that data has migrated properly or not.?  </li>
  <li>Is this is a right approach to migrate?  </li>
  <li>Should i move to any tool which helps to Migrate? If yes please suggest the     tool..!! </li>
  <li>Or it is the right thing to Move from MySQL to Oracle.</li>
  </ol>
  
  <p>Thanks in Advance.</p>