SQL Change Automation Powershell permissions

When working with SQL Source Control Projects, SQL Change Automation PowerShell requires the same permissions as SQL Compare:

Permissions required to use SQL Compare

Build step specific:

Besides the permissions listed above please note that the following permissions might be required when doing the schema validation:

-  sysadmin if using the Temporary Server option (because when it creates the Database it sets TRUSTWORTHY ON).

db_owner if using the Temporary Database option.

Was this article helpful?

3 out of 3 found this helpful
Have more questions? Submit a request