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 | Database Software Development Code Generators Database Engines/Servers |
|---|---|
| Licenses | GPL |
| Implementation | Perl |
Recent releases
- 24 Apr 2001 13:04
Release Notes: The timestamp datatype (including auto-generation of an Oracle trigger) is now supported, as well as some bigint and tinyint datatypes.
- 30 Jan 2001 06:13
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.
- 30 Jan 2001 06:13
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.
- 30 Jan 2001 06:13
Release Notes: Initial release.
Recent comments
?
> 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
Fixed now!
Thanks!
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...
not-available
02 Aug 2000 23:26
Heartbeat
- Popularity Score
- 42.07
- Vitality Score
- 2.06
- Subscriptions
- 5
