Red Gate forums :: View topic - Filter features in SQL Comparison SDK 8
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK Previous Versions
SQL Comparison SDK Previous Versions forum

Filter features in SQL Comparison SDK 8

Search in SQL Comparison SDK Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
jpjones75



Joined: 13 Apr 2009
Posts: 4

PostPosted: Mon Apr 13, 2009 2:30 pm    Post subject: Filter features in SQL Comparison SDK 8 Reply with quote

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?
Back to top
View user's profile Send private message
Simon C



Joined: 26 Feb 2008
Posts: 140
Location: Red Gate Software

PostPosted: Fri Apr 17, 2009 2:02 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
jpjones75



Joined: 13 Apr 2009
Posts: 4

PostPosted: Fri May 01, 2009 2:26 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
jpjones75



Joined: 13 Apr 2009
Posts: 4

PostPosted: Fri May 01, 2009 2:27 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group