I'm using the latest Visual Studio 2019 SSDT (SQL Data Tools). It crashes doing the following: Compare a table with PK constraint that has one column and also another unique constraint that has two columns as the key. In the comparison options, set the index to use as the unique index, not the PK index Uncheck the PK column so that its not included in the comparison. Press Finish so that the comparison is performed. In the results upper pane click the table that was compared In the results lower pane, click in the Update table CRASH AND BURN Your VS instance is now toast.

SSDT crash with two column key

Roberto Ortega 6

I'm using the latest Visual Studio 2019 SSDT (SQL Data Tools). It crashes doing the following:

Compare a table with PK constraint that has one column and also another unique constraint that has two columns as the key.
In the comparison options, set the index to use as the unique index, not the PK index
Uncheck the PK column so that its not included in the comparison.
Press Finish so that the comparison is performed.
In the results upper pane click the table that was compared
In the results lower pane, click in the Update table
CRASH AND BURN
Your VS instance is now toast.

Tianyu Sun-MSFT 29,446 Reputation points Microsoft Vendor

2020-11-23T08:28:05.367+00:00

Hello @Roberto Ortega , thank you for taking time to post this issue in Microsoft Q&A forum. I followed the steps that you shared with us and tested on my side, but I blocked. So could you please share more information with me for reproducing this issue and for further check? Such as the structure of the tables, some related screenshots, versions of SSDT, and some other detailed steps?