Red Gate forums :: View topic - Object Filtering
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control EAP
SQL Source Control EAP forum

Object Filtering

Search in SQL Source Control EAP forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
mobrien



Joined: 01 Mar 2010
Posts: 4
Location: USA

PostPosted: Mon Mar 01, 2010 7:43 pm    Post subject: Object Filtering Reply with quote

We have a database with about 100k dynamic tables. We have had problems with a number of database tools not being able to filter out those dynamic tables that we want to ignore. Will SQL Source control be able to filter out and ignore SQL objects?

We would love to set multiple wildcard filters like: DYNTABLE_*, DYNVIEW_*, etc.

Thanks,

m
Back to top
View user's profile Send private message
sherr



Joined: 19 Mar 2009
Posts: 125
Location: Cambridge

PostPosted: Mon Mar 01, 2010 8:16 pm    Post subject: Object Filtering Reply with quote

SQL Source Control currently doesn't have the ability to ignore objects.

Please vote/comment on this suggestion at
http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/458708-exclude-objects-from-versioning-svn-ignore-?ref=title to help us prioritize future features.

The best thing to do now is:
1) Sort the Commit List by Object Name
2) Use your mouse and shift key to highlight all the objects that start with DYN*
3) Unclick on one of the rows, which will unselect all of the highlighted objects
4) Commit your other objects, which are still selected

If you only made one change, you could also use the checkbox in the column header to unselect all the objects in the commit list, and then only select the one object you want to commit.

You can also do this by right-clicking on the object in the Object Explorer and selecting Commit. This will bring you to the Commit tab with only the one object selected.

I hope these tips help for now... Smile
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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