Compare permissions only?

ErikAlmquistErikAlmquist Posts: 1 New member
in SQL Compare
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?
Tagged:
· Share on Twitter

Comments

  • Mark JMark J Posts: 125 Bronze 5
    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.
    · Share on Twitter
  • samgreenesamgreene Posts: 6 Bronze 1
    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.
    · Share on Twitter
Sign In or Register to comment.