New to Redgate DLM

(Jeff) #1

We have a repo that’s controlled by RedGate, and triggering VSTS builds & OctopusDeployments correctly. However using (RedGate Deploy from Package) it assumes the database exists (and since it doesn’t - new deployment to a new db server) - and fails.

How do I get the database deployed and all changes since it was created sent to the new server. The 4 RedGate scripts I see in the community library don’t seem to cover this…or am I missing an important step?

(Daniel Fischer) #2

Hi Jeff,

Thanks for getting in touch. The first thing I can suggest is the following documentation page we have on deploying database changes. https://octopus.com/docs/deploying-applications/sql-server-databases#SQLServerdatabases-RedgateDLMAutomation

Which mostly links to the RedGate documentation they have for Octopus: https://documentation.red-gate.com/display/DLMA2/Walkthrough%3A+Set+up+Continuous+Integration+And+Release+Management#Walkthrough:SetupContinuousIntegrationAndReleaseManagement-Releasemanagement

Their documentation is quite extensive and should answer any questions you have. However, if you run into any issues with Octopus here that you need a hand with, please let me know.

If the documentation does not help you resolve this issue, you will need to attach a full deployment log for us to identify any issue that Octopus may be having here.
The following is a link to our documentation on retrieving a full deployment log: https://octopus.com/docs/how-to/get-the-raw-output-from-a-task

Best regards,
Daniel

(system) closed #4