ApexSQL Unit Test Command Line Interface (CLI) switches

Specifies server and instance name of the SQL instance. It will reference to (local) SQL Server if the switch is omitted

Alias: /s

Format: /server:server_name[\instance_name]

Specifies the unit tests database name

Alias: /d

Format: /database:database_name

Specifies the Server login when SQL Server authentication is used. The trusted connection will be used if the switch is omitted

Alias: /u

Format: /user:server_login

Note: This switch must be used together with the /password switch

Specifies the Server login’s password when SQL Server authentication is used.

Alias: /p

Format: /password:server_login_password

Note: This switch must be used together with the /user switch

Specifies the unit test class that contains tests that will be executed. If a class is not specified or empty, all tests present on the chosen database will be executed

Alias: /cl

Format: /class:class_name

Specifies a unit test list where unit tests are separated by one space and which name must start with test. Example: /ut:testAB testBC testCD

Alias: /ut

Format: /utests:unit_test_name

Note: Test names must be written properly including capital and small letters

Install the latest built-in version of tSQLt framework on a specified database before executing tests

Alias: /it

Format: /install_tsqlt

Install built-in SQLCop tests on a specified database before executing tests

Alias: /isc

Format: /install_sqlcop

Note: This switch must be used together with the /install_tsqlt

Uninstall tSQLt framework on a specified database

Alias: /utf

Format: /uninstall_tsqlt

Note: Using this switch without the /uninstall_classes switch will leave all test classes in a specified database

Alias: /dc

Format: /uninstall_classes

Note: This switch cannot be used alone, must be used with the /uninstall_tsqlt switch

Specifies which test class will be deleted from a specified database

Alias: /dcn

Format: /uninstall_class:class_name

Specifies that tests results will be exported to XML or SQL file

Alias: /or

Format: /outreport:file_path

Specifies that tests results summary will be exported to a database

Alias: /todb

Format: /to_database

Note: This switch must be used with switches /export_server and /export_database

Specifies SQL Server where the tests result summary will be exported. It will reference to (local) SQL Server if the switch is omitted

Alias: /exs

Format: /export_server: server_name[\instance_name]

Note: This switch must be used with switches /to_database and /export_database

Specifies a database where the tests result summary will be exported.

Alias: /exd

Format: /export_database:exportdatabasename

Note: This switch must be used with switches /to_database and /export_server

Specifies the SQL Server login when SQL Server authentication is used. The trusted connection will be used if the switch is omitted.

Alias: /exu

Format: /export_user:export_user

Note: This switch must be used together with the /password switch

Specifies the Server login’s password when SQL Server authentication is used.

Alias: /exp

Format: /export_password:export_server_password

Note: This switch must be used together with the /user switch