SQL Source Control projects can be deployed using the SQL Change Automation PowerShell build and release components and CI/CD plugins.

When to use this deployment option

This is suitable for projects where you rarely run database modification statements (inserts, updates, deletes) and rarely wish to customize the auto-generated code for deployments. 

Additional licensing

Automated deployments of SQL Source Control with SQL Change Automation require licensing via either the SQL Toolbelt or Redgate Deploy. See our EULAs for more information. 

Learn more

The following references will help you understand the configuration options available in SQL Change Automation for SQL Source Control projects:

• Using SQL Compare filters with SQL Change Automation PowerShell module
• Using comparison options with SQL Change Automation PowerShell module for SQL Source Control Projects
• Using SQL Compare options with add-ons