Entity Framework 6 Model First Migration

Question

Desired outcome:

Use model first approach with Entity Framework and allow changes to deployed database/ model to be done automatically based on the changes in the model. Automatic schema difference script generation to allow smooth migrations.

Is there a way to perform migrations in model first EF6? I can see code first migrations topics all over, but nothing much on Model First.

Options I saw so far:

• Database generation power pack (seems outdated)
• somehow convert to code first, then use migrations (not desirable, as I like to have a visual designer)
• somehow piggy back on code first migrations (http://blog.amusedia.com/2012/08/entity-framework-migration-with-model.html : this is for EF5, got error that can't run migrations on Model First)
• some third party tools?

Puerile

Answer 1

As far as I know there still is no automatic migration for Entity framework model first.

Our approach is:

1. Create a fresh database from the model.
2. Create a diff script to migrate the old database to the new one.
3. Verify that this diff script is indeed correct. Always double check what your automation tool creates.

We first used Open DB diff for our model first migrations. After that we switched to Redgate's SQL compare because it produced more reliable migrations . In our experience DbDiff produced a lot of unnecessary SQL because it bothers with the order that columns are in, and has some other issues like foreign keys constantly being dropped and re-added. Aside from that it still did the job fine, but we had to do a lot of double checking on its generated SQL.

Silkworm

We ended up going with this approach as in a way it makes good sense. We have development database on local PC where one can do whatever they want, then propagate changes to test database and then to production. The workflow you described fits nicely in this sequence and so far looks like a very good solution. Marking as answered at this point. – Puerile