What are the challenges you face when working across database platforms? Take the survey
Options

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

patanapatana Posts: 3
edited February 18, 2015 2:52AM in SQL Compare 11
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?

Comments

  • Options
    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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
  • Options
    I see ALTER being used for Functions in my script. At least that how far I checked since my generated script is very large.
  • Options
    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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.