script includes ALTERs when 'Use Drop and Create' is enabled

patana

I just installed the trial version SQL Compare 11.1.3.30 and I've selected the option to "Use Drop and CREATE instead of ALTER" and when the script is created it still includes ALTER statements.
"Add object existence checks" checkbox is also checked.
Is this functionality not supported or I'm doing something wrong?

Alex B

Hi Patana,

According to the documentation the "Use DROP and CREATE instead of ALTER" only applies to the following objects:

* Views
* Stored Procedures
* Functions
* Extended Properties
* DDL Triggers
* DML Triggers

Are the ALTER statements that are being included not on this list of objects?

Kind regards,
Alex

patana

I see ALTER being used for Functions in my script. At least that how far I checked since my generated script is very large.

Alex B

Hi Patana,

When you go through the deployment wizard to create the script are there any dependencies listed in step 3? I do not believe the dependencies are included in the options from the main comparison (i.e. if you filter out stored procedures in the comparison but there are dependent stored procedures and you include them, they will show up in the final deployment script). If this is the case then you will need to exclude the dependencies in step 3 of the deployment wizard.

Kind regards,
Alex