Database Synchronization Issues
Database Synchronization Issues
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
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.
You can turn off relations. This can be done by unselecting all the objects on the 'Dependencies' page of the Schema Synchronization wizard.