IDERA SQL Schema Compare supports and can synchronize all database objects. By default, only a few object types are excluded. In most cases, you should not need to change the default settings. There are, however, scenarios in which you might want to exclude certain object types that are included 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.