Toad World® Forums

SQL schema compare script question

I have TOAD for SQL Server version 6.1. When doing a schema compare between two databases and generating a script I’m finding that TOAD’s sync script always generates a drop and re-creation of a table no matter how small the change (example: simply expanding the size of a field). Since the database I’m converting has very large tables it’s very time consuming to have these tables re-created along with the indexes rather than the script using a simple Alter table command. Is there an option that I’m missing where I can have the tables altered or will the script always generate a mandatory re-creation of the table?