Object Filtering

Early Access Program for SQL Source Control

Moderators: Chris Auckland, David Atkinson, sherr

Object Filtering

Postby mobrien » Mon Mar 01, 2010 7:43 pm

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
mobrien
 
Posts: 4
Joined: Mon Mar 01, 2010 7:35 pm
Location: USA

Object Filtering

Postby sherr » Mon Mar 01, 2010 8:16 pm

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

Please vote/comment on this suggestion at
http://redgate.uservoice.com/forums/390 ... ?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... :-)
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge


Return to SQL Source Control EAP

Who is online

Users browsing this forum: No registered users and 0 guests