xSQL Object

Comparing Databases - Schema Filters

 

For very large databases, simply being able to select which types of objects to include in the comparison may not be enough as there may still be thousands of objects of the selected type(s) while only a few of those objects may be of interest to you. To address this particular issue xSQL Object allows you to define schema filter that can be used to select just the objects you want to include in the comparison (example: compare only the stored procedures which have a name starting with 'a').

For every object type you can first select the validation type (AND or OR) and then add the criterias that will be applied on the names of the objects of that type. The criteria drop down provides a set of predefined options from "starts with" to "matches regular expression" to allow you to select exactly what you want.

Caution: Because of object dependencies, including/excluding certain objects from the comparison / synchronization is not encouraged unless your situation dictates it.

Important: please note that the schema filters you define here are handled as application settings and apply to all the comparisons and synchronizations you perform until you clear them.