Comparing two databases with insufficient permissions
IÃ¢â‚¬â„¢m trying to compare two databases Ã¢â‚¬â€œ DEV and UAT instances. On DEV we have dbo right, on UAT we donÃ¢â‚¬â„¢t. I want to see difference in tables and their definitions (mainly columns) + view (names, definitions are not required) and stored proc. Can this be accomplished in SQl Compare? I definitely can be done in ApexSQL Diff 2008, but in SQl Comapre I keep getting insufficient permissions error where ApexSQL Diff 2008 shows the same message as a warning and still can produce the report. This is quite urgent, can you assist please?