When versioning static data, is there a way to ignore differences in a column in SQL Source Control

morganmorgan Posts: 3 New member
in SQL Source Control
We would like to version data in a table, however there are specific columns that need to be ignored. Data Compare has the feature to filter (ignore) specific columns. How do we achieve this in SQL Source Control? Thanks in advance!
Tagged:
· Share on Twitter

Best Answer

Answers

  • AlexYatesAlexYates Posts: 264 Rose Gold 2
    I'm trying to think of a good way to do this but can't think of anything better than move the static data and "not static data" into different tables.

    Is there any reason why you can't do that? (Other than the fact that this sounds like a complicated data migration).
    Alex Yates
    DevOps Mentor and Coach

    Director of DLM Consultants
    Creator of Speaking Mentors
    Microsoft Data Platform MVP
    Friend of Redgate
    Twitter / LinkedIn
    · Share on Twitter
  • morganmorgan Posts: 3 New member
    AlexYates wrote: »
    I'm trying to think of a good way to do this but can't think of anything better than move the static data and "not static data" into different tables.

    Is there any reason why you can't do that? (Other than the fact that this sounds like a complicated data migration).

    I guess a better term for the data is "lookup data". It rarely changes, but when it does we don't want Redgate to overwrite the changes in that column. We want all environments to get the rows with the default values if they are missing, yet still have the possibility of one column being modified in specific scenarios. The tables are properly normalized, so there is no need to break the data up into different tables. Also, if we were to break it up as you suggest, that would still leave us manually managing data in the "not static data" table. So it wouldn't be an improvement.

    It appears that its the SQL comparison tools that are operating underneath, and the filters work fine for object structure. So why leave out the data filters?
    · Share on Twitter
  • morganmorgan Posts: 3 New member
    AlexYates wrote: »
    I'm afraid not:
    https://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/1267757-allow-me-to-specify-a-subset-of-columns-for-static

    Thanks for the link! I added votes. Too bad it hasn't been added in this many years!
    · Share on Twitter
  • David AtkinsonDavid Atkinson Posts: 1,458 Rose Gold 2
    Is it possible to source control a view? If so, a view could be created that excludes the column. Just a thought (I haven't tried this myself - just thinking aloud).
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.