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.

SQL Change Automation primarily takes a migrations-based approach to database development. It also tracks object-level history using programmable objects and the offline schema model.

These projects can be created and used in both Visual Studio and SQL Server Management Studio (SSMS).

Project Contents

• Migrations
• Programmable objects
• Pre-deployment
• Post-deployment
• Schema-model
• Additional scripts
• Unsupported
• Provisioning
• [Project-Name].sqlproj
• [Project-Name].sqlproj.user
• Filter.scpf

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.

Learn more

• Setting up a project in SSMS
• Setting up a project in Visual Studio