CODEWITHSUNDEEP
entity-frameworkentity-framework-4.3entity-framework-migrations
drzaus
drzaus

Reputation: 24994

Entity Framework - Start Over - Undo/Rollback All Migrations

For some reason, my migrations appear to have been jumbled/corrupted/whatever. I'm at the point where I just want to start over, so is there a way to completely undo all migrations, erase the history, and delete the migration code, so I'm back to square one?

e.g.) PM> Disable-Migrations or Rollback-Migrations

I don't want to "update" to an original migration step (i.e. something like an InitialSchema target) because I can't find it anymore.

Upvotes: 174

Views: 95491

Answers (6)

Jonne Kleijer
Jonne Kleijer

Reputation: 691

Using the .NET core cli:

dotnet ef database update 0
dotnet ef migrations remove

Upvotes: 3

Sayed M. Idrees
Sayed M. Idrees

Reputation: 1408

It is written wrong in their documentation i guess , for me i used

Update-Database -Target MigrationName

Upvotes: 0

Sergey
Sergey

Reputation: 1050

Update-Database -Migration 0
Remove-Migration

The documentation is here: https://learn.microsoft.com/en-us/ef/core/miscellaneous/cli/powershell#update-database and here: https://learn.microsoft.com/en-us/ef/core/miscellaneous/cli/powershell#remove-migration

Upvotes: 6

Andrei Karcheuski
Andrei Karcheuski

Reputation: 3306

For Entity Framework Core:

Update-Database -Migration:0
Remove-Migration

Upvotes: 30

Brian Ogden
Brian Ogden

Reputation: 19212

To be clear, if using LocalDb, when you want to start from scratch just delete the database via the Database Explorer and then type enable-migrations -force in the Package Manager Console. Do not delete the database via the App_Data folder or you will have the following issue.

Upvotes: 8

Ladislav Mrnka
Ladislav Mrnka

Reputation: 364249

You can rollback to any migration by using:

Update-Database -TargetMigration:"MigrationName"

If you want to rollback all migrations you can use:

Update-Database -TargetMigration:0

or equivalent:

Update-Database -TargetMigration:$InitialDatabase

In some cases you can also delete database and all migration classes.

Upvotes: 367

Related Questions