Entity structure: requires a simple solution for clean data migration

Question

I use the first structure of the entity structure, and I often need to perform database migration,

The EF database generation power supply is not very helpful, as this data migration never worked.

Moving the database here I mean by changing the model, and then I can update the existing database from the model, but create a new one.

Is there any free tool here invented here? Or will this be a new feature in the next release of EF?

PS I love django ORM.

Answer 1

, EF, , NORMA. ApexSQL Diff, ApexSQL . Diff , , "" , script. , ( - ).

ApexSQL Data Diff script , .

Visual Studio 2010 SQL Server 2008 R2. , , , , . , . . , , SQL Server 2008 R2.

Answer 2

4 . EF, , , DB " ".

, , , , , , . , . - , . EF "" , , "" , , , ... , .. , ...

Answer 3

It is not free, but it has a 30-day free trial: here is a tool that addresses this (using SQL-DDL incremental change scripts), as well as many other flaws in the EF4 designer:
http://huagati.com/edmxtools /

Introductory video:
http://huagati.blogspot.com/2010/07/introducing-model-comparer-for-entity.html