Entity-framework – Generate full SQL script from EF 5 Code First Migrations

entity-frameworkentity-framework-migrations

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

I realise this is an old question, but what the hell....

To enable migrations to create the initial database I've found the following works well.

Delete your database from within SQL Server Object Explorer
Delete all your existing migrations from within the Migrations folder.
In Package-Management-Console type "Add-Migration InitialCreate"

[optional, depending on your database initializer]
In Package-Management-Console type "update-database"

This will give you a single migration script which will take you from "no database" to having a database that matches your current model.

You need to :

Delete the state: Delete the migrations folder in your project; And
Delete the __MigrationHistory table in your database (may be under system tables); Then
Run the following command in the Package Manager Console:
```
Enable-Migrations -EnableAutomaticMigrations -Force
```
Use with or without -EnableAutomaticMigrations
And finally, you can run:
```
Add-Migration Initial
```