Geeks With Blogs

News Please visit me at my new blog!!

profile for Aligned at Stack Overflow, Q&A for professional and enthusiast programmers
"free in Christ Jesus from the law of sin and death." Romans 8:2 (ESV) Check out the Falling Plates video on YouTube.
more about the Gospel
And then listen to Francis Chan speaking at LifeLight in SD.

Programming and Learning from SD

I enjoyed listening to Databases in Continuous Delivery with Enrico Campidoglio on .Net Rocks and learning about tools to do CD with databases. I’ve looked at how to have the database schema in source control so that you can rebuild your database at a moments notice for different environments. The options we’ve came across as a team have included Database Projects In Visual Studio, Code First Migrations with Entity Framework, manually creating the scripts using Visual Studio’s data compare tools (tools > Sql Server > New Data or New Schema compare), and RedGate’s SQL Compare (which comes with a price).

We still haven’t made progress on automating changing the database in builds (see Agile Maturity Model defined by ThoughtWorks Inc.) and then having a practiced, low stress, automated way to update the production environment as well. The .Net Rocks podcast was a good discussion and pointed out some tools that look worth looking into. The comments mentioned a few as well.

Enrico Campidoglio’s talk at NDC London 2014

Posted on Wednesday, January 21, 2015 5:00 PM Entity Framework , Continuous Delivery | Back to top

Comments on this post: Databases in Continuous Delivery

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Aligned | Powered by: