Extended property to ignore an object
Bugmeister
Posts: 21 New member
Hi,
For some of our objects, they are automatically scripted in and kept up-to-date from another system, whereas the remainder of the objects are source-controlled manually via SSC.
The objects that are controlled by the non-SSC can have any schema/object name etc, however they all have a particular extended property set on them (and we have control to add more etc.).
At the moment I need to manually edit the SSC filters and filter out any of these objects based on their schema/name as new one come into the database.
Would be way easier if I could just filter out objects that have an extended property set against them.
Is there any out-of-the-box or workaround to achieve that in SSC?
Thanks
Peter
For some of our objects, they are automatically scripted in and kept up-to-date from another system, whereas the remainder of the objects are source-controlled manually via SSC.
The objects that are controlled by the non-SSC can have any schema/object name etc, however they all have a particular extended property set on them (and we have control to add more etc.).
At the moment I need to manually edit the SSC filters and filter out any of these objects based on their schema/name as new one come into the database.
Would be way easier if I could just filter out objects that have an extended property set against them.
Is there any out-of-the-box or workaround to achieve that in SSC?
Thanks
Peter
Tagged:
Best Answer
-
David Atkinson Posts: 1,460 Rose Gold 2@Bugmeister - Hmmm. The only solution I can think of is if you programmatically update the filter.scpf based on querying the extended properties.
David Atkinson
Product Manager
Redgate Software
Answers
Product Manager
Redgate Software