What comparison options do you have
defined in the release if not using the default? The option to include
dependencies is enabled by default, if you disable it, do you still get
the same issue?
You can disable the option in the
release by adding -IncludeDependencies (it's important to include the
hyphen (-) which disables the option specified.
Here's the documentation which outlines how to use SQL Compare options with SQL Change Automation add-ons:
Great news! Thanks for the update and I'm glad it is no working as expected.
I'll close the support ticket we have open for you. Please do reach back out if anything else comes up.
Thanks for your query about SQL
Change Automation. You should be able to completely prevent objects from
other schemas from being deployed by adding a filter to the project.
Please see the documentation below on how to use filters in SQL Change
I hope this helps. Please let me know how you get on or if you have any further questions.
Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal