How to include additional script into SQL Source Control

Elizabeth_Close_M1st

We have added a column (with default) to an existing table, created a lookup table with static values, then created a foreign key from existing table to lookup table - all this works great in source control. Now I want to update the existing table with one of the values from my lookup table and I'm not finding a way to do that (PK differs in DEV-TEST-PROD) so essentially I want to do is run a sweeping update against the existing table without doing a SQLDataCompare.
I have to believe this has been done before!

Elizabeth_Close_M1st

I found that Migration script works for including DML steps

Grant

Generally to get to a multi-step deployment, a lot of people are using deployment software like Team Services Deployment Manager or Octopus. That allows you a very high degree of control on putting additional pre & post steps in line with your Source Control deployments.