SQL Source Control 6

Static data and migrations

When you deploy migration scripts alongside static data changes, the migration scripts will run first. This can cause the deployment to fail.

We don't recommend using migration scripts on tables which have static data linked.

If the deployment fails, splitting the deployment in two may succeed. Deploy the revision before the migration script to make the static data changes, then deploy the latest revision to run the migration script.

Didn't find what you were looking for?