Re: mysql -> Oracle
Date: Wed, 30 Apr 2008 21:41:30 +0100
In article <Xns9A8C8168CD02anacedenthotmailcom_at_18.104.22.168>, Ana C. Dent says...
> If I was given this task I'd write a simple PERL program to move the data
> from MYSQL to Oracle.
Different servers, different providers. Ideally we'll just find a simple method of "exporting" the MySQL schema as DDL scripts whichy are oraclecompatible and likewise a set of insert statements per table, again oracle-friendly.
> Do you have any MYSQL datatypes that do not cleanly map to Oracle?
Not sure at the moment - haven't had sight of the MySQL schema. We are only going to load the data into a holding schema and then run transformations to load into our application tables.
-- jeremyReceived on Wed Apr 30 2008 - 15:41:30 CDT