Compare permissions only?

I'm comparing two databases with many known column name changes and data type changes. There are many permissions discrepancies, however, that I'd like to resolve. Is there a way I can compare objects' permissions *only* using SQL Compare?


  • I don't think there's a way to do this at the moment, unfortunately. There's an 'Ignore permissions' project option you could set if you wanted to look at fixing the column discrepancies first, but there isn't an inverse option that ignores everything except permissions.
  • Would still like to see this functionality.  We have the same issue.  Scenario is comparing permissions between old database and a new upgraded database, or database that has been created from scratch that needs the same permission changes made.
Sign In or Register to comment.