What are the challenges you face when working across database platforms? Take the survey
Options

Octopus Deploy - Custom file name for change script and change report

GordonMPGGordonMPG Posts: 11 Bronze 1
edited April 17, 2017 4:06PM in DLM Automation
Hello,

Is there anyway to apply a custom name to the change script (Changes.sql) and change report (Changes.html). In octopus deploy we are generating multiple change scripts because we have multiple targets to update. So in the artifacts section its a little difficult for our data ops team to review the change scripts and reports, it looks like

npkbcf8enqqs.png

This is a little difficult to understand. I looked at the New-DlmDatabaseRelease documentation at https://documentation.red-gate.com/display/SR1/New-DlmDatabaseRelease but couldn't find a way.

Thank you!

Comments

  • Options
    GordonMPGGordonMPG Posts: 11 Bronze 1
    Fixed by creating a custom step template and using:

    New-OctopusArtifact "$exportPath\Reports\Changes.html" -Name "$DLMAutomationDatabaseName-Changes.html"
    New-OctopusArtifact "$exportPath\Reports\Warnings.xml" -Name "$DLMAutomationDatabaseName-Warnings.xml"
    New-OctopusArtifact "$exportPath\Update.sql" -Name "$DLMAutomationDatabaseName-Update.sql"
Sign In or Register to comment.