New to Redgate DLM

Jeff's Avatar

Jeff

14 Jul, 2017 08:00 PM

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?

  1. Support Staff 1 Posted by Daniel Fischer on 17 Jul, 2017 07:05 AM

    Daniel Fischer's Avatar

    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-database...

    Which mostly links to the RedGate documentation they have for Octopus: https://documentation.red-gate.com/display/DLMA2/Walkthrough%3A+Set...

    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

  2. Paul Stovell closed this discussion on 31 Oct, 2017 08:34 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac