Database Synchronization Issues

[vinayakm]

When I try to copy a stored procedure from Database A to Database B using Schema Comparison option why are the tables mentioned in the stored procedure also being copied even though I have selected only the stored procedure. Is there any way to avoid this behavior.

[alexa]

Related tables get pulled up automatically in order to keep database consistency. Since the tables are used in the body of the procedure, for correct working of the procedure the tables are necessary.

You can turn off relations. This can be done by unselecting all the objects on the 'Dependencies' page of the Schema Synchronization wizard.

[vinayakm]

Thank you