Retired products

SSAS Compare command-line syntax

This is a list of switches you can use with the SSAS Compare command line.

Switches and aliases aren't case-sensitive.

/help

Alias: /?

Lists the command line syntax, as shown on this page. For more detailed information, use with /verbose.

/html

Outputs the command line syntax help as HTML in the console. To export it to an HTML file, use with /out.

/force

Alias: /f

Forces the overwriting of any output files that already exist. If this switch isn't used, and a file of the same name already exists, the application will exit with the exit code indicating an IO error.

/argfile:<argfile>

Runs a file containing an XML argument specification. For example:

  1. Redgate.SsasCompare.CommandLine /Argfile:XMLFileName.xml

For more information, see Using XML to specify command line arguments in the SQL Compare documentation.

/out:<fileName>

Redirects console output (eg when used with /html) to the specified file.

/outputwidth:<columns>

Forces the width of console output.

This can be used, for example, to make sure object names aren't truncated, and that SQL script lines aren't wrapped or broken. This is particularly useful when redirecting output to a file, as it overcomes the limitations of the default console width of 80 characters.

/server1:<server1>

Alias: /s1

Specify the SQL server where the source database is hosted. If this isn't specified, it defaults to (local).

/server2:<server2>

Alias: /s2

Specify the SQL server where the target database is hosted. If this isn't specified, it defaults to (local).

/database1:<database1>

Alias: /db1

Specify the source database for comparison.

/database2:<database2>

Alias: /db2

Specify the target database for comparison.

/file1:<file1>

Alias: /f1

Specify a file containing the XMLA description of the source database for comparison.

/file2:<file2>

Alias: /f2

Specify a file containing the XMLA description of the target database for comparison.

/scriptout:<scriptout>

Alias: /so

Writes an XMLA deployment script to the specified file.

/deploy

Deploys the XMLA change script to the target server.

/includeprocessing

Alias: /ip

Include an additional command in the XMLA deployment script to process the cubes.


Didn't find what you were looking for?