Possible to compare only one element in extended property?

stealsteal Posts: 5 New member
in SQL Compare
Recently our dev team updated an extended property to contain multiple values, so that it now looks something like this-

"Branch" : "2024R1",
"RevisionNumber":"9f011ad4ecd9e78dd43c2196eb370463978a78f6",
"BuildAgent":"BUILDAGENT12",
"Version":"2024.1.26418"}

I only need to compare the "Version" value, is there a way to do that the other values are ignored and don't trigger a diff?  
Tagged:
· Share on Twitter

Answers

  • ComeneserseComeneserse Posts: 1 New member
    Yes, there is a way to compare only the "Version" value in the given extended property and ignore the other values. Since the extended property is in JSON format, you can parse it and extract the specific value you're interested in.
    · Share on Twitter
  • stealsteal Posts: 5 New member
    Sorry I should have added that I have the compare process automated.  Is there a way to do that parsing via command line parameter?
    · Share on Twitter
  • hassan_imamhassan_imam Posts: 54 Bronze 1

    Hello Steal,

    Thank you for reaching out regarding SQL Compare. We apologize for the delay in getting back to you. Regrettably, the feature you mentioned is not currently supported by our comparison solution. However, we encourage you to submit your idea through UserVoice if you believe it would be a valuable addition for us to consider

    SQL Compare (UserVoice)

    · Share on Twitter
Sign In or Register to comment.