How do I sync with no permissions?
homey24601
Posts: 3
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
Is there a way to get it to push down everything but the users and groups?
Thanks,
Patrick
Comments
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.
Redgate Software