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

Not Comparing Object Permissions

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited June 27, 2003 5:51AM in SQL Compare Previous Versions
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.


Brian Donahue,
Technical Support

"Steve - DND" <ng@digitalnothing.com> wrote in message
> 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
> the destination server.
> In Options "Ignore Object Permissions" is *not* checked, and when I open
> the difference comparison, "Show Permissions" *is* checked. Is there
> something I'm doing wrong here?
> Thanks,
> Steve
This discussion has been closed.