mSQL to Oracle and Vice Versa

Note that DDL is Different

mSQL	Oracle
create table foo( anInt int, aString char(20))\g	CREATE TABLE FOO( ANINT INT, ASTRING VARCHAR2(20));

mSQL is case sensitive
mSQL uses \g as terminator, Oracle uses ;
mSQL is smaller subset of SQL-92
- no views
- no varchar
- no blobs
- no internal functions like count(*)

mSQL to Oracle

msqlexport myDatabase myTable > myDataFile

sqlload myName/myPassword myDataFile.ctl

#file myDataFile.ctl, an oracle sqllload control file

load data
infile 'myDataFile'
badfile 'example.bad'
discardfile 'example.dsc'
discardmax 999
append
into table myTable
fields terminated by ',' optionally enclosed by "'"
(myField1,myField2,myField3,myField4)

Oracle to mSQL

ascii_dump.pl -u myName -p myPassword -s 'select * from myTable ' > aDataFile
cat aDataFile | msqlimport myDatabase myTable