Minimum permissions needed for SQL Compare?

I'm sure this has been asked (and answered) before, but I can't find anything in the forums. What is the minimum security/role needed to run SQL Compare against a prod DB? Surely there must be a way to perform a compare without using a sysadmin level login? We just tried a compare with a 'read only' login and most objects are missing on the prod side. We obviously don't want to assign individual permissions at the object level. Any suggestions appreciated!

UPDATE: I believe I just found a post on this. Sorry for the duplicate..

krshort November 20, 2017 19:12

Comments

1 comment

hi @krshort - thank you for your question, I appreciate you may have found your answer elsewhere already, but on the SQL Compare Documentation there's a fairly straightforward breakdown of SQL Compare permissions: https://documentation.red-gate.com/sc13/requirements/permissions-required-to-use-sql-compare.

Let us know if you need anything else!

PlantBasedSQL November 22, 2017 10:38

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Minimum permissions needed for SQL Compare?

Comments

Add comment