Online Documentation


Project overrides

To allow extra flexibility when using Full Convert as a batch processing tool, we added command line switches to control most parts of the project information.

Complete list of available overrides

 

We have listed all overrides as they are applied for the source connection. Target connection parameters are applied in the same way, except that the "source/" prefix should be replaced by "dest/" prefix.

(global)

tables_to_process (semicolon separated list of tables to process)

 

Access

source/filename

source/password

source/sysdb_filename

 

DBF

source/folder

 

Delimited text

source/folder

source/HDR (boolean value Y/N telling if first record specifies column names)

source/separator

 

Excel

source/filename

source/HDR (boolean value Y/N telling if first record specifies column names)

 

Interbase/Firebird

source/server

source/database

source/username

source/password

 

MySQL

source/server

source/database

source/username

source/password

source/port

 

ODBC

source/dsn

source/odbc_user

source/odbc_password

source/odbc_compatible

 

Oracle

source/server (this is Oracle service name, defined in TNSNAMES.ORA file - or database name if we go direct route, described below)

source/username

source/password

source/authmode (possible choices are Normal, SYSDBA, SYSOPER)

source/direct (boolean value Y/N telling if we will access Oracle server directly via TCP/IP, ignoring Oracle Client Interface completely)

source/net_server (server address if we use direct access)

source/net_port (integer value defining server port if we use direct access)

 

Paradox

source/folder

 

SQL Server

source/server

source/database

source/username

source/password

source/windows_authentication (boolean value Y/N telling if we want to use Windows authentication instead of username/password)

 

XML

source/folder

 

Usage examples

 

We have listed all overrides as they are applied for the source connection. Target connection parameters are applied in the same way, except that the "source/" prefix should be replaced by "dest/" prefix.

fullconvert.exe c:\db\xls2ora.fcs -override source/filename=c:\DB\Excel\fname.xls -override tables_to_process=sheet1$;sheet3$ -override dest/server=oradbname

 

As a list of overrides can grow, it is possible to specify a single option specifying the overrides defining text file

fullconvert.exe c:\db\xls2ora.fcs -override_file c:\db\overrides.txt

 

Where overrides.txt would contain:

source/filename=c:\DB\Excel\fname.xls

tables_to_process=sheet1$;sheet3$

dest/server=oradbname