What are the challenges you face when working across database platforms? Take the survey

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?


  • Options
    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.
  • Options
    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.