Command Line
To perform batch conversion or call conversion procedure from an automation script you can use console version of Access-to-Oracle called 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 service name |
| --help |
display help message and exit |
| --logfile=... |
path to the logfile where execution traces will be written |
| --merge |
merge data into an existing database |
| --oraclu=... |
Oracle user name |
| --oraclp=... |
Oracle user password |
| --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 |
| --uppercase |
make table/field names uppercase |
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:
- The default mode is 'overwrite'. You can change it using '--mode' parameter
- If you omit 'tab_file' parameter, all database tables will be converted
- Command line parameters that contain spaces should be enclosed in quotes (for example --dest="my database")
| 
