Missing drop and create primary key scripting for alter column statement at schema compare tool

by Jun 19, 2018

Hi,we use aqua studio V18.5 on a Ms Sql 2016 Server to compare two databases with the schema compare tool. Between the source and destination database are some differences in datatypes. Unfortunatly in a primary key column. Aqua studio recognizes it successfully and create an alter column. But running the script it stops at this point. Sql can’t handle the alter columns, if it refers to a primary key. So I have to drop the primary key first, and create it afterwards.


Why does’nt Aqua studio do this for me ? Is there any option where I can set this feature ?