group by schema

mulmad · August 27, 2008 11:21AM

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.

David Atkinson · August 27, 2008 12:25PM

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

mulmad · August 28, 2008 12:29PM

thanks. wasn't aware of the find box

group by schema

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk