What are the challenges you face when working across database platforms? Take the survey

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?


  • Options
    AlexYatesAlexYates Posts: 264 Rose Gold 2
    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.
    Alex Yates
    DevOps Mentor and Coach

    Director of DLM Consultants
    Creator of Speaking Mentors
    Microsoft Data Platform MVP
    Friend of Redgate
    Twitter / LinkedIn
Sign In or Register to comment.