title: Tools for Migrating from Oracle to MySQL
body: <p>I want to migrate schema from Oracle to MySQl, so are there any free tools that would be useful for this task?</p>
  
  <p>I have "Create table" statements in Oracle SQL Script, but it contains unique constraints and a foreign key. MySQL has MyISAM storage engine, and so foreign key is not supported.</p>
  
  <p>How to solve this issue?</p>
  
  <p>Sample Oracle create statements:</p>
  
  <pre><code>   CREATE TABLE channels 
  (
    obt_id            NUMBER(19) PRIMARY KEY,
    discriminator     VARCHAR2(64) NOT NULL
                      CONSTRAINT check_channel_discriminator CHECK (discriminator IN ('CHANNEL','SALES_CHANNEL')),
    chan_id           VARCHAR2(255),
    description       VARCHAR2(255),
    name              VARCHAR2(255) NOT NULL,
    obt_version       VARCHAR2(255),
    fk2_channel       NUMBER(19)
                      CONSTRAINT fk_channel_channel REFERENCES channels(obt_id)
  );
  
  CREATE TABLE object_types 
  (
    obt_id                    NUMBER(19) PRIMARY KEY,
    enum_value                VARCHAR2(64) NOT NULL,
    external_name             VARCHAR2(64) NOT NULL,
    description               VARCHAR2(255),
    business_validation       NUMBER(1) DEFAULT 0,
    start_date_time           DATE DEFAULT to_date('01011900','DDMMYYYY'),
    end_date_time             DATE DEFAULT to_date('01014712','DDMMYYYY'),
    mut_date_time             DATE DEFAULT SYSDATE,
    mut_user                  VARCHAR2(32) DEFAULT USER,
    CONSTRAINT                object_types UNIQUE (external_name,start_date_time,end_date_time)
  );
  </code></pre>