SQL CI command line reference
Published 10 March 2016
All SQL CI command line switch names are case insensitive. The switch values are case sensitive.
There's no restriction on the number of switches you can use or the order in which you use them.
Switches can be preceded by a forward slash (/) or two dashes (--).
SQL CI command line supports four steps that perform different continuous integration tasks. The steps are:
- Build - validates the SQL creation scripts and places them in a NuGet package. You can also send schema information to DLM Dashboard.
See Using the build command
- Test - generates test data using SQL Data Generator and runs tSQLt tests against the NuGet package, such as static analysis, unit or integration tests. Results are output in JUnit XML format.
See Using the test command
- Sync - updates the existing database with the latest version in source control.
See Using the sync command
- Publish - publishes the NuGet package to a NuGet feed, ready for deployment.
See Using the publish command
The Test, Sync and Publish steps use the NuGet package created during the build step. These three steps are optional, but if you want to use them you must complete the Build step first.