Not Comparing Object Permissions
Brian Donahue
Posts: 6,590 Bronze 1
Hi Steve,
I'd just like to point out that the Show SQL window works independently
of the comparison settings. Regardless of your comparison settings, the
'Show SQL' window simply displays a script of the object that you've
registered in the database.
Regards,
Brian Donahue,
Technical Support
"Steve - DND" <ng@digitalnothing.com> wrote in message
news:FjxdZb$ODHA.1804@server53...
> So far SQL Compare has worked like a charm for me, but for some reason it
> will not get object permissions when two databases are compared. As such,
> these permissions cannot be compared, nor can they be scripted for update
on
> the destination server.
>
> In Options "Ignore Object Permissions" is *not* checked, and when I open
up
> the difference comparison, "Show Permissions" *is* checked. Is there
> something I'm doing wrong here?
>
> Thanks,
> Steve
>
>
I'd just like to point out that the Show SQL window works independently
of the comparison settings. Regardless of your comparison settings, the
'Show SQL' window simply displays a script of the object that you've
registered in the database.
Regards,
Brian Donahue,
Technical Support
"Steve - DND" <ng@digitalnothing.com> wrote in message
news:FjxdZb$ODHA.1804@server53...
> So far SQL Compare has worked like a charm for me, but for some reason it
> will not get object permissions when two databases are compared. As such,
> these permissions cannot be compared, nor can they be scripted for update
on
> the destination server.
>
> In Options "Ignore Object Permissions" is *not* checked, and when I open
up
> the difference comparison, "Show Permissions" *is* checked. Is there
> something I'm doing wrong here?
>
> Thanks,
> Steve
>
>
This discussion has been closed.
