Reset Entity-Framework Migrations

Question

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?

Solution 1

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
   

Solution 2

The Issue: You have mucked up your migrations and you would like to reset it without deleting your existing tables.

The Problem: You can't reset migrations with existing tables in the database as EF wants to create the tables from scratch.

What to do:

1. Delete existing migrations from Migrations_History table.

2. Delete existing migrations from the Migrations Folder.

3. Run add-migration Reset. This will create a migration in your Migration folder that includes creating the tables (but it will not run it so it will not error out.)

4. You now need to create the initial row in the MigrationHistory table so EF has a snapshot of the current state. EF will do this if you apply a migration. However, you can't apply the migration that you just made as the tables already exist in your database. So go into the Migration and comment out all the code inside the "Up" method.

5. Now run update-database. It will apply the Migration (while not actually changing the database) and create a snapshot row in MigrationHistory.

You have now reset your migrations and may continue with normal migrations.

Solution 3

How about

Update-Database –TargetMigration: $InitialDatabase

in Package Manager Console? It should reset all updates to its very early state.

Reference link: Code First Migrations - Migrating to a Specific Version (Including Downgrade)

Solution 4

To fix this, You need to:

1. Delete all *.cs files in the Migrations Folder.

2. Delete the _MigrationHistory Table in the Database

3. Run Enable-Migrations -EnableAutomaticMigrations -Force

4. Run Add-Migration Reset

Then, in the public partial class Reset : DbMigration class, you need to comment all of the existing and current Tables:

public override void Up()
{
// CreateTable(
// "dbo.<EXISTING TABLE NAME IN DATABASE>
// ...
// }
...
}

If you miss this bit all will fail and you have to start again!

5. Now Run Update-Database -verbose

This should be successful if you have done the above correctly, and now you can carry on as normal.

Solution 5

In Entity Framework Core.

1. Remove all files from the migrations folder.

2. Type in console

   dotnet ef database drop -f -v
   dotnet ef migrations add Initial
   dotnet ef database update
   

3. (Or for Package Manager Console)

   Drop-Database -Force -Verbose
   Add-Migration Initial
   Update-Database
   

UPD: Do that only if you don't care about your current persisted data. If you do, use Greg Gum's answer

View more solutions