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

database roles

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited November 25, 2005 10:00AM in SQL Compare Previous Versions
Hi Erik,

Thanks for your post. SQL Compare can migrate roles defined in the
databases that you are synchronizing, but it does not support adding users
to a standard role like db_datareader. I'm not sure that we can support
this, but I will look into it for you.


Brian Donahue
Red Gate Technical Support

"Erik Lenaerts" <elenaerts@icsat.com> wrote in message
> Hi Red-Gate,
> I use the SQL Compare tool to generate difference scripts and evertyhing
> seems to got really fine, except one thing.
> It appears that teh difference scripts don't contain db_roles. I miss
> statements like "exec sp_addrolemember N'db_datareader', N'userA'"
> Why's that? Any change of getting this fixed in the near future?
> Greetings
> Erik Lenaerts
> Belgium


  • Options
    Role membership is now supported in SQL Compare. If a user's role membership (including builtin roles) differs between databases, the appropriate script is added to change the user's role membership. In addition, if the role members are different, SQL Compare will add the user to the target database if necessary.
This discussion has been closed.