Exportizer Users' Guide vlsoftware.net

Command Line Usage

Contents Index Previous Next
This topic describes parameters of Exportizer command line. You can use them to specify actions, which must be performed by the program when it starts. Using command line parameters, you can launch Exportizer and force it to execute your tasks from your own applications, command files etc. More detailed information about specific export options can be found here.

Before you start...

Advanced users can build the needed command line manually using the specification below. But if you are a beginner or just need to create a command line for simple export operation, you can save your time using Exportizer command line builder. The command line builder interface is very similar to Export dialog and uses the same export options, but it produces a command line string instead of running export operation. To generate a command line, open a database, which you want to export via the command line, then select needed options using the corresponding menu(s), and choose 'Export | Generate Command Line...' menu or click the corresponding button. In 'Generate command line...' window, specify needed export options and click OK. A new window will appear with the command line generated. Copy it, correct it if it is needed, and use in Exportizer calls from your own programs, .bat files etc.

Please note that the command line builder cannot generate any type of command line. It produces only generic command lines which is enough for the most of needs and good point to start from. Generated command line can be easily changed manually for more complex tasks. For example, you need just replace /export switch with /copy switch when you want to copy data to clipboard instead of export them; replace the table name with asterisk if you want to export all tables from a specified database, and so on. Also, command line builder cannot generate command lines which use SQL features like specifying a file with SQL text, providing list of SQL parameters or macros etc.; you can easily add these parameters manually.

More details about some options can be found in Exporting Data topic.

Important notes:

1. Command line syntax. You must precede all options (unless otherwise noted) with either a dash (-) or a slash (/). The options are case insensitive.

2. Ancillary characters in specification. In the specification below, the switches and parameters or their parts, enclosed in square brackets [], are optional, and the switches and parameters, enclosed in arrow brackets <>, are required. Symbol | separates exclusive switches (which cannot be used together) or possible values for some switches. Attention! It is strongly not recommended to use these characters inside parameters of your command line.

3. Special highlighting in specification. In the specification below, possible values for some parameters or explanation of the values are color-highlighted. Switches, parameters, and values, which can be used only in Exportizer Pro, are highlighted by brown color. Switches and parameter names are highlighted by bold font.

4. File names in parameters. It is recommended to use full file names in all parameters where file names are used.

Usage (specification):

Long (classic) format:
  Exportizer:
    Show parameres in a vertical list exptizer.exe [/e[xport] | /c[opy]] [/ExportMode=CREATE_OR_REPLACE+INSERT|CREATE_OR_REPLACE|EMPTY+INSERT] [/ExportType=TEXT|HTML|XML|RTF|PDF|EXCEL|EXCELOLE|WORDOLE|SYLK|DBF|SQL] [/filter=FilterCondition] [/FilterSensitive] [/FilterPartial] [/sort=Field1,Field2,...] [/CloseWhenDone] [/SuppressOverwriteOrDeletePrompt] [/minimize] [/OpenTarget] [/[Include]Memo] [/[Include]ColNames] [/FixedFieldLength] [/separator=;|,| |#9|...] [/DelimitAllFields] [/DocTitle=DocumentTitle] [/AlternateRowColor=Color] [/TargetImageFormat=PNG|JPEG|GIF|Bitmap|Metafile|Icon|<SOURCE>] [/AddDDL] [/sqlSeparator=;|^|sqlplus|#10|...] [/TargetDBType=Access|Oracle|SQLServer|LocalSQL|Interbase|Firebird|...] [/sqlTableName=TableName] [/sqlStatementType=INSERT|MERGE|UPDATE|DELETE] [/KeyFields=KeyFields] [/textSchema=standard|ado|bde] [/xmlUseCDataAttr] [/xmlSchema=ado|standard|simple|xsl] [/encoding=Windows-1252|...] [/dbfVersion=3|4|5] [/LimitRecordCount=100|...] [/RecordsPerLine=1|2|...] [/LineTerminator=WINDOWS|UNIX] [/FieldMappingsFile=FieldMappingsFileName] [/FieldMappings=Source1=Target1;Source2=Target2;...] [/columns=column1;column2;...] [/SrcDBInterface=ado|bde|interbase] [/SrcDBPassword=Password] </SrcDB=SourceFileName> [/TrgDB=TargetFileName]
  Exportizer Pro:
    Show parameres in a vertical list exptizer.exe [/silent] [/e[xport] | /c[opy]] [/ExportMode=CREATE_OR_REPLACE+INSERT|CREATE_OR_REPLACE|APPEND|EMPTY+INSERT] [/ExportType=TEXT|HTML|XML|RTF|PDF|EXCEL|EXCELXLSX|EXCELXML|EXCELOLE|WORDOLE|SYLK|DBF|SQL|DATABASE] [/filter=FilterCondition] [/FilterSensitive] [/FilterPartial] [/sort=Field1,Field2,...] [/CloseWhenDone] [/CloseOnError] [/LogFile=LogFileName] [/AppendLog] [/SuppressOverwriteOrDeletePrompt] [/minimize] [/OpenTarget] [/[Include]Images] [/[Include]Memo] [/[Include]ColNames] [/FixedFieldLength] [/separator=;|,| |#9|...] [/DelimitAllFields] [/CreateIndexFile] [/TemplateFile=TemplateFileName] [/ExportStepNo=1|2|...] [/DocTitle=DocumentTitle] [/AlternateRowColor=Color] [/TargetImageFormat=PNG|JPEG|GIF|Bitmap|Metafile|Icon|<SOURCE>] [/AddDDL] [/sqlSeparator=;|^|sqlplus|#10|...] [/TargetDBType=Access|Oracle|SQLServer|LocalSQL|Interbase|Firebird|...] [/sqlTableName=TableName] [/sqlStatementType=INSERT|MERGE|UPDATE|DELETE] [/KeyFields=KeyFields] [/textSchema=standard|ado|bde|expr] [/TextExpression=Expression] [/xmlUseCDataAttr] [/xmlSchema=ado|standard|simple|xsl] [/encoding=Windows-1252|...] [/dbfVersion=3|4|5] [/LimitRecordCount=100|...] [/RecordsPerLine=1|2|...] [/RowsPerSheet=65536|...] [/FloatFormat=0.0000|...] [/DateTimeFormat=mm/dd/yyyy|...] [/LineTerminator=WINDOWS|UNIX] [/CommitInterval=100|...] [/MemorySaving] [/UseSQLParameters] [/FieldMappingsFile=FieldMappingsFileName] [/FieldMappings=Source1=Target1;Source2=Target2;...] [/columns=column1;column2;...] [/TableMappingsFile=TableMappingsFileName] [/SrcDBInterface=ado|bde|interbase] [/SrcDBKind=DBKind] [/SrcDBDriver=DBDriver] [/SrcDBUserName=UserName] [/SrcDBPassword=Password] [/SrcTableName=TableName] [/SrcSQLFile=SQLFileName] [/SQLParamNames=ParamName1%#%ParamName2%#%...] [/SQLParamValues=ParamValue1%#%ParamValue2%#%...] [/SQLParamTypes=ParamType1%#%ParamType2%#%...] [/SQLMacroNames=MacroName1%#%MacroName2%#%...] [/SQLMacroValues=MacroValue1%#%MacroValue2%#%...] </SrcDB=SourceFileOrDBName> [/TrgDBInterface=ado|bde|interbase] [/TrgDBKind=DBKind] [/TrgDBDriver=DBDriver] [/TrgDBUserName=UserName] [/TrgDBPassword=Password] [/TrgTableName=TableName] [/TrgDB=TargetFileOrDBName]
     
Short format (parameters are excluded from the command line and included in the action file):
  Exportizer:
    Show parameres in a vertical list exptizer.exe [/ParamsFile=ActionFileName]
  Exportizer Pro:
    Show parameres in a vertical list exptizer.exe [/silent] [/ParamsFile=ActionFileName]

Examples:

1. Open a dBase file
exptizer.exe "c:\my db\customer.dbf"

2. Open an Interbase database (Exportizer Pro only)
exptizer.exe /interbase "MyServerName:C:\Data\maindb.gdb"

3. Open a PostgreSQL database (Exportizer Pro only)
exptizer.exe /ado "<CONSTR>DSN=PostgreSQL30;UID=postgres;"

4. Export .dbf -> .htm
exptizer.exe /export /encoding=Windows-1252 "SrcDB=c:\my db\customer.dbf" "TrgDB=c:\my db\customer.htm"

5. Export .dbf -> .rtf
exptizer.exe /export /IncludeMemo /exporttype=RTF "/sort=payername,paymentsum DESC" /SrcDBInterface=ado "SrcDB=c:\my db\dbdesrc.dbf" "TrgDB=c:\my db\dbdescr.rtf"

6. Export .db -> .htm
exptizer.exe /export /ExportType=HTML "/sort=serviceid, 4, 5" /columns=SERVICENAME;DESCR;PRICE "SrcDB=c:\my db\advert.db" "TrgDB=c:\my db\services.htm"

7. Export all .dbf files from directory to .txt files (Exportizer Pro only)
exptizer.exe /export /ExportType=TEXT /separator=#9 "/filter=BillSum > 200 and Name <> 'Parker'" "SrcDB=c:\data\" "SrcTableName=<MASK>*.dbf" "TrgDB=c:\targets\" "TrgTableName=<MASK>*.txt"

8. Export one table from .mdb file to .htm (Exportizer Pro only)
exptizer.exe /export /SrcDBPassword=leo12 "SrcDB=c:\my db\stores.mdb" "SrcTableName=price" "TrgDB=c:\my db\price.htm"

9. Export all tables from .mdb file to .htm files in silent mode (Exportizer Pro only)
exptizer.exe /silent /export /SrcDBPassword=leo12 "SrcDB=c:\my db\stores.mdb" "SrcTableName=*" "TrgDB=c:\my db\" "TrgTableName=*.htm"

10. Export .db -> .dbf V (e.g. Paradox to dBase 5)
exptizer.exe /export /ExportType=DBF /dbfVersion=5 "/encoding=DBASE DEU CP437" "SrcDB=c:\my db\types.db" "TrgDB=c:\my db\types.dbf"

11. Export a table from Oracle database to Access database in silent mode with writing results to a log file. The target file must exist.
exptizer.exe /silent /export /ExportType=DATABASE /ExportMode=REPLACE+INSERT /IncludeMemo /CommitInterval=200 /SrcDBInterface=ado /SrcDBKind=CONSTR /SrcDBDriver=ORACLE "/SrcDB=Provider=OraOLEDB.Oracle.1;Data Source=dwh;" /SrcDBUserName=stage /SrcDBPassword=stage_password /SrcTableName=USR_REQUEST /TrgDBInterface=ado /TrgDBKind=FILE "/TrgDBDriver=Microsoft Access" /TrgDB=C:\DWH\Requests.mdb /TrgTableName=USR_REQUEST /LogFile=C:\DWH\Log\export_req.log /AppendLog

12. The same as the previous one but exporting SQL query result instead of a table (differences with previous one are highlighted by bold font)
exptizer.exe /silent /export /ExportType=DATABASE /ExportMode=REPLACE+INSERT /IncludeMemo /CommitInterval=200 /SrcDBInterface=ado /SrcDBKind=CONSTR /SrcDBDriver=ORACLE "/SrcDB=Provider=OraOLEDB.Oracle.1;Data Source=dwh;" /SrcDBUserName=stage /SrcDBPassword=stage_password /SrcSQLFile=C:\DWH\Payments.sql /TrgDBInterface=ado /TrgDBKind=FILE "/TrgDBDriver=Microsoft Access" /TrgDB=C:\DWH\Requests.mdb /TrgTableName=PAYMENTS /LogFile=C:\DWH\Log\export_req.log /AppendLog

13. Export all tables from ODBC data source to .mdb file (Exportizer Pro only). The target file must exist.
exptizer.exe /export /ExportType=DATABASE /IncludeMemo /SrcDBInterface=ADO /SrcDBPassword=m980 "SrcDB=<DSN>BOOKS" "SrcTableName=<MASK>*" /TrgDBInterface=ADO /TrgDBKind=FILE /TrgDBDriver=Access "/TrgTableName=<MASK>*" TrgDB=c:\MyBooks.mdb

14. The same as the previous one but using an action file
exptizer.exe "/ParamsFile=c:\ExportizerStartParameters.txt"

The contents of c:\ExportizerStartParameters.txt file should be like the following:

;action
/export

;options

/IncludeMemo

;source definition
/exporttype=DATABASE
/SrcDBInterface=ADO
/SrcDBPassword=m980
/SrcDBKind=DSN
/SrcDB=BOOKS
/SrcTableName=<MASK>*

;target definition
/TrgDBInterface=ADO
/TrgDBKind=FILE
/TrgDBDriver=Access
/TrgDB=c:\MyBooks.mdb
/TrgTableName=<MASK>*

Description of the options:

Option Description

/SrcDB

(required option)

Specifies name of source database to open. This can be a file name, folder name, ODBC DSN, or connection string (the last three database kinds are available in Exportizer Pro only). In some simple cases (for example, opening a file without exporting) 'SrcDB=' prefix can be omitted to shorten the resulting command (see example 1). If the name includes spaces, entire parameter must be enclosed in quotes. If the name is an ADO connection string with quotes inside, it is recommended to use the short format of command line (using the parameters file).

If /SrcTableName is omitted, it is recommended to use a prefix specifying the database kind (file, folder, ODBC DSN, connection string) in the name of the source database. The prefix must be enclosed in arrow brackets <>. Possible values: <FILE>, <FOLDER>, <DSN>, <CONSTR>. It is recommended to enclose the entire parameter in quotes in such cases. See example 13.

/silent This switch will run the program in "silent" mode (Exportizer Pro only), without any windows (except purchase reminder in Exportizer Pro when the program is used without registration after the test period). When using /ParamsFile option, /silent switch must be outside parameters (action) file. The Exportizer Pro returns an exit code of 0 if the working was successful, and 1 in case of error. Attention! There are no overwrite or other prompts in this mode.
/ParamsFile Specifies the name of the action file, which contains command line parameters, one parameter per line. Lines with a semicolon at the beginning are ignored as comments. Blank lines are allowed. When using this option, there should not be other command line parameters in the command line except /silent switch. If the file name includes spaces, entire parameter must be enclosed in quotes. See example 14.
/SrcDBInterface Specifies database interface (database engine) used to connect the source database. Possible values: ADO, BDE, INTERBASE. If not specified, the program will use ADO.
/SrcDBKind Specifies source database kind (Exportizer Pro only). Possible values: FOLDER, FILE, DSN, CONSTR; the last one must be used only for ADO interface (see /SrcDBInterface description). If not specified, the program will try to detect it automatically.

Instead of using this parameter, it is possible to use a prefix specifying the database kind (file, folder, ODBC DSN, connection string) in the /SrcDB parameter. The prefix must be enclosed in arrow brackets <>. Possible values: <FILE>, <FOLDER>, <DSN>, <CONSTR>. It is recommended to enclose the entire parameter in quotes in such cases. See example 13.

/SrcDBDriver Specifies source database driver (Exportizer Pro only). Examples of possible values: ACCESS, DBASE, INTERBASE, FIREBIRD, ORACLE, SQL SERVER, etc. If not specified, the program will try to detect it automatically. If the driver name includes spaces, entire parameter must be enclosed in quotes.
/SrcDBUserName User name to connect source SQL database (Exportizer Pro only). If the user name includes spaces, entire parameter must be enclosed in quotes.
/SrcDBPassword Password to connect source Paradox or SQL database. If the password includes spaces, entire parameter must be enclosed in quotes.
/SrcTableName

Specifies a source table name to open (Exportizer Pro only). If this parameter is omitted and the source is file, the program will try to extract it from /SrcDB. If the name includes spaces, entire parameter must be enclosed in quotes. This parameter cannot be used together with /SrcSQLFile parameter.

It can be a file (table) mask or file (table) list instead of a file (table) name to force the program to open and export group of files (tables) consequently. In this case, /TrgTableName must be empty or contain the corresponding mask or list, with one exception: if target format is DATABASE and export mode is APPEND, /TrgTableName can contain only one table (in this case all source table should have compatible field structure). This extended syntax is applicable only if /e[xport] option is used. A <MASK> prefix should be used for masks and a <LIST> prefix should be used for lists (entire parameter must be enclosed in quotes in this case). Lists must be semicolon separated. See examples above.

/SrcSQLFile

Specifies a file name with SQL query to open (Exportizer Pro only). If the name includes spaces, entire parameter must be enclosed in quotes. This parameter cannot be used together with /SrcTableName parameter.

/SQLParamNames Can be used in cases, when /SrcSQLFile contains a parameterized SQL query (Exportizer Pro only). SQL text of parameterized query contains parameter(s) for dynamic replacement; each parameter starts with colon, for example, :ITEMID, :PAYDATE and so on. Use this switch to define a list of parameter names, which should be automatically replaced before the query execution. This list must contain parameter names (the colon must be omitted here) separated by %#% character combination. If the switch contains spaces, it should be enclosed in quotes. This switch must be used in conjunction with /SQLParamValues and /SQLParamTypes switches.
/SQLParamValues List of SQL parameter values separated by %#% character combination (Exportizer Pro only). The number of items in the list and their positions must match the ones from /SQLParamNames switch. To pass null value, text of the value should be NULL (in upper case). If the switch contains spaces, it should be enclosed in quotes.
/SQLParamTypes List of SQL parameter types separated by %#% character combination (Exportizer Pro only). The number of items in the list and their positions must match the ones from /SQLParamNames switch. Available types: Boolean, Currency, Date, DateTime, Float, Integer, SmallInt, String, Time, Word. The switch should not contain spaces.
/SQLMacroNames

Can be used in cases, when /SrcSQLFile contains an SQL query with macros (Exportizer Pro only). SQL text of such queries contains macro(s) for dynamic replacement; each macro starts with << and ends with >>, for example, <<ITEMID>>, <<PAYDATE>> and so on; unlike parameter, macro does not have a type and is always inserted as text. Use this switch to define a list of macro names, which should be automatically replaced before the query execution. This list must contain macro names (separators << and >> must be omitted here; macro name should contain only alphanumeric characters) separated by %#% character combination. The macros are processed before processing of parameters; therefore it is possible to use macros inside parameters. If the switch contains spaces, it should be enclosed in quotes. This switch must be used in conjunction with /SQLMacroValues switch.

/SQLMacroValues List of SQL macro values separated by %#% character combination (Exportizer Pro only). The number of items in the list and their positions must match the ones from /SQLMacroNames switch. If the switch contains spaces, it should be enclosed in quotes.
/filter Filter condition, which must be applied to database after its opening. Filter condition that includes spaces must be enclosed in quotes. See example 7.
/FilterSensitive Specifies that the literal strings in the filter condition for source database are compared to string-valued fields case-sensitively. Ignored, if /filter option is not specified. This option is meaningful only for BDE connections.
/FilterPartial Specifies that the strings in filter condition for source database that end in an asterisk signify a partial string match with the asterisk matching any number of characters. Ignored, if /filter option is not specified. This option is meaningful only for BDE connections.
/sort List of fields (or relative positions of the fields), by which the source database should be sorted. Field names (positions) must be separated by commas. If the list contains spaces, entire parameter must be enclosed in quotes (see example 5). ASC and DESC modifiers can be used. For example, using the switch from example 5 will cause sorting by two fields: by payername (in ascending order) first and then by paymentsum (in descending order).
/e[xport] Use it to export data to file or database.
/c[opy] Use it to copy data to clipboard.

The following options meaningful only if /e[xport] option is used:
/TrgDB

Specifies name of target file or database. This can be a file name, folder name, ODBC DSN, or connection string (the last three database kinds are available in Exportizer Pro only). If the name includes spaces, entire parameter must be enclosed in quotes. If the name is an ADO connection string with quotes inside, it is recommended to use the short format of command line (using the parameters file).

If /TrgTableName is omitted, it is recommended to use a prefix specifying the database kind (file, folder, ODBC DSN, connection string) in the name of the target database. The prefix must be enclosed in arrow brackets <>. Possible values: <FILE>, <FOLDER>, <DSN>, <CONSTR>. It is recommended to enclose the entire parameter in quotes in such cases.

/OpenTarget Forces the program to open target file or table after successful export execution. In multi-table exporting, only the last created target file or table is opened.
/dbfVersion Specifies version (level) for DBF target format. Possible values: 3, 4, 5. If not specified or erroneous, 3 is used.
/TrgDBInterface Specifies database interface (database engine) used to connect the target database for DATABASE export format (Exportizer Pro only). Possible values: ADO, BDE, INTERBASE. If not specified, the program will use ADO.
/TrgDBKind Specifies target database kind for DATABASE export format (Exportizer Pro only). Possible values: FOLDER, FILE, DSN, CONSTR; the last one must be used only for ADO interface (see /TrgDBInterface description). If not specified, the program will try to detect it automatically.

Instead of using this parameter, it is possible to use a prefix specifying the database kind (file, folder, ODBC DSN, connection string) in the /TrgDB parameter. The prefix must be enclosed in arrow brackets <>. Possible values: <FILE>, <FOLDER>, <DSN>, <CONSTR>. It is recommended to enclose the entire parameter in quotes in such cases. See example 13.

/TrgDBDriver Specifies target database driver for DATABASE export format (Exportizer Pro only). Examples of possible values: ACCESS, DBASE, INTERBASE, FIREBIRD, ORACLE, SQL SERVER, etc. If not specified, the program will try to detect it automatically. If the driver name includes spaces, entire parameter must be enclosed in quotes.
/CommitInterval Specifies commit interval (commit frequency) in records for DATABASE and SQL export formats (Exportizer Pro only). If not specified or erroneous, 0 is used.
/MemorySaving Enables memory saving mode for DATABASE export format (Exportizer Pro only). The memory saving mode may be useful when the source or target tables have very large number of records, especially if target interface is ADO. In addition to memory saving, the improvements in performance may be achieved. Notes: This mode may work differently for different target database types/interfaces, therefore it is recommended to test it carefully before using on production systems.
/UseSQLParameters Enables using SQL parameters in memory saving mode for DATABASE export format (Exportizer Pro only). Using parameterized SQL queries can significantly speed up the process and allows to export BLOB data for some database types/interfaces.
/TrgDBUserName Specifies user name to connect target database for DATABASE export format (Exportizer Pro only). If the user name includes spaces, entire parameter must be enclosed in quotes.
/TrgDBPassword Specifies password to connect target database for DATABASE export format (Exportizer Pro only). If the password includes spaces, entire parameter must be enclosed in quotes.
/TrgTableName

Specifies target table name (Exportizer Pro only). If this parameter is omitted and the target is file, the program will try to extract it from /TrgDB. If the name includes spaces, entire parameter must be enclosed in quotes.

It can be a file (table) mask or file (table) list instead of a file (table) name for multi-table exporting. In this case, /SrcTableName must contain the corresponding mask or list. A <MASK> prefix should be used for masks and a <LIST> prefix should be used for lists (entire parameter must be enclosed in quotes in this case). Lists must be semicolon separated. See examples above.

/ExportMode

Specifies export mode. Possible values:

CREATE+INSERT Target is created and filled with incoming rows; if target already exists, export fails.
REPLACE+INSERT Target is created and filled with incoming rows; if target already exists, it is overwritten.
CREATE_OR_REPLACE Blank target (using appropriate structure) is created; if target already exists, it is overwritten.
APPEND

Target is appended with icoming rows; if target does not exists, it is created.

Notes
- This mode is available in Exportizer Pro only.
- This mode can be used only when target format is TEXT, HTML, XML (where XML schema is 'standard' or 'simple'), SQL, or DATABASE.
- The field structure of the source must be compatible with existing target structure.

EMPTY+INSERT

Target is emptied before inserting incoming rows; if target does not exists, it is created.

Notes
- This mode is available in Exportizer Pro only.
- This mode can be used only when target format is DATABASE.
- The field structure of the source must be compatible with existing target structure.

UPDATE

The records in the target that match incoming records, are replaced with incoming records.
/KeyFields are used to match records.

Notes
- This mode is available in Exportizer Pro only.
- This mode can be used only when target format is DATABASE.
- The target must already exist and should have an index defined to match the records.
- The field structure of the source must be compatible with existing target structure.
- The fields in target, used to match the records (key fields of target), are not updated.
- Use this mode carefully when the key fields (either source or target) can contain NULL values.
- Use this mode carefully for multi-table exporting.
- This mode may work differently for different target database types/interfaces, therefore it is recommended to test it carefully (consider to use /MemorySaving option) before using on production systems.

APPEND+UPDATE

The records in the target that match incoming records, are replaced with icoming records. Unmatched incoming records are appended to the target.
/KeyFields are used to match records.

Notes
- This mode is available in Exportizer Pro only.
- This mode can be used only when target format is DATABASE.
- The target must already exist and should have an index defined to match the records.
- The field structure of the source must be compatible with existing target structure.
- Use this mode carefully when the key fields can contain NULL values.
- Use this mode carefully for multi-table exporting.
- This mode may work differently for different target database types/interfaces, therefore it is recommended to test it carefully (consider to use /MemorySaving option) before using on production systems.

DELETE

The records in the target that match incoming records, are deleted.
/KeyFields are used to match records.

Notes
- This mode is available in Exportizer Pro only.
- This mode can be used only when target format is DATABASE.
- The target must already exist and should have an index defined to match the records.
- Use this mode carefully when the key fields can contain NULL values.
- Use this mode carefully for multi-table exporting.
- This mode may work differently for different target database types/interfaces, therefore it is recommended to test it carefully (consider to use /MemorySaving option) before using on production systems.

If not specified, CREATE+INSERT is used.

/SuppressOverwriteOrDeletePrompt Suppresses file/table overwrite prompt for REPLACE+INSERT and CREATE_OR_REPLACE export mode or table emptying prompt for EMPTY+INSERT export mode. This option is ignored in "silent" mode, where such prompts are always suppressed.

The following options meaningful only if /e[xport] or /c[opy] options are used:
/ExportType

Specifies target format. Possible values:

TEXT export to text file (including CSV)
HTML export to HTML document
XML export to XML document
RTF export to RTF file
PDF export to PDF file (binary file)
EXCEL export to Excel workbook (binary file)
EXCELXLSX export to Excel workbook (XLSX) (Exportizer Pro only)
EXCELXML export to Excel workbook (XML-based) (Exportizer Pro only)
EXCELOLE export to Excel workbook using OLE (binary file)
WORDOLE export to Word document using OLE (binary file)
SYLK export to SYLK file
DBF export to dBase table (binary file)
SQL export to SQL Script file
DATABASE export to relational database of any type (Exportizer Pro only)

If this parameter is omitted or erroneous, the program tries to define it from /TrgDB. TEXT format is used by default. DBF, EXCEL and DATABASE target formats should not be used with /c[opy] option due to their binary nature.

/CloseWhenDone Forces the program to close itself after successful export execution. This option is ignored in "silent" mode where the program is closed automatically anyway.
/CloseOnError Forces the program to close itself when error occurs during export execution (Exportizer Pro only). This option is ignored in "silent" mode where the program is closed automatically anyway.
/LogFile Specifies the name of the file to write operation log (Exportizer Pro only). If the name includes spaces, entire parameter must be enclosed in quotes.
/AppendLog Specifies that log of the operations should be written from the end of the log file with saving the previous file content (Exportizer Pro only). If this switch is omitted, existing log file will be fully overwritten.
/minimize Program starts in minimized mode. It is restored to normal mode on error or after ending execution (if /CloseWhenDone switch is not used). This option is ignored in "silent" mode where the program runs without any windows.
/[include]images Specifies either to include graphic data when exporting (Exportizer Pro only). Meaningful only for RTF, PDF, EXCELXLSX, and HTML target formats. Using this option may slow down the export process.
/[include]memo Specifies either to include contents of MEMO (large text) fields when exporting. Without this switch, a constant describing the field type will be used instead of the field contents. Ignored for DBF and DATABASE target formats.
/[include]colnames Specifies either to include field (column) names when exporting. Ignored for DBF and DATABASE target formats.
/FixedFieldLength Specifies that fields in output file have fixed length (without special separators) for TEXT target format. In fixed-length files, field data, which shorter than field width, is completed by spaces. Cannot be used together with /separator option. This option is ignored if /textSchema is expr.
/separator Specifies the field separator for TEXT target format. Сan be any character or character code, followed after # symbol. For example, if you wish to specify a TAB character as the field separator, then /separator=#9 option must be used. If not specified, TAB character is used. This options cannot be used together with /FixedFieldLength switch. This option is ignored if /textSchema is expr.
/TextExpression Specifies the custom expression for TEXT target format when /textSchema is expr.
/textSchema

Specifies the schema for TEXT target format. Possible values:

standard or 0
ado or 1
bde or 2
expr or 3 (Exportizer Pro only)

If not specified, standard (0) is used.

/xmlSchema

Specifies the schema for XML target format. Possible values:

ado or 0 (only for databases, opened by ADO)
standard or 1
simple or 2
xsl or 3

If not specified, standard (1) is used.

/xmlUseCDataAttr Forces the program to use CDATA attribute in text data for XML target format (for simple schema only).
/DelimitAllFields Forces the program to delimit all fields by quotes in target for TEXT target format. If this parameter is omitted, only text fields will be quoted.
/CreateIndexFile Specifies either to create a separate index file for multi-table export for HTML target format (Exportizer Pro only). If this parameter is omitted, the index file will not be created.
/TemplateFile Specifies a template file for HTML target format (Exportizer Pro only). The export procedure will enrich the template file with data from the current dataset and finally save the enriched template as a target file. Note: when using template, all export option will be ignored except template options, document title, and row count limit.
/ExportStepNo Specifies the current export step for HTML target format (Exportizer Pro only). When using template, export can be performed in several steps, and this option lets the program know which dynamic expressions from the template must be calculated during this step.
/DocTitle Specifies document title for HTML target format. If it includes spaces, entire parameter must be enclosed in quotes.
/AlternateRowColor Specifies alternate row color (background color of every second row) for HTML, PDF, EXCELXLSX, EXCELOLE, WORDOLE, and RTF target formats. The color must be specified in hexadecimal format, which is made up of sharp symbol (#), followed by three hex numbers, rr, gg, bb, that give values for red, green and blue, respectively; for example, #FF0000 represents pure red.
/TargetImageFormat Specifies format of target images for HTML target format. Possible values: PNG, JPEG, GIF, Bitmap, Metafile, Icon, <SOURCE>; in the last case, the target images will be created in the format which is determined from the source, i.e. no image format conversion is done.
/sqlSeparator

Specifies SQL command separator for SQL target format. Can be any character or character code, followed after # symbol. There is also a predefined separator, called sqlplus, which is usually used in Oracle SQL Plus utility and other Oracle specific tools and utilities; this is a slash (/) on a separate line between two statements. Default value for sql separator is semicolon (;).

/AddDDL Forces the program to add DDL statement (CREATE TABLE...) into the output script before INSERT or MERGE statements for SQL target format.
/TargetDBType

Specifies target database type for SQL target format (for example, Access, DB2, Oracle etc.). This option lets the program to correctly encode some specific data types in output file (for example, boolean, date, time, and timestamp). If not specified, YYYY-MM-DD hh:mm:ss format (ANSI SQL standard) is used for dates and values are enclosed in single quotation marks; for boolean values, 'T' or 'F' is used.

/sqlTableName

Specifies table name for SQL target format (used as table name in SQL statements). Ignored when exporting group of files / tables (in this case the table name of the source is used). If the switch includes spaces, it must be enclosed in quotes.

/sqlStatementType Specifies SQL statement type for SQL target format. Possible values: INSERT, MERGE, UPDATE, or DELETE. If not specified or erroneous, INSERT is used.
/KeyFields

Specifies key fields (matching fields) for SQL and DATABASE target formats. This must be a name of a source field or a comma-separated list of several source field names.

For SQL target format, key fields must be specified when /sqlStatementType is MERGE, UPDATE, or DELETE. They are used in the ON (for MERGE) or WHERE (for UPDATE and DELETE) clause of SQL statements.

For DATABASE target format, key fields must be specified when /ExportMode is UPDATE, APPEND+UPDATE, or DELETE.

When field mappings are explicitly specified (in /FieldMappingsFile or /FieldMappings parameters), the key fields must be present there and map to the corresponding fields in target.

/encoding Encoding for XML, HTML, SQL, EXCELXML, or DBF target format. Possible values for XML, EXCELXML, SQL and HTML: ASCII, UTF-8 and so on. Possible values for DBF: DBASE ENU CP437, DBASE DEU CP437, 'ASCII' ANSI and so on (see full list in GUI). If the encoding includes spaces, entire parameter must be enclosed in quotes.
/LimitRecordCount Specifies a maximum number of records to be exported. If this option is not specified or it is less then 1, all records will be exported. If you want just create a file (table) without data exporting, use the corresponding export mode instead.
/RecordsPerLine Specifies the number of source records, which must be placed per one line in target. If not specified or erroneous, 1 is used. This option is ignored for XML, SYLK, DBF, PDF, EXCELXLSX, DATABASE target formats.
/RowsPerSheet Specifies the number rows in one sheet for EXCELXLSX and EXCELXML target formats (Exportizer Pro only). If not specified or erroneous, 65536 is used. When exporting, if the number of outputted rows reached this value, the new sheet is automatically created.
/FloatFormat Specifies format for numbers with floating points for EXCELXML target format (Exportizer Pro only).
/DateTimeFormat Specifies format for DateTime values for EXCELXML target format (Exportizer Pro only).
/LineTerminator Specifies style of line terminator in target file. Ignored for binary target formats. Possible values: WINDOWS or UNIX.
/FieldMappingsFile Specifies the name of the file, which contains source-to-target field mappings. The content of the file must conform to the rules for field mappings files. If this option is omitted, /FieldMappings option is used. This option is ignored for multi-table export (i.e. when you specify to export table list instead of one table). If the file name includes spaces, entire parameter must be enclosed in quotes. This option is ignored if target format is TEXT and /textSchema is expr.
/FieldMappings Specifies source-to-target field mappings. This must be a semicolon-separated list of the mappings. Each mapping must hold a pair of source and target field names separated by equal sign, for example: PaymentId=PAYMENT_ID. Field names should not contain equals and semicolons. If this option is omitted, /columns option is used to determine the source columns to export, and target field names are determined automatically according to rules of target database (when possible). This option is ignored for multi-table export (i.e. when you specify to export table list instead of one table). If the field names include spaces, entire parameter must be enclosed in quotes. This option is ignored if target format is TEXT and /textSchema is expr.
/columns Specifies columns (fields) to export. This must be a list of field names or their numeric indexes, separated by semicolons. If not specified, and /FieldMappingsFile and /FieldMappings are omitted too, all source columns are exported, and target field names are determined automatically according to rules of target database (when possible). This option is ignored for multi-table export (i.e. when you specify to export table list instead of one table). If the field names include spaces, entire parameter must be enclosed in quotes. This option is ignored if target format is TEXT and /textSchema is expr.
/TableMappingsFile Specifies the name of the file, which contains source-to-target table mappings for multi-table export (Exportizer Pro only). The content of the file must conform to the rules for table mappings files. If this option is omitted, source and target masks or lists must be specified. If the file name includes spaces, entire parameter must be enclosed in quotes.