When I run PM> Remove-Migration -context BloggingContext
in VS2015 with an ASP.NET Core project using EF Core I get the following error:
System.InvalidOperationException: The migration '20160703192724_MyFirstMigration' has already been applied to the database. Unapply it and try again. If the migration has been applied to other databases, consider reverting its changes using a new migration. at Microsoft.EntityFrameworkCore.Migrations.Design.MigrationsScaffolder.RemoveMigration(String projectDir, String rootNamespace, Boolean force)
at Microsoft.EntityFrameworkCore.Design.MigrationsOperations.RemoveMigration(String contextType, Boolean force)
at Microsoft.EntityFrameworkCore.Tools.Cli.MigrationsRemoveCommand.<>c__DisplayClass0_0.<Configure>b__0()
at Microsoft.Extensions.CommandLineUtils.CommandLineApplication.Execute(String[] args)
at Microsoft.EntityFrameworkCore.Tools.Cli.Program.Main(String[] args)
The migration '20160703192724_MyFirstMigration' has already been applied to the database. Unapply it and try again. If the migration has been applied to other databases, consider reverting its changes using a new migration.
How can I unapply it? I'm using latest release of ASP.NET Core 1.0, EF Core, and VS2015 Update 3.
This question is related to
c#
asp.net-core
entity-framework-core
.net-core
visual-studio-2015
You can do it with:
dotnet ef migrations remove
Take care not to remove any migrations which are already applied to production databases. Not doing so will prevent you from being able to revert it, and may break the assumptions made by subsequent migrations.
Use:
CLI
> dotnet ef database update <previous-migration-name>
Package Manager Console
PM> Update-Database <previous-migration-name>
Example:
PM> Update-Database MyInitialMigration
Then try to remove last migration.
Removing migration without database update doesn't work because you applied changes to database.
If using PMC, Try: PM> update-database 0 This will wipe the database and allow you to remove the Migration Snapshot on your Solution
To unapply a specific migration(s):
dotnet ef database update LastGoodMigrationName
or
PM> Update-Database -Migration LastGoodMigrationName
To unapply all migrations:
dotnet ef database update 0
or
PM> Update-Database -Migration 0
To remove last migration:
dotnet ef migrations remove
or
PM> Remove-Migration
To remove all migrations:
just remove Migrations
folder.
To remove last few migrations (not all):
There is no a command to remove a bunch of migrations and we can't just remove these few migrations
and their *.designer.cs
files since we need to keep the snapshot file in the consistent state. We need to remove migrations one by one (see To remove last migration
above).
To unapply and remove last migration:
dotnet ef migrations remove --force
or
PM> Remove-Migration -Force
In order to unapply a migration in EF Core 1.0 use the command:
dotnet ef database update {migration_name}
Use the migration name of the migration until which you would like to preserve your changes. The list of names of the migration can be found using:
dotnet ef migrations list
You can still use the Update-Database
command.
Update-Database -Migration <migration name> -Context <context name>
However, judging by the name of your migration i'm assuming it's the first migration so that command may not work. You should be able to delete the entry from the __MigrationHistory
table in your database and then run the Remove-Migration
command again. You could also delete the migration file and just start again.
In general if you are using the Package Manager Console the right way to remove a specific Migration is by referencing the name of the migration
Update-Database -Migration {Name of Migration} -Context {context}
Another way to remove the last migration you have applied according to the docs is by using the command:
dotnet ef migrations remove
This command should be executed from the developer command prompt (how to open command prompt) inside your solution directory.
For example if your application is inside name "Application" and is in the folder c:\Projects. Then your path should be:
C:\Projects\Application
You should delete migration '20160703192724_MyFirstMigration' record from '_EFMigrationsHistory' table.
otherwise this command will remove migration and delete migrations folder:
PMC Command:
> remove-migration -force
CLI Command:
> dotnet ef migrations remove -f
Simply you can target a Migration by value
Update-Database -Migration:0
Then go ahead and remove it
Remove-Migration
Note: It might be troublesome later on, I used it as a last resort since non of the solutions provided above and others did not work in my case:
Add-Migration "migration-name"
Up(){ //paste here }
Update-Database
To completely remove all migrations and start all over again, do the following:
dotnet ef database update 0
dotnet ef migrations remove
To revert the last applied migration you should (package manager console commands):
PM> Update-Database <prior-migration-name>
PM> Remove-Migration
UPD: The second step seems to be not required in latest versions of Visual Studio (2017).
To "unapply" the most (recent?) migration after it has already been applied to the database:
Hope this helps and is applicable to any migration in the project... I tested this out only to the most recent migration...
Happy coding!
at first run the following command :
PM>update-database -migration:0
and then run this one :
PM>remove_migration
Finish
In Package Manager Console:
Update-Database Your_Migration_You_Want_To_Revert_To
More options and explanation on how to revert migrations can be seen here
1.find table "dbo._EFMigrationsHistory", then delete the migration record that you want to remove. 2. run "remove-migration" in PM(Package Manager Console). Works for me.
To revert all the migrations which are applied to DB simply run:
update-database 0
It should be followed with running Remove-Migration
as many times as there are migration files visible in the Migration directory. The command deletes the latest migration and also updates the snapshot.
in Package Manager Console, just Type Remove-Migration And Press Enter. It automatically removes the migration.
Tools -> Nuget Package Manager -> Package Manager Console
I don't understand why we are confusing things up here. So I'll write down a clear explanation, and what you have to notice.
All the commands will be written using dotnet
.
This solution is provided for .net Core 3.1, but should be compatible with all other generations as well
cd to_your_project
then dotnet ef migrations remove
Note: Removing a migration works only, if you didn't execute yet dotnet ef database update
or called in your c# code Database.Migrate()
, in other words, only if the migration is not applied to your database yet.
dotnet ef migrations add <your_changes>
and apply it, which is recommended by microsoft.dotnet ef database update <your_migration_name_to_jump_back_to>
Note: if the migration you want to unapply, does not contain a specific column or table, which are already in your database applied and being used, the column or table will be dropped, and your data will be lost.
After reverting the migration, you can remove your unwanted migration
Hopefully this helps someone!
Source: Stackoverflow.com