Return
-
Title
Sync script includes all objects even when only one object type is selected -
Description
In Schema Compare, the wizard allows to select only indexes. However, when the user generates sync scripts, the result includes all other schema objects, including table definition, triggers , stored procs, etc.
-
Cause
Indexes and such types of objects are not independent objects. They rely on the parent objects to exist in the database.Example: You cannot create an index into the target database without creating the table first; you cannot just sync a primary key to the target database if the target table uses a different column name. -
Resolution
WORKAROUND
None
STATUS
Waiting for fix to be released in a future version of Toad for SQL Server.
-
Defect ID
TSS-320