What is the reverse for Update-Database (used in Package Manager Console)?

Question

I have been changing my domain classes and executed Update-Database in the Package Manager Console, After i realized that need to add an index and need to down-grade to the previous state. what is the proper command to down-grade one step in migration?

Answer 1

Update-Database has a TargetMigration parameter that you can use to update to a particular migration. You can use that to upgrade or downgrade.

Update-Database –TargetMigration PreviousMigrationName

Answer 2

For Entity Framework Core ONLY and if you are using it from Package Manager

Update-Database –Migration yourMigrationName

Answer 3

Update-Database –TargetMigration "lastcreatedMigrationName"

example:

update-database -targetmigration: "entity-logs-index"

Answer 4

If you want to rollback all migrations you can use (Stolen from this answer):

Update-Database -TargetMigration:0

But in EF Core it is

Update-Database -Migration:0

Answer 5

To continue this, if you have outstanding model changes i do believe this will fail. This can be frustrating when you already have code in place.

Update-Database –TargetMigration "targetmigrationname" -force

If you use this command and include the force flag the database will migrate to that version regardless of having outstanding model changes.