sql data compare permission error

ronald

I got reading DDL error when using sql data comapre at registering database stage. The sql account already have db_owner role in the database. What other permission it need to resolve the issue?

Thanks

peter.peart

Thanks for your post. The below article on our support site details the minimum permissions required for SQL Data Compare:

http://www.red-gate.com/supportcenter/C ... %20Compare

HTH!

Pete

ronald

Peter,
thank you for your reply. I have seen the article before, and added dbo_owner to the sql account. But still have the error At "Registering database - -Reading DDL triggers." "The user does not have permission to prerform theis action." The database is backup/restore from another server. I am using Red Gates Defaults for the options tab.
Any further idea?

peter.peart

What about VIEW DEFINITION and being a member of the PUBLIC role?

Your best bet is to try viewing DDL triggers through SSMS with that account; if you can't do it there, you aren't going to be able to do it with SQL Data Compare I'm afraid and it comes down to it being a SQL Server permissions issue that you will need to resolve with your DBA and SQL Server Books Online.

The article I linked to previously though contains full details of all permissions required, so if you believe you've followed the instructions to the letter, as I said try looking at it in SSMS. If it is then working in SSMS but not SQL Data Compare, by all means let me know.

HTH!

Pete