We are using Octopus Deploy Redgate agent for our deploys to SQL Server that uses SQL Compare. I have a schema that we excluded in our filters. However when deploying the database, i am getting error for excluded schemas/views as they are getting included as Dependencies. Specifically, they are all sp_refreshview procs. How could I run my script without including the excluded views.
Comments
3 comments
-
I specifically removed the option for IncludeDependencies - but it doesnt seem to work
-
Never mind. Found the solution myself. It was a default option that could be removed by adding a "-" symbol. So it was -IncludeDependencies
-
Hello @lifeiscode
Thanks for posting to the forum. Glad you were able to resolve the issue by adding "-" to disable to comparison option.
Cheers,
Pete Ruiz
Redgate Product Support
Add comment
Please sign in to leave a comment.