Permissions dropped via CLI that aren't flagged as differences
I am comparing between a sqlproj and a remote database using the following command line switches.
& "C:\Program Files (x86)\Red Gate\SQL Compare 14\sqlcompare.exe" `
"/include:StoredProcedure" "/include:Function" "/include:View" "/include:Identical" `
"/report:Report.html" "/ReportType:html" `
My goal is to only deploy changes to stored procedures, views, and functions that already exist in both the source and destination or are new in the source. The synchronize operation should not drop anything. My understanding is that /exclude:Additional handles that for me.
However since activating this last week, I've seen almost 50 permissions being dropped randomly. Sometimes when the command runs nothing is dropped, sometimes 5-10 permissions get revoked. The permissions being revoked are scripted as follows:
REVOKE VIEW CHANGE TRACKING ON [schema].[table] TO [user]
When I inspect the report these permissions are not shown as differences. I am using SQL Compare V220.127.116.1189
Is this intended behavior based on the switches I have selected? Do I need to use an exhaustive set of excludes? Why is the behavior of the drops erratic?
At one point even some sequences were altered using the above switches. How does that happen?
0 · Share on Twitter