What are the challenges you face when working across database platforms? Take the survey

Feature Request: WHERE object name like filter

julian-kuitersjulian-kuiters Posts: 6
edited January 24, 2006 12:58PM in SQL Compare Previous Versions
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.

SQL Server thoughts and code: http://www.julian-kuiters.id.au


This discussion has been closed.