Schema compare synchronization script recreates a table instead of altering it.
说明
Schema Compare is performed on two databases. The only difference between the databases is a new column added to the end of one table. When compare is performed, the resulting Sync Script drops and recreates the table (via renaming the table) which is unnecessary. When the same compare is performed in Toad 5.8, sync script generates a simple Alter Table command to add the new column to the table in the target database.
解决办法
WORKAROUND: None
STATUS: Waiting for fix to be released in a future version of Toad for SQL Server.
