Options

Filter features in SQL Comparison SDK 8

jpjones75jpjones75 Posts: 6
edited May 1, 2009 9:27AM in SQL Comparison SDK Previous Versions
I currently have a working version of the SQL Comparison SDK using version 7. I would like to use some of the new features in SQL Compare 8 in version 8 of the SDK. Namely, I want to apply some of the enhanced filtering options to only include objects within certain schema's and optionally only objects of certain types in the comparison (or Work object). I see there is a new Filter namespace that could be used to build the filtering object(s). How would I create such filter(s) and then apply them either before or after the comparison in the SDK?
· Share on Twitter

Comments

  • Options
    Simon CSimon C Posts: 140
    Hi jpjones; I've written an article outlining the API to use the filtering from the SDK here. Hopefully this'll get you started on working with the filtering.

    Currently, filtering is only done post-compare; we did seriously consider pre-comparison filtering, but there were too many dependency issues to make it reliable enough.

    Simon C
    · Share on Twitter
  • Options
    jpjones75jpjones75 Posts: 6
    Thank you for the feedback. Your article gave me what I needed to implement these filter features. We are using the SDK on a large system containing a number of objects, some objects are prefixed with a constant to imply ownserhip, while other objects are seperated into schemas. These filtering features are helpful to sort through all of this without us having to write logic to inspect the name and/or owner of each individual object.
    · Share on Twitter
  • Options
    jpjones75jpjones75 Posts: 6
    Thank you for the feedback. Your article gave me what I needed to implement these filter features. We are using the SDK on a large system containing a number of objects, some objects are prefixed with a constant to imply ownserhip, while other objects are seperated into schemas. These filtering features are helpful to sort through all of this without us having to write logic to inspect the name and/or owner of each individual object.
    · Share on Twitter
Sign In or Register to comment.