Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Entity Framework - Start Over - Undo/Rollback All Migrations

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.


For Entity Framework Core:

Update-Database -Migration:0
Remove-Migration

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.


Update-Database -Migration 0
Remove-Migration

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