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

How to compare/deploy only a single column?

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?
MarkG_Sagent
0

Comments

1 comment

Sort by
  • AlexYates
    This is not possible with SQL Compare.

    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.
    AlexYates
    0

Add comment

Please sign in to leave a comment.