How do I use Entity Framework 5 Code First Migrations to create a full database script from the initial (empty) state to the latest migration?
The blog post at MSDN Blog suggests to do this, but it seems to create an empty script:
Update-Database -Script -SourceMigration: $InitialDatabase
The API appears to have changed (or at least, it doesn't work for me).
Running the following in the Package Manager Console works as expected:
Update-Database -Script -SourceMigration:0
For anyone using entity framework core ending up here. This is how you do it.
# Powershell / Package manager console Script-Migration # Cli dotnet ef migrations script
You can use the
-To parameter to generate an update script to update a database to a specific version.
Script-Migration -From 20190101011200_Initial-Migration -To 20190101021200_Migration-2
There are several options to this command.
The from migration should be the last migration applied to the database before running the script. If no migrations have been applied, specify
0(this is the default).
The to migration is the last migration that will be applied to the database after running the script. This defaults to the last migration in your project.
An idempotent script can optionally be generated. This script only applies migrations if they haven't already been applied to the database. This is useful if you don't exactly know what the last migration applied to the database was or if you are deploying to multiple databases that may each be at a different migration.