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|
Release Notes: The timestamp datatype (including auto-generation of an Oracle trigger) is now supported, as well as some bigint and tinyint datatypes.
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.
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 firstname.lastname@example.org.
Release Notes: Initial release.