Use CREATE OR ALTER in the generated scripts in SQL Compare
3
votes
![](https://secure.gravatar.com/avatar/daafe46f2b871c14abf2b36c0bd760cd?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
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