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

How to Exclude Dependencies while using SQL Change Automation.

How to Exclude Dependencies while using SQL Change Automation. in SQL Comapare UI there is option to exclude dependencies (check the attached file) 

We use SQL Change Automation from Octopus Deploy and only provide following options

NoTransactions,ForceColumnOrder,IgnoreDatabaseAndServerName,IgnoreFillFactor,IgnoreNotForReplication,IgnoreSquareBrackets,IgnoreUserProperties,IgnoreWhiteSpace,IgnoreWithElementOrder,IgnoreFileGroups


But we see that during actual deployment dependencies are included !
Tagged:

Answers

  • Options
    Hi ybhole,

    Thanks for posting on the Redgate forums.

    The include dependencies is a default option when using SCA. To turn this off you need to add 

    -IncludeDependencies

    To the SQL compare options in Octupus. Please do let me know if you need anything further.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
Sign In or Register to comment.