Possible to compare only one element in extended property? TAKE 2

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'm comparing hundreds of databases using sqlcompare.exe.  I only want the compare to evaluate the "Version" element in the extended property JSON.  Is there a way to configure the compare options so that the other extended property elements get ignored and don't trigger a diff?  
Tagged:
· Share on Twitter

Answers

  • David AtkinsonDavid Atkinson Posts: 1,462 Rose Gold 2
    If I understand correctly, you've chosen to add json as the value of extended property. SQL Compare will compare the value of the extended property, and therefore will just regard your json as text. It doesn't know that this is json, and therefore can't pick out specific elements.
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
  • stealsteal Posts: 5 New member
    Darn that's what I was afraid of.  I'll have to find out who made this decision (JSON) on the dev team and get the value I need added as a separate property.  Thank you for confirming!
    · Share on Twitter
Sign In or Register to comment.