xSQL Object

Selecting Types of Objects to Include in the Comparison

 

Because of the dependencies between objects it is always safer to include all the object types in a comparison / synchronization operation. For example while you can certainly choose to compare only views it wouldn't make sense to attempt to synchronize views only and exclude the tables on which those views may depend.

Rule of thumb: whenever you are not sure, click on "Default Objects" and xSQL Object will automtically include all the objects that must be included while excluding certain types that are not commonly migrated from a development database to a testing or production database.

However, you may be faced with a very large database, and let's say you know for sure that the Tables and certain categories of views and stored procedures never change, but a subset of stored procedures and views are constantly evolving. You don't want to unecessarily keep comparing the thousands of never changing tables - you want to be able to exclude tables from the comparison and synchronization. xSQL Object allows you to choose the object types you want to include/exclude.