How to include additional script into SQL Source Control

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!
Tagged:

Comments

Sign In or Register to comment.