sql change automation

Development source

A development source represents the current state of the database in your development environment.

There are two types of development source in SQL Change Automation:

  • A development database
  • A SQL Source Control project

https://documentation.red-gate.com/sca/developing-databases/concepts/shadow-database

The shadow database is automatically created and maintained by SQL Change Automation if you are using a database as your development source.

If you are using a SQL Source Control project you will need to specify one. This database represents the result of running the migrations in your project against an empty database.

如果以现有数据库作为development source, 会自动创建一个shadow database.

如果以sql source project作为development source,那么需要指定一个shadow databse.

Setting up a project with a SQL Source Control project in SSMS

原文地址:https://www.cnblogs.com/chucklu/p/13323270.html