When comparing schemas, SQL is generated which drops and recreates a table that is in a different schema when it should use a transfer to change the schema for the table.
WORKAROUND:
Instead of running the portion of the sync script that drops the table, do the following.
1. Create needed schema in target database.
2. Use 'Change Schema' from context menu in Object Explorer for all objects which can be moved to other schema.
STATUS:
Waiting for enhancement request to be implemented in a future version of Toad for SQL Server.
