Database deployments

Legacy Uncategorised
1

What about database deployments? Can Octopus handle this? Can we do a database deployment to one server and the MVC app to another in the same deployment?

2

Hi Craig,

You can. You would have two “Steps” in your project:

  • Step 1: deploy the database (using a tool like DbUp, Migrator.net, DropkicK, or EF Code First Migrations)
  • Step 2: deploy the MVC app

I’ll try to get some KB articles written showing how to set this up step-by-step.

Hope that helps,

Paul

3

Hi Craig,

In case it is useful, here’s a blog post showing how I would handle database deployments in Octopus:

Paul

4

Hello Paul,

This seems to be an old post but relevant to what I am looking for.

Do you have any KB article for EF Code First Migrations? Can you point me to it?

BR,
Altaf

5

Hi Altaf,

Thanks for getting in touch! We do not have anything specific, but I did find this blog article:
http://danpiessens.com/blog/2014/06/10/deploying-databases-with-octopus-deploy-part-2/

Hope that helps!
Vanessa

6