IDERA SQL Schema Compare supports over 45 different types of and can synchronize all database objects. By default, all but only a handful of few object types will be included in the comparison and synchronization.In the majority of the are excluded. In most cases, you should not need to change the default settings. There are, however, scenarios in which you might wish want to exclude certain categories object types that are included by default or include those that are excluded by default.
To exclude or include certain object types, click Comparison Options. The first tab on the Comparison Options window that appears is the Database Objects tab which provides a brief description for each object type and allows you to select or clear the object types you want.
Because of the dependencies between database objects, excluding all objects of a given type may result on a synchronization script that will fail to execute due to invalid dependencies. For more information about the handling of dependencies, see SQL Schema Compare Comparison Options.