Home > Documentation > OraDump to MySQL

Command line version of OraDump to MySQL converter

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

In the following example the program converts Oracle dump file "c:\db1.dat" into MySQL database "db1_from_oracle" on the remote MySQL server "mysqlhost":

OD2SAGENT.EXE --src=c:\db1.dat --dest=db1_from_oracle --mysqlh=mysqlhost --mysqlu=administrator 
--mysqlp=the_passsword 

Table names file should be formatted as follows:

Table_1
Table_2
...
Table_N


Notes:

1. You can omit 'mysqlh' to connect local database server
2. It is necessary to specify 'port' parameter only if it differs from the default MySQL port 3306
3. If you omit 'tab_file' parameter, all database tables will be converted
4. If you omit 'mode' parameter, default mode 'overwrite the entire database' will be used
5. 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:

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