Page 1 of 1

Database Synchronization Issues

Posted: Wed 18 Apr 2018 07:04
by 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.

Re: Database Synchronization Issues

Posted: Wed 18 Apr 2018 10:19
by 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.

Re: Database Synchronization Issues

Posted: Fri 20 Apr 2018 07:13
by vinayakm
Thank you