DLM Automation

SQL CI command line reference

In DLM Automation 1.5, SQL CI was replaced by the DLM Automation PowerShell module.

The SQL CI command line is still available in DLM Automation but is no longer being developed. We recommend you switch to using the DLM Automation cmdlets to take advantage of new features and future development. 

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:

  1. 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
  2. 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
  3. Sync - updates the existing database with the latest version in source control.
    See Using the sync command
  4. 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. 

Didn't find what you were looking for?