Command line version of Oracle to MySQL converter

For automation purposes Oracle to MySQL converter includes console version called O2SAGENT.EXE. Find this file in the installation folder. The console version of Oracle to MySQL converter can be run directly from command line or called from any script. O2SAGENT.EXE supports the following parameters:

--case_sense		make all CHAR and VARCHAR fields case sensitive
--charset=...		MySQL character set
--dest=...		MySQL database or dump file name
--dump		convert Oracle database into dump file
--engine=...		MySQL storage engine (MyISAM, MEMORY, InnoDB, BerkeleyDB, ARCHIVE, FEDERATED, etc). Please refer to MySQL documentation for the further information.
--help		display help message and exit
--logfile=...		path to the logfile where execution traces will be written
--mode=...		how to process an existing MySQL database (0 - overwrite the entire database, 1 - overwrite existing tables only, 2 - skip existing tables, 3 - merge, 4 - synchronize)
--mysqlh=...		MySQL server IP address or network name
--mysqlu=...		MySQL user name
--mysqlp=...		MySQL user password
--myport=...		MySQL port
--oraclh=...		Network name or IP address of Oracle server
--oraclu=...		Oracle user name
--oraclp=...		Oracle user password
--oraport=...		Oracle port
--profile=...		path to the file to load conversion settings from
--silent		use this option to disable program output
--skip_idx		skip converting indexes
--src=...		Oracle database name
--tab_def		convert table definitions only
--tab_file=...		name of the file containing table names to convert (one table name per line)
--view_owned		work with tables owned by the specified Oracle user only

In the following example the program converts Oracle database "db1" into MySQL database "db1_from_oracle" on the remote MySQL server "mysqlhost":

O2SAGENT.EXE --src=db1 --dest=db1_from_oracle --mysqlh=mysqlhost --mysqlu=administrator 
--mysqlp=the_passsword --oraclh=localhost --oraclu=scott --oraclp=tiger

Table names file should be formatted as follows:

Table_1 Table_2 ... Table_N

Notes:

If you specified a profile, there is no need to specify any other parameters
You can omit 'mysqlh' to connect local database server
It is necessary to specify 'myport' parameter only if it differs from the default MySQL port 3306
It is necessary to specify 'oraport' parameter only if it differs from the default Oracle port 1521
If you omit 'tab_file' parameter, all database tables will be converted
If you omit 'mode' parameter, default mode 'overwrite the entire database' will be used
Command line parameters that contain spaces should be enclosed in quotes (for example --dest="my database")

MySQL character sets

This parameter specifies correct encoding of text values in the destination MySQL database. It can have one of the following values:

value	Description	value	Description
big5	Big5 Traditional Chinese	dec8	DEC West European
cp850	DOS West European	hp8	HP West European
koi8r	KOI8-R Relcom Russian	latin1	cp1252 West European
latin2	ISO 8859-2 Central European	swe7	7bit Swedish
ascii	US ASCII	ujis	EUC-JP Japanese
sjis	Shift-JIS Japanese	hebrew	ISO 8859-8 Hebrew
tis620	TIS620 Thai	euckr	EUC-KR Korean
koi8u	KOI8-U Ukrainian	gb2312	GB2312 Simplified Chinese
greek	ISO 8859-7 Greek	cp1250	Windows Central European
gbk	GBK Simplified Chinese	latin5	ISO 8859-9 Turkish
armscii8	ARMSCII-8 Armenian	utf8	UTF-8 Unicode
ucs2	UCS-2 Unicode	cp866	DOS Russian
keybcs2	DOS Kamenicky Czech-Slovak	macce	Mac Central European
macroman	Mac West European	cp852	DOS Central European
latin7	ISO 8859-13 Baltic	cp1251	Windows Cyrillic
cp1256	Windows Arabic	cp1257	Windows Baltic
binary	Binary pseudo charset	geostd8	GEOSTD8 Georgian
cp932	SJIS for Windows Japanese	eucjpms	UJIS for Windows Japanese

Please refer to MySQL documentation to better understand the concept of character sets and collations.