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

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.

作者:Chuck Lu    GitHub