How to include dependent objects

Last modified: April 19, 2024

It is important for developers and DBAs to be able to determine the interdependencies of database objects when synchronizing databases. Schema Compare allows viewing the dependencies and including dependent objects into synchronization in case they have not been included at the beginning.

After you have selected objects for deployment and clicked Synchronization, the Schema Synchronization Wizard usually opens with three tabs: Output, Options, and Summary.

However, in case the objects you have chosen for synchronization are dependent on some other objects in the database which have not been selected, the Dependencies tab appears in the wizard.

It alerts you about the objects that reference or are referenced by objects they did not select, and these dependencies affect the deployment of object changes.

The Dependencies page lists affected objects and provides the details of their dependencies.

By default, the affected objects are selected for schema changes deployment. If you don’t want to include the dependent objects into synchronization, clear the checkbox next to these objects.