From:       To:      

Home > Documentation > MS Access to Oracle

Command line version of MS Access to Oracle converter

To perform batch conversion or call the conversion procedure from an automation script you can use console version of Access-to-Oracle A2OAGENT.EXE. Find this file in Access-to-Oracle installation folder. You can either run this tool directly from command line or call it from any script as well. The program supports the following command-line options:

--accp=...   MS Access database password
--dest=...   Oracle database name
--help   display help message and exit
--logfile=...   path to the logfile where execution traces will be written
--mode=...   how to process tables that already exist in Oracle database (1 - overwrite, 2 - skip, 3 - merge, 4 - synchronize)
--oraclh=...   Network name or IP address of Oracle server
--oraclu=...   Oracle user name
--oraclp=...   Oracle user password
--port=...   Oracle port
--profile=...   path to a profile to load conversion settings from
--silent   use this option to disable program output
--skip_idx   skip converting indexes
--src=...   MS Access database name
--sysdb=...   path to MS Access workgroup information file (*.mdw)
--tab_def   convert table definitions only
--tab_file=...   name of the file containing table names to convert (one table name per line)
--uglu=...   user name for MS Access user-level security
--uglp=...   password for MS Access user-level security

In the following example the program converts local MS Access database "c:\db1.mdb" into Oracle database "db1 from msaccess" using table names file "c:\tabfile1.txt":

A2OAGENT.EXE --src=c:\db1.mdb --dest="db1 from msaccess" --oraclu=administrator 
--oraclp=the_passsword --tab_file=c:\tabfile1.txt

Table names file should be formatted as follows:



  1. If you specified a profile, there is no need to specify any other parameters
  2. It is necessary to specify 'port' parameter only if it differs from the default Oracle port 1521
  3. The default mode is 'overwrite'. You can change it using '--mode' parameter
  4. If you omit 'tab_file' parameter, all database tables will be converted
  5. Command line parameters that contain spaces should be enclosed in quotes (for example --dest="my database")