Schema Compare Sync wizard script drops and recreates unexpected Foreign Key of child table. (4221916)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Schema Compare Sync wizard script drops and recreates unexpected Foreign Key of child table.
Description

Using Schema Compare user generates Sync script. The Comparison shows one difference between two parent tables with one able having an additional column. In addition to adding this column name to parent table, sync script also drops and recreates a Foreign key in the child name which to customer is not necessary and causes trigger issues.
Resolution

WORKAROUND:
None
STATUS:
Waiting for fix to be released in a future version of Toad for SQL Server.
Defect ID

CR91175

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title