Red Gate forums :: View topic - Comparing two databases with insufficient permissions
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

Comparing two databases with insufficient permissions

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
magomedov



Joined: 25 Mar 2014
Posts: 1

PostPosted: Tue Mar 25, 2014 11:25 am    Post subject: Comparing two databases with insufficient permissions Reply with quote

Hi team,
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?
Thanks.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 684
Location: Cambridge

PostPosted: Wed Mar 26, 2014 12:23 pm    Post subject: Reply with quote

Thanks for your post.

If you do not have dbo rights, granting the VIEW DEFINITION permission is sufficient to compare unencrypted objects in SQL Server 2008 and SQL Server 2005 databases. However, sysadmin permissions are required to decrypt encrypted stored procedures.

More about permissions here.

Let me know if this helps.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
robertstroke



Joined: 13 May 2014
Posts: 1

PostPosted: Tue May 13, 2014 10:55 am    Post subject: Reply with quote

Any other option aside from said suggestion? It is a bit complicated for me to that. However, the recent case of Erik Prokopi, who smuggled dinosaur skeletons and sold them, is among the more notable instances of fossil smuggling. Believe it or not, there is a thriving underground for dinosaur bone fragments.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group