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

SQL Compare option "Ignore authorization on schema objects" is not being triggered

Hi Redgate,

I'm having issues with a SQL Compare option, which is not being triggered in my deploy. I'm trying to ignore any changes made to a schema that relates to authorization, since my env's have diffrend users assigned to the schema. But my deployments keep overwriting the authorization because it's "inside" source control. I have the SQL Compare Option "Ignore authorization on schema objects" selected in both SQLCompare.exe

SQL Compare cmd:
1gr129ed5qju.png

SQL Compare tool:
2nmf4npepbc7.png

What am I missing?

Thanks,

Tim
Bas_K
0

Comments

3 comments

Sort by
  • sam.blackburn
    I think the issue is that SQL Compare defines "Schema Objects" as objects inside a schema. This option therefore affects tables, views etc but not the schemas themselves. I think you'll need to filter out schemas in order to deploy just the changes you care about. Does Compare work as expected in that case?
    sam.blackburn
    0
  • Bas_K
    Hi Sam,

    I do not want to exclude my schema entirely, I want the schema to be there, just not with this authorization change. Is there a way to filter this in sql source control?

    Tim
    Bas_K
    0
  • sam.blackburn
    Unfortunately this is not currently possible, I think because the specification of ownership is the main point of having a schema. I suspect ignoring authorization could create a lot of unexpected behaviour, although it's hard to be sure without understanding your use case.
    sam.blackburn
    0

Add comment

Please sign in to leave a comment.