Delegating SQL Compare and SQL Data Compare to Application Role when using SDK
Dovetail
Posts: 2 New member
We use the SQL Compare and SQL Data Compare SDKs in order to allow our installer program to upgrade our application databases in SQL Server. Our application runs on SQL server 2008 R2 or greater. We would like to allow the user executing the installer to be a lower-privileged user (integrated security) than the db_owner access needed to perform all the appropriate changes. Our thinking is to create an "installer" application role in SQL that the application can then utilize by running the sp_setapprole stored procedure. This would then let the application execute the desired compares and deploys with the appropriate privileges since they will be granted by the application role.
Is there a way to do this with the using the SDK?
Is there a way to do this with the using the SDK?
Tagged:
Answers
You have posted this request into the wrong forum. This is particular forum is for SQL Backup Previous Versions.
Also the SQL Comparison SDK has been retired and no longer available for download since August 2017
https://forum.red-gate.com/discussion/81556/retirement-of-sql-comparison-sdk
It is my belief that you cannot achieve your goal using the SDK, to execute the installer user a lower privilege user.
The SDK will require the same security permissions for SQL Compare and SQL Data Compare:
https://documentation.red-gate.com/sc13/getting-started/requirements/permissions-required-to-use-sql-compare
There maybe something interest to you in the reference documentation available via this help article:
https://documentation.red-gate.com/rp/sql-comparison-sdk/sql-comparison-sdk-12-documentation
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
I do realize the SDK was discontinued and appreciate the reply. Will review the links and reply again if I am able to determine a path.
Thanks again