How can we help you today? How can we help you today?

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 !
ybhole
0

Comments

1 comment

Sort by
  • Dan B
    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.
    Dan B
    0

Add comment

Please sign in to leave a comment.