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

Permissions on objetcs when using command line utility

cebnetcebnet Posts: 2
edited November 12, 2012 6:47AM in SQL Compare Previous Versions
Is it possible to extract permissions on objects in a database when creating a snapshot using the command line utility


  • Options
    Eddie DEddie D Posts: 1,788 Rose Gold 5
    Hi Cebnet,
    Thank you for your post into the forum.

    A SQL Compare snapshot file is a binary file containing information regarding the structure of a database. So if the database has permissions set on individual objects, the snapshot file will contain this information.

    When you compare the snapshot file with another data source, you will be able to see the differences in permissions and create a deployment script.

    This SQL Compare help ARTICLE contains further advice.

    Many Thanks
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.