Home > Documentation > MS Access to Oracle
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:
Table_1
Table_2
...
Table_N
Notes: