Exporting to a Database from the Command Shell

To export data from the command shell, create the export format for the external database.

For further details, see Defining an Export Format for an External Database. If the export format is already defined then you can find them in the FT infoarea.

Executing a single Export

If you wish to override the connection details of the external database defined in the export format, then keep the new connection details ready.

To execute a single format from the command line use the following command:

mmim.exe -e -u <User> -p <Password> -f “<Format Name>”

If there are any errors they are displayed on the console. For example:

Error 509: ‘No import/export fields defined

Executing a batch of exports

To execute a series of exports sequentially:

Create a text file with the sequence of export jobs one per line. See the sample batch.txt file below:
```
-f export2db_Company
-f export2db_Activties
-f export2db_Person
```

Run the following command:

mmim.exe -u <User> -p <Password> -s c:\windows\batch.txt

Overriding the Connection Details

To override the connection details saved in the export format file, explicitly provide the connection details on the command, see the following sample command:

mmim.exe -e -u <User> -p <Password> -f “AUREASPECS-1210 valid” --DBconn <DB connection> 
--DBpass <DB password> --DBname <DB name> --DBtable <DB table>

Where <DB connection>, <DB password>, <DB name>, <DB table> are the values that override the corresponding connection parameter values saved in the export format.