Projects / m2o.pl

m2o.pl

m2o.pl is a Perl script that takes a mysqldump input file and outputs it in Oracle-compatible create syntax. It is extremely useful for one-time MySQL to Oracle migrations, and also for setup of ongoing interfaces between MySQL and Oracle.

Tags
Licenses
Implementation

Recent releases

  •  24 Apr 2001 17:04

    Release Notes: The timestamp datatype (including auto-generation of an Oracle trigger) is now supported, as well as some bigint and tinyint datatypes.

    •  05 Dec 2000 19:31

      Release Notes: An important, new feature to transmogrify MySQL "autoincrement" columns into automatically-generated create sequence and create trigger statements that duplicate the functionality. This is an important feature because the lack of autoincrement columns in Oracle is a significant stumbling block for MySQL experts new to Oracle.

      •  09 Aug 2000 14:17

        Release Notes: This release fixes a host of bugs and adds a variety of new features, including user-configurable settings for re-writing of illegal keywords in Oracle and re-engineered index naming conventions (now table_name_index_name# where # is sequential for uniqueness). Please contribute a test suite consisting of a complete, complex mysql schema with as many tables/indexes as possible to vallee@pythian.com.

        •  03 Aug 2000 05:49

          Release Notes: Initial release.

          Recent comments

          27 Sep 2001 14:38 xanuda

          ?

          > Thanks!


          Hi. I have downloaded the product and ran it the way it says in the README:

          perl m2o < dumprile1 > orafile.

          But for some reason the script didn't replace the
          int or smallint types as well as the TYPE=ISAM clause in the create table statement. Am I doing something incorrectly?

          thanks

          06 Dec 2000 14:40 dcolling

          Fixed now!
          Thanks!

          06 Dec 2000 14:24 dcolling

          Whoops - wrong data!
          This appears to be broken. It delivers a an "ls" listing, not
          a gz file.

          I'd actually like to use it...

          Screenshot

          Project Spotlight

          OpenStack4j

          A Fluent OpenStack client API for Java.

          Screenshot

          Project Spotlight

          TurnKey TWiki Appliance

          A TWiki appliance that is easy to use and lightweight.