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

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

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

Comments

2 comments

Sort by
  • David Atkinson
    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
    0
  • steal
    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!
    steal
    0

Add comment

Please sign in to leave a comment.