Use SQL Compare to ONLY sync Extended Properties?

chenrychenry Posts: 4
edited February 26, 2010 10:17AM in SQL Compare Previous Versions
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?



  • Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
Sign In or Register to comment.