Possible to compare only one element in extended property?

steal

Recently our dev team updated an extended property to contain multiple values, so that it now looks something like this-

{"RepositoryURL" : "https://dev-gitlab.dev.abc/teamA/projectA.git",

"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?  

Comeneserse

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.

basket random

steal

Sorry I should have added that I have the compare process automated.  Is there a way to do that parsing via command line parameter?

hassan_imam

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)