SQL Source Control 7

Working with migration scripts

As of SQL Source Control v7, using migrations scripts in SQL Change Automation is the recommended and supported method for implementing a migrations based deployment approach as part of Redgate's Database DevOps solution.

If you are using the legacy SQL Source Control migrations feature (via the Migrations tab in SQL Source Control)...

Interested in previewing a new solution which will offer a single flexible development model in one tool?

Email databasedevops@red-gate.com for more info.  

What are migration scripts?

When using a state approach, to deploy changes from version control the SQL Compare engine calculates a deployment script by comparing the state held in version control with the deployment target. If more control or customization of the deployment scripts is required, you can use the migration scripts capability of SQL Change Automation to achieve this.

For example, migration scripts may be necessary to avoid data loss when making certain schema changes.

To get started with migrations, a SQL Change Automation project must be created and configured with its development source set to your SQL Source Control project.

Didn't find what you were looking for?