How to compare/deploy only a single column?
MarkG_Sagent
Posts: 1 New member
We have a couple of databases we are comparing, and we are interested in comparing only one column in some of the tables. If that column is the same, we can ignore any other changes in the row.
Similarly, since we don't care about changes in the other columns, we want to generate (UPDATE) scripts for only that column, not any other columns.
Is this possible to do?
Similarly, since we don't care about changes in the other columns, we want to generate (UPDATE) scripts for only that column, not any other columns.
Is this possible to do?
Tagged:
Answers
However, what is possible is to ignore the table in SQL Source Control/SQL Change Automation and use post-deploy scripts to manage this column.
If you do this, source control would be "the truth" and any changes made in production would be ignored.
Without understanding your use case in a bit more detail it's hard to know whether this would be an acceptable solution for you.
DevOps Mentor and Coach
Director of DLM Consultants
Creator of Speaking Mentors
Microsoft Data Platform MVP
Friend of Redgate
Twitter / LinkedIn