Skip to content

Command Line Arguments

David Elish edited this page Dec 22, 2016 · 3 revisions

Syntax

sqlresultscompare [-c category] [-s subcategory] [-f filter] [-b bcpargs] [-o outputdir] [-l compswitch] [-d] [-i]

Arguments

--help

Prints all arguments along with their descriptions.

-c category

Specifies the category of comparisons that will be executed. Enables the execution of a group of many comparisons at once.

-s subcategory

Specifies the subcategory of comparisons that will be executed. Enables the execution of a subgroup of many comparisons at once.

-f filter

Specifies the filter to be applied to all comparison queries that are being executed. It is effectively a WHERE clause without the WHERE keyword. It must conform to all target database platforms' syntax rules.

-b bcpargs

Specifies the bcp arguments to be used to override the default arguments "-t , -c -T".

-o outputdir

Specifies the file system location in which the query output files are written.

-l compswitch

Specifies the switches to be used when calling the diff/comparison tool.

-d

Specifies whether pre-existing comparison files will be deleted. Use this option to delete existing files. Do not use this option if you would like to retain existing files.

-i

Specifies whether the supporting database objects should be created/updated. This option is to be executed on its own upon initial deployment or upgrade of the SQL Results Compare application.

Clone this wiki locally