Get started with the DLM Automation cmdlets
Published 10 March 2016
SQL CI command line users
If you're already familiar with using SQL CI command line and just want to set up the equivalent of the SQL CI Build, Test, Sync and Publish steps using the DLM Automation cmdlets, see Switch from SQL CI to PowerShell.
The DLM Automation PowerShell module is a set of PowerShell cmdlets you can use to set up continuous integration and automated deployment for SQL Server databases.
Each cmdlet is described in detail in the DLM Automation cmdlet reference. However, if you're new to the cmdlets, this is the best place to start. These pages provide an overview of using the cmdlets, and show you how you can combine them to perform the most common continuous integration tasks.
We've split the information into four sections:
- PowerShell basics
Some general information and advice about running PowerShell cmdlets.
- Setting up database connections
How to establish and test a connection to a database.
- Continuous integration
How to set up automated tasks that need to be performed every time there's a change to your development database schema.
How to deploy the development schema to a target database, with the option of an intermediate review step.