Database Synchronization Issues

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
vinayakm
Posts: 13
Joined: Fri 15 Dec 2017 13:29

Database Synchronization Issues

Post by vinayakm » Wed 18 Apr 2018 07:04

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
Devart Team
Posts: 2844
Joined: Fri 24 Jun 2011 14:17

Re: Database Synchronization Issues

Post by alexa » Wed 18 Apr 2018 10:19

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
Posts: 13
Joined: Fri 15 Dec 2017 13:29

Re: Database Synchronization Issues

Post by vinayakm » Fri 20 Apr 2018 07:13

Thank you

Post Reply