Published 31 July 2019
Projects are the primary artifact used when developing and deploying databases using SQL Change Automation. Projects are the single source of truth as they represent the state a database ought to be in.
Types of project
SQL Change Automation projects
A SQL Change Automation project represents a database as a set of SQL scripts that describe how to take a database from one state to another.
These projects can be created and used in both Visual Studio and SQL Server Management Studio (SSMS).
- Programmable objects
- Additional scripts
SQL Source Control projects
SQL Change Automation also allows you to deploy SQL Source Control projects. However with this approach you'll have less control over how the scripts are deployed.
For more information see SQL Source Control's documentation.