Reset Entity-Framework Migrations

entity-framework database-migration entity-framework-migrations
Todd picture Todd · Jul 27, 2012 · Viewed 204.2k times · Source

I've mucked up my migrations, I used IgnoreChanges on the initial migration, but now I want to delete all my migrations and start with an initial migration with all of the logic.

When I delete the migrations in the folder and try and Add-Migration it doesn't generate a full file (it's empty - because I haven't made any changes since my last, but now deleted, migration).

Is there any Disable-Migrations command, so I can rerun Enable-Migrations?

Answer

Todd picture Todd · Jul 27, 2012

You need to :

  1. Delete the state: Delete the migrations folder in your project; And
  2. Delete the __MigrationHistory table in your database (may be under system tables); Then

  3. Run the following command in the Package Manager Console:

    Enable-Migrations -EnableAutomaticMigrations -Force

    Use with or without -EnableAutomaticMigrations

  4. And finally, you can run:

    Add-Migration Initial

Related questions

EF Migrations: Rollback last applied migration?

This looks like a really common task, but I can't find an easy way to do it. I want to undo the last applied migration. I would have expected a simple command, like PM> Update-Database -TargetMigration:"-1" Instead, all …

Read More
How do I enable EF migrations for multiple contexts to separate databases?

How do I enable Entity Framework 5 (version 5.0.0) migrations for multiple DB contexts in the same project, where each context corresponds to its own database? When I run Enable-Migrations in the PM console (Visual Studio 2012), there's an error because of there …

Read More
EF migration shows empty Up() Down() methods

I have a local database that is currently in it's second version and should now go to it's third version. The code for the previous migrations was generated by another programmer so I am assuming I am doing something wrong …

Read More