Posts
Sort by recent activity
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.
Octopus Deploy ShadowServer properties
I'm using the latest available Redgate - Create Database Release step template in Octopus deploy, and I'm getting a "A deployment preview report could not be generated" message in changes.html. Loo...
If Object_ID() Drop Procedure fails to generate
SCA fails to generate IF OBJECT_ID('X') IS NOT NULL DROP PROCEDURE X if it's unable to parse the stored procedure.I have a couple of stored procedures in an existing databases that contain, let's s...
Feature Request: Open .SQL files from file explorer
It would be great if Multi Script supported opening .sql files from file explorer. While I can register Multi Script as an Open With target, it doesn't actually open the selected file. Additionally...