Key Features: Command Line Using

In Database Tour Pro, the most important operations like exporting data, executing queries etc. can be performed using the command line. In the command line mode, it is possible to work with all options which are available in GUI.

Examples of command lines

Data exporting

Export one table from .mdb file to .htm

dbtour.exe /export /SrcDBPassword=leo12 "/SrcDB=c:\my db\stores.mdb" "/SrcTableName=price" "/TrgDB=c:\my db\price.htm"

Export all tables from .mdb file to .htm files in silent mode

dbtour.exe /silent /export /SrcDBPassword=leo12 "/SrcDB=c:\my db\stores.mdb" "/SrcTableName=*" "/TrgDB=c:\my db\" "/TrgTableName=*.htm"

Batch operations with text data

Replacing text in Access table

dbtour.exe /FieldUtils /CloseWhenDone /CloseOnError /DBInterface=ADO /DBDriver=ACCESS /DB=c:\MyData\Genealogy.mdb /TableName=ADDR /fields=Address1 "/ReplaceText=Mark Tweine street," "/ReplaceText=Mark Tweine str.," /ReplaceIgnoreCase

Opening databases, SQL scripts, report files

Open a folder based DBF database and open a table in it

dbtour.exe /opendb /DBInterface=ADO /DBDriver=dBase /DBKind=FOLDER "/DB=c:\MyData" "/TableName=customer.dbf"

Open an Interbase database, execute an SQL script in it, and then close all

dbtour.exe /opendb /CloseWhenDone /DBInterface=INTERBASE /DBDriver=INTERBASE /DBKind=FILE "/DB=MyServerName:D:\CommonData\News.gdb " /DBUserName=JohnM /DBPassword=qazwsx78 /SQLFile=d:\MyScripts\CheckData.sql /ExecuteQuery

Creating command lines

The great advantage is that the command line can be easily generated automatically from the GUI using the interface very similar to GUI interface of the corresponding operation:

Generating a command line for batch operations with text fields:

Generating a Command Line from GUI

Generating a command line for exporting data:

Generating a Command Line for Exporting Data from GUI

For more details about the command line parameters, please see Database Tour documentation.