How to Exclude Dependencies while using SQL Change Automation.

ybhole

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 !

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.