Posts
Sort by recent activity
Alert plain text emails
In typical Atlassian fashion, OpsGenie has been rolled into Jira Service Manager, and they've decided to not support HTML in the Description field: https://jira.atlassian.com/browse/JSDCLOUD-14402C...
Skip running in shadow database
I have a table where end users can insert records, and development needs to insert records via scripts.If we add them as a migration script, then they fail on the shadow database due to FK constrai...
SQL Clone service behaviors
Last night after our windows update installs completed and the VMs rebooted, 30 of our SQL Clone Agents failed to register with SQL Clone, likely due to the hosting server for SQL Clone rebooting a...
SQL Clone Powershell Client on Powershell Gallery
Is there a reason why the SQL Clone Powershell client isn't on the Powershell Gallery, so it can be installed with Install-Module?
Merge Conflicts on DeployChangesExecutionOrder
We're in the process of cleaning up our databases, and we're running into merge issues with the DeployChangesExecutionOrder project property.I attempted the "should work" fix in https://forum.red-g...
Generate three-part object reference validation report
We recently brought our entire sql database estate under SCA control. We disabled the three-part object reference validation early on, due to thousands of validation errors.Today I ran into a issue...
Where are release notes published for the Powershell modules?
I spent last night and today trying to figure out why a SCA build on TeamCity started to fail after a commit. The error had nothing to do with the changes, and then suddenly it's working again.Digg...
Azure DevOps YAML documentation
Where is the documentation for the Azure DevOps YAML task RedgateSqlChangeAutomationBuild@4?Specifically I want to run "canary" builds on windows-latest with SQL LocalDB, but the YAML article https...
Invalid Visual Studio File name
I'm attempting to create a new SCA project for an existing database, and have encountered this error:There's over 200 objects I'm attempting to initially import, so it's slow going identifying the ...
SQL Compare command line /scripts2 file encoding
I'd like to have SQL Compare to output UTF8 with BOM, however when I try the /SyncScriptEncoding option, I get this error: The /syncScriptEncoding switch cannot be used without the /scriptfile switch.