Filter features in SQL Comparison SDK 8

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Filter features in SQL Comparison SDK 8

Postby jpjones75 » Mon Apr 13, 2009 2:30 pm

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?
jpjones75
 
Posts: 4
Joined: Mon Apr 13, 2009 2:09 pm

Postby Simon C » Fri Apr 17, 2009 2:02 pm

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
Simon C
 
Posts: 140
Joined: Tue Feb 26, 2008 4:56 pm
Location: Red Gate Software

Postby jpjones75 » Fri May 01, 2009 2:26 pm

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.
jpjones75
 
Posts: 4
Joined: Mon Apr 13, 2009 2:09 pm

Postby jpjones75 » Fri May 01, 2009 2:27 pm

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.
jpjones75
 
Posts: 4
Joined: Mon Apr 13, 2009 2:09 pm


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests