MigrateDatabaseToLatestVersion and dbo.__MigrationHistory

Question

I am trying to deploy an MVC4 application that is built using EF5 codefist and migrations. I want the app to update the database when I in the future deploy new versions of the app with new migrations, so in Global.asax I do this: ``` Database.SetInitializer(new MigrateDatabaseToLatestVersion<GoDealMvc4Context, Configuration>()); using (var ctx = new GoDealMvc4Context()) { ctx.Database.Initialize(false); } ``` The initial database on the server is deployed by attaching an MDF file copied from my dev machine. This database contains the __MigrationsHistory system table. So this database should not need to execute any migrations, because it is up to date with latest migration. When I try to start the app on the server, it I get this error: ``` There is already an object named 'UserProfile' in the database. [SqlException (0x80131904): There is already an object named 'UserProfile' in the database.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection…

Accepted Answer

There is also another NASTY gotcha here for anyone looking for answers. Check the content of the

```
[dbo].[__MigrationHistory]   table    column ContextKey
```

This table Tells how the DB was created (migration mode, Create mode etc...) was created. AND with what Migration Configuration Program. I got hurt with a change of MigrationsConfiguration Class name.

Changing the entry in table worked :-) Or renaming your code back.

MigrateDatabaseToLatestVersion and dbo.__MigrationHistory

Solution

Problem