Revert database in Entity Framework code-first

Question

I made a in my model and updated database using

Add-Migration sdfgfsd
Update-Database

Now I found the change I just made is not necessary.

I would like do revert both code and database.

How can I do this?

Peter Smith · Accepted Answer · 2015-05-28 12:35:08Z

8

Yes - it's straightforward. Use

Update-Database -TargetMigration:zzzz

Where zzzz is the name of the migration before the one you want to rollback.

EDIT You then need to delete the migration(s) after zzzz.

If you want to rollback all migrations, or if you only have one migration, use

update-database -target:0

edited May 28, 2015 at 12:35

answered May 28, 2015 at 12:22

Peter Smith

5,5529 gold badges54 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Kuttan Sujith Over a year ago

why should delete zzzz?

Peter Smith Over a year ago

Sorry, my bad, you delete the one you don't want.

julealgon Over a year ago

@KuttanSujith The 'zzzz' migration in Peter's example is the migration you want to rollback. So you go back to a point prior to it, and then delete it from your code.

Collectives™ on Stack Overflow

Revert database in Entity Framework code-first

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related