Home → Questions →

Automating database migrations

• Edit

rajindersingh

23 Mar, 2015 07:50 PM

One of my teams is using entity framework. They use code first database migrations. We have started using AppVeyor to deploy our application to Azure. I have been asked to automate database migrations.
I have seen a few messages from last year where others were trying to automate this process and they were told that a new version appveyor will make it easier.

Can anyone share any examples of how to automate database migrations?

Thanks

1. Support Staff 1 Posted by Feodor Fitsner on 24 Mar, 2015 06:16 AM

   

   How do you currently do EF migrations (without AppVeyor)?

   • Edit

2. 2 Posted by rajindersingh on 16 Apr, 2015 03:29 PM

   

   Right now a developer uses visual studio and manually deploys the application to the target environment. This updates the databases based on the code changes.

   If found a few folks using TeamCity doing this. They use a command line tool called Migration.exe

   https://gist.github.com/mikecole/7222251

   http://www.farreachinc.com/blog/far-reach/2013/11/07/entity-framework-part-3-migrations

   I am hoping one of the existing users is already doing this so we can benefit from their experience.

   Thanks

   • Edit

3. Support Staff 3 Posted by Feodor Fitsner on 17 Apr, 2015 01:49 AM

   

   Looks at this conversation: https://twitter.com/DrJohnProctorUK/status/587343930158669824

   • Edit

4. 4 Posted by rajindersingh on 17 Apr, 2015 06:37 PM

   

   This helps a lot. Thanks

   • Edit

5. Ilya Finkelshteyn closed this discussion on 25 Aug, 2018 01:55 AM.