Activity overview
Latest activity by DavidWNAZ
Thanks...that is exactly what we're doing for now. Thank you for all your input. Have a great evening! / comments
Thanks...that is exactly what we're doing for now. Thank you for all your input. Have a great evening!
Thank you, Peter. Is there a roadmap to make that happen? I'm trying to automate creating an UNDO script from a developer-provided SQL script in an Azure Devops pipeline. / comments
Thank you, Peter. Is there a roadmap to make that happen? I'm trying to automate creating an UNDO script from a developer-provided SQL script in an Azure Devops pipeline.
Flyway Snapshot
We're using the Flyway snapshot command to create a snapshot of the target database prior to a migration. But when attempting to open the file in SQL Compare, it errors in opening it. Are they in...
Thank you Dan! That was it. I was not aware that the options were case-sensitive. I appreciate the help. / comments
Thank you Dan! That was it. I was not aware that the options were case-sensitive. I appreciate the help.
I've redacted private info...but this is the full command. Some clarification, we are using this command in an Azure Devops pipeline using an on-prem agent. flyway -baselineOnMigrate=true -outOfOrder="true" -configFiles="C:\****\flyway.conf" -locations="filesystem:C:\****\migrations" -user="*****" -password="***" -url="jdbc:sqlserver://????????:????;databaseName=****;encrypt=true;integratedSecurity=true;trustServerCertificate=true" -licenseKey=***** migrate -cherrypick="6" info -baselineVersion=1 -cleanDisabled=true -check.reportFilename="C:\Drift-And-Change-Report.html" / comments
I've redacted private info...but this is the full command. Some clarification, we are using this command in an Azure Devops pipeline using an on-prem agent.flyway -baselineOnMigrate=true -outOfOrd...
Flyway Migrate -CherryPick
Today we tried to use CherryPick with Flyway CLI v9.15 (within Azure Devops) but received an error.
##[error]ERROR: Unknown configuration property: flyway.cherrypickHowever, when we used the same o...
SQL Clone Agent Cert
If we set up the SQL Clone application to use a CA created cert, will that cert be carried over to the Agent that we install? Currently, when an Agent is installed it appears to use a self-signed ...
Failed Build in Azure
Good morning, We're encountering a build error with invalid column names. We know the tables/columns exist when we exclude everything BUT the tables, the build runs successfully. But as soon as w...
Thanks for the input. I'll include that once I get a test environment configured. Still waiting for an answer on that. I'm still relatively new to PS, so thanks for the tips! / comments
Thanks for the input. I'll include that once I get a test environment configured. Still waiting for an answer on that. I'm still relatively new to PS, so thanks for the tips!
Sure! ________________________________________________________________________________ Param($ImageName) Connect-SqlClone -ServerUrl 'http://clone.server:14145'
$image = Get-SqlCloneImage -Name $ImageName $clones = Get-SqlClone -Image $image $elapsed = [System.Diagnostics.Stopwatch]::StartNew() "Started at {0}, removing {1} clones for image ""{2}""" -f $(get-date) , $clones.Count , $image.Name $clones | foreach { # note - '{' needs to be on same line as 'foreach' ! $_ | Remove-SqlClone | Wait-SqlCloneOperation "Removed clone ""{0}""" -f $_.Name ; }; "Total Elapsed Time: {0}" -f $($elapsed.Elapsed.ToString()) _______________________________________________________________________________ / comments
Sure!________________________________________________________________________________Param($ImageName) Connect-SqlClone -ServerUrl 'http://clone.server:14145'
$image = Get-SqlCloneImage -Name $Imag...