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

Command line: IgnorePermissions not working on storedprocs?

Having a problem with the command line SQLCompare.exe that I just can't figure out. I have two dbs that I want to compare and I want to ignore the permissions differences on stored procs between the two. In the gui, when I select "Permissions" under the Options tab, below Ignore it works exactly as I expect - it only shows the differences between the actual code of the stored procedure. When I use the /Options:IgnorePermissions flag it does NOT ignore the permissions.

Am I using the wrong flag? Does it just not work from the command line?

I'm considering making the upgrade from a regular license to the pro license for the command line ability but if I can't get it to ignore permissions it won't work for me.

Thanks!
matthewthacker
0

Comments

2 comments

Sort by
  • matthewthacker
    Nevermind. ID10T error.
    Was running SQLCompare.exe in Powershell. Commas do different things in Powershell.
    matthewthacker
    0
  • Linda Hawksworth
    Thanks for the confirmation that you have resolved your issue.
    Linda Hawksworth
    0

Add comment

Please sign in to leave a comment.