database roles

Brian Donahue

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.

Yours,

Brian Donahue
Red Gate Technical Support

"Erik Lenaerts" <elenaerts@icsat.com> wrote in message
news:GTzHPqb5DHA.1248@server53...
> 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
> ICSA T
> Belgium
>
>

Brian Donahue

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.