How can we help you today? How can we help you today?

Object Filtering

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
0

Comments

1 comment

Sort by
  • StephanieHerr
    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... :-)
    StephanieHerr
    0

Add comment

Please sign in to leave a comment.