How do I sync with no permissions?

homey24601homey24601 Posts: 3
edited December 22, 2010 8:11AM in SQL Compare Previous Versions
I am trying to sync a database down from a company server to my personal SQL database for local development. There are several permissions on DOMAINNAME/usernames that I don't have and don't want on my machine. I'll be using a local admin login. Whenever I try to sync it always failes because the username DOMAIN\user is not available. WHen I say sync everything but uncheck users and groups it still tries to give permissions non-existent users and it fails. I'll take care of local user (me). I just need the meat of the DB.

Is there a way to get it to push down everything but the users and groups?

Thanks,
Patrick
· Share on Twitter

Comments

  • James BJames B Posts: 1,124 Silver 4
    Filtering out users and groups is a good start. You may also need to go to the Options tab of your project, and tick the option to Ignore "Permissions" and "Users' Permissions and Role memberships".
    The other potential cause is if dependent objects are perhaps triggering the permissions to be included, but try with the above options set and see if it helps.
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
  • homey24601homey24601 Posts: 3
    Thank you. I'll give that a try.
    · Share on Twitter
Sign In or Register to comment.