Activity overview
Latest activity by AlbertWong
There is currently no urgency. My management does want to move to Linux hosts due to costs, as I mentioned. Our Jenkins agents are running on both Windows and Linux, but there'll be a time when management won't want to license new Windows servers for jenkins agents. At that point, we'll have to figure out a way off the SQL Change Automation process.
I was thinking if the SQL Change Automation ran under PowerShell Core, we'd install PowerShell Core on our Linux agents and use those for deployments.
/ comments
There is currently no urgency. My management does want to move to Linux hosts due to costs, as I mentioned. Our Jenkins agents are running on both Windows and Linux, but there'll be a time when man...
SQL Change Automation with PowerShell Core
For our Jenkins agents we use for our CI builds, we are moving away from Windows hosts to Linux hosts due to costs. We currently are using the SQL Change Automation 3.x product for some of our data...
Hello, I am trying to run a migration script which errors with a similar message. What is the workaround? Exception syncing database PPD. Exception was SQLCompare.exe terminated with the exit code 79: Databases not identical. The source and target databases were supposed to be identical, but were different. SQLCompare.exe produced this error output: Error: Comparison of 'Scripts.h5ufk3wg.nuc' and 'hcodev.ad.maximusdev.com,50002.PPD' failed: A duplicate definition was found for the column '[dbo].[PlanChildPlan].PlanTypeID'. Ensure that case sensitivity options are set correctly and all object creation scripts are valid.If the problem persists, contact Redgate support. Comparison of 'Scripts.h5ufk3wg.nuc' and 'hcodev.ad.maximusdev.com,50002.PPD' failed: A duplicate definition was found for the column '[dbo].[PlanChildPlan].PlanTypeID'. Ensure that case sensitivity options are set correctly and all object creation scripts are valid.If the problem persists, contact Redgate support. / comments
Hello, I am trying to run a migration script which errors with a similar message. What is the workaround?Exception syncing database PPD. Exception was SQLCompare.exe terminated with the exit code 7...
No, I would like to disable the single migration prior to creating new release artifacts. I tried removing the migration reference from DeploymentOrder.json, but SQL Change Automation displays an error that it expects the migration but it can't find it. / comments
No, I would like to disable the single migration prior to creating new release artifacts. I tried removing the migration reference from DeploymentOrder.json, but SQL Change Automation displays an e...
Disable a single migration from a set of migrations
Hello,I'm using SQL Change Automation to handle our database deployments. During development, I've created a number of database migrations. How do I disable one migration so it isn't considered whe...
Oh, I did not create a pre-deployment script to create the filegroup. Let me try that. / comments
Oh, I did not create a pre-deployment script to create the filegroup. Let me try that.
Invoke-DatabaseBuild with Table with a Full Text Index
Hello,
I'm trying to figure out why I cannot deploy my database repo to my target database. It seems to be related to a filegroup for a full text index on one of the tables.Invoke-DatabaseBuild, SQ...