Use CREATE OR ALTER in the generated scripts in SQL Compare
3
votes

Have you tried the options in SQL Compare?
-
Naomi Nosonovsky commented
Is it in the latest SQL Compare? Which version? It is not in SQL Compare 14 I have