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

group by schema

In databases with many tables organized into schemas, it would be really helpful if the "group by" function also had a "by schema" option.

This goes for both compare and data compare.
mulmad
0

Comments

2 comments

Sort by
  • David Atkinson
    Thanks for the suggestion.

    You can filter them out using the Filter function in SQL Data Compare and the Find function in SQL Compare (apologies for the different naming!).

    For example, to list all objects owned by david and starting with xyz, type:

    [david].[xyz

    This simply does a substring filter on the comparison results objects list.

    David Atkinson
    Red Gate Software
    David Atkinson
    0
  • mulmad
    thanks. wasn't aware of the find box
    mulmad
    0

Add comment

Please sign in to leave a comment.