group by schema

mulmadmulmad Posts: 94
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.

Comments

  • 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
    Product Manager
    Redgate Software
  • thanks. wasn't aware of the find box
Sign In or Register to comment.