How can we help you today? How can we help you today?

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!
ElizabethClose_M1st
0

Comments

2 comments

Sort by
  • Elizabeth_Close_M1st
    I found that Migration script works for including DML steps
    Elizabeth_Close_M1st
    0
  • 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.
    Grant
    0

Add comment

Please sign in to leave a comment.