Send schema information from Octopus Deploy
It would be extremely beneficial to be able to send schema information to DLM Dashboard as part of an Octopus deployment, as otherwise every change to our integration database is being marked as a drift, even when the code has come through our CI process and deployed via Octopus. Ideally it would work just as the TeamCity one does - marking the changes as an update from continous integration.
This makes the Dashboard far less useful for us as we can never know, without manual intervention, what version of the schema is in a given database at one time.
Ben Hughes
shared this idea
-
Joshua Ferguson
commented
All of what Ben stated also goes for me and my team. As I'm implementing the DLM automation tools into our development and deployment pipeline I'm getting less use out of the DLM dashboard.
Frankly, Octopus Deploy has the best info as to the state of my database schemas because of versioning numbers and commit messages. I'd really like to see DLM dashboard pick up that role for us.
Currently, it's solely used to make sure random changes aren't occurring in our production environments, but I know we could be getting more use out of it.
-
Are you using DLM Automation (previously called SQL CI and SQL Release)?
If so you can pass information about a schema version to DLM Dashboard when you build a database package. DLM Automation produces a package representing the state of a database, which along with a version number can be passed into DLM Dashboard via a web API. Typically we'd expect this would be during your CI process (thus in a CI server), rather than at release time in Octopus. That means that DLM Dashboard would be able to 'spot' that schema version when deployed to any subsequent environments.
DLM Automation: http://www.red-gate.com/products/dlm/dlm-automation/
Documentation: http://documentation.red-gate.com/display/DDB1/Investigating+schema+changes#Investigatingschemachanges-CI_Integration
Commandlet reference: https://documentation.red-gate.com/display/SR1/Publish-DlmDatabasePackage
What the API can't currently do is mark an individual deployment as approved. We have a request open for that on https://redgate.uservoice.com/forums/256011-dlm-dashboard/suggestions/7934943-automatically-approve-and-mark-octopus-deploy-chan
