How can we help you today? How can we help you today?

How do I sync with no permissions?

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
homey24601
0

Comments

2 comments

Sort by
  • James B
    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.
    James B
    0
  • homey24601
    Thank you. I'll give that a try.
    homey24601
    0

Add comment

Please sign in to leave a comment.