SQL Change Automation --> Setting up a project with an existing database in SSMS

2022-12-16 07:18:05

In this scenario, we’ll set up a new SQL Change Automation project for an existing database. Specifically, we’ll:

Set up an example database, AdventureWorks
Create a new SQL Change Automation project within SQL Server Management Studio (SSMS)
Set up a new development database
Baseline the development database from AdventureWorks
Make changes to the development database, and generate migrations for the SQL Change Automation project

Setting up AdventureWorks

Create an AdventureWorks database matching your version of SQL Server.