Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Chicago
    Posts
    54

    Unanswered: Migration from Oracle to MySQL

    I need to do a migration from Oracle to MySQL. The problem is that I have tables in several oracle schemas and my applications are coded like this:

    SELECT * FROM SCHEMA1.TABLEA join SCHEMA2.TABLEB

    How should I handle the migration? Should I create a mysql database for each of my oracle schema? How does this effect the java code?

    Thanks.

  2. #2
    Join Date
    Mar 2004
    Posts
    16

    Re: Migration from Oracle to MySQL

    This is one posibility... If you want you can just find and replace the schema... But this is a small problem... If you have dates on you select you'll have to convert them. You might have some problem converting numbers as well (unless all your numbers transfered into a single type in mysql).
    Good luck

  3. #3
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: Migration from Oracle to MySQL

    Originally posted by jin007
    I need to do a migration from Oracle to MySQL. The problem is that I have tables in several oracle schemas and my applications are coded like this:

    SELECT * FROM SCHEMA1.TABLEA join SCHEMA2.TABLEB

    How should I handle the migration? Should I create a mysql database for each of my oracle schema? How does this effect the java code?

    Thanks.
    Should I create a mysql database for each of my oracle schema? - This is first option.

    The second option is change your data model but i think you want not this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •