Options
Feature Request: WHERE object name like filter
julian-kuiters
Posts: 6
SQL Compare is an awesome tool. But sometimes I just need to compare a small subset of objects in a database; for example just objects in one schema, or just objects where the object name begins with 'ut_' or something like that.
It would be nice to be able to specify a ObjectName and/or ObjectSchema/Owner wildcard filter. LIKE syntax would be fine. So I could search for ObjectName = 'ut_%'.
This is important when I work on set of objects that is published to multiple different databases. I want to be able to compare just that set of objects in the different databases which otherwise could have completely different structures. For example, I have a DDL Audit trigger and log table that I can publish in many different databases: datawarehouse, import, crm, extranet, etc. I want to be sure the DDL Audit objects are identical across the databases, and I'm not concerned with any other objects.
Thanks!
It would be nice to be able to specify a ObjectName and/or ObjectSchema/Owner wildcard filter. LIKE syntax would be fine. So I could search for ObjectName = 'ut_%'.
This is important when I work on set of objects that is published to multiple different databases. I want to be able to compare just that set of objects in the different databases which otherwise could have completely different structures. For example, I have a DDL Audit trigger and log table that I can publish in many different databases: datawarehouse, import, crm, extranet, etc. I want to be sure the DDL Audit objects are identical across the databases, and I'm not concerned with any other objects.
Thanks!
SQL Server thoughts and code: http://www.julian-kuiters.id.au
This discussion has been closed.
Comments
I'm sorry that this feature didn't make it into version 4. You may see it in a future version. Thanks for your interest.