Source Control Decryption Error
My team and I are trying to use Redgate SQL Source Control for the initial commit of our SQL Server DB objects to Team Foundation Server online. We are using a git repository. Most objects are not having issues, but a recurring error for triggers, views, functions, and indexes is the following (across some DBs). Any suggestions or insight you can offer is appreciated.
The view/trigger/index/function cannot be decrypted in one or more of the datasources. Its contents cannot be compared and it cannot be synchronized.
I've spoken with the manager of our DBA team, and he recommended I reach out to Redgate directly for a workaround. Here is his response:
It does look permissions based as elevated permissions are required to decrypt db objects by default, and those permissions will not be granted on Production of course.
Are there any config options that have to be set on the source/destination when you run the tool?