Activity overview
Latest activity by Ant
My bad, it looks as though I wasn't selecting the insert statement. Thanks / comments
My bad, it looks as though I wasn't selecting the insert statement.Thanks
Error when reformatting Merge statement
Hi,Whenever I reformat a MERGE statement I get the following errorsI get the semicolon issue when I have an insert from Merge command and the Apply Layout error when performing. a Merge on its own....
Deploying the same changes to multiple copies of the same databases
Hi,We're looking at deploying the same changes to our multiple copies of our customer databases and are currently using SQL Compare in TeamCity (CI) (Compares against an empty database and a databa...
We are going to automate the process wit hour provisioning app, so hopefully we will not need too much clicking... Thanks, / comments
We are going to automate the process wit hour provisioning app, so hopefully we will not need too much clicking...Thanks,
Hi ALex, Thanks for this, it may be useful in the future, but we've gotten around the issue by letting Octopus do all of the deployments and we are controlling that with multiple tenants, created by our web based provisioning service. Time will tell whether this will scale! Cheers, Anthony / comments
Hi ALex,Thanks for this, it may be useful in the future, but we've gotten around the issue by letting Octopus do all of the deployments and we are controlling that with multiple tenants, created by...
Actual changes required are : Update [dbo].[DeploymentProcess] SET json = REPLACE (REPLACE(REPLACE([JSON],'Cannot find DLM Automation','Cannot find SQL Change Management'),'Import-Module DLMAutomation','Import-Module SqlChangeAutomation'),'Get-Module -ListAvailable -Name DLMAutomation','Get-Module -ListAvailable -Name SqlChangeAutomation') where [Id] = 'deploymentprocess-Projects-1' Update [dbo].[ActionTemplate] SET json = REPLACE (REPLACE(REPLACE([JSON],'Cannot find DLM Automation','Cannot find SQL Change Automation'),'Import-Module DLMAutomation','Import-Module SQLChangeAutomation'),'Get-Module -ListAvailable -Name DLMAutomation','Get-Module -ListAvailable -Name SQLChangeAutomation') where [Id] = 'ActionTemplates-1'
/ comments
Actual changes required are :Update [dbo].[DeploymentProcess]SET json = REPLACE (REPLACE(REPLACE([JSON],'Cannot find DLM Automation','Cannot find SQL Change Management'),'Import-Module DLMAutomatio...
I found a way to do it. Update [dbo].[ActionTemplate] SET json = REPLACE (REPLACE([JSON],'Import-Module DLMAutomation','Import-Module SQLChangeManagement'),'Get-Module -ListAvailable -Name DLMAutomation','Get-Module -ListAvailable -Name SQLChangeManagement') where [Id] = 'ActionTemplates-1' / comments
I found a way to do it. Update [dbo].[ActionTemplate]SET json = REPLACE (REPLACE([JSON],'Import-Module DLMAutomation','Import-Module SQLChangeManagement'),'Get-Module -ListAvailable -Name DLMAutoma...
Is there any way to change the template without ceating a copy? / comments
Is there any way to change the template without ceating a copy?
Yep I eventualy found this, I also need to change the Import-Module DLMAutomationto SQLChangeAutomation / comments
Yep I eventualy found this, I also need to change the Import-Module DLMAutomationto SQLChangeAutomation
Octopus Tentacle Error - DLM-Automation not installed - Yet it is
Hi,I have an octopus server set up to deploy to a tentacle on another server and the tentacle is complaining that DLM automation is not installed, which I suppose it isn't as I have now switched to...