Use SQL Compare to ONLY sync Extended Properties?

chenry

We are looking at using SQL Doc to create and store additional meta data about our SQL objects and want to find an easy(ish) way to migrate these comments from one environment to another (dev to QA to Prod, etc.).

We also want to limit the scripting so that we only look for differences in the extended properties (where SQLDoc stores the info you add), and not other attributes of the object.

I was able to find a way to Exclude extended properties from the comparison, but haven't found a way to ONLY Include extended properties in the comparison.

Has anyone found a way to do this?

Thanks!
-Chris

Anu D

Many thanks for your post Chris.

You cannot compare only extended properties straight away but you can follow below steps to do it.

1. Make sure the 'Ignore --> Extended Properties ' option is deselected.
2. Generate the synchronisation script
3. Amend it to copy just the extended properties section.

Kindly let me know if that helped.