Is it possible to move the __MigrationHistory System table to a new server?

Viewed 2166

We recently moved our database to a new server. However, at the time, we did not allow the Code First migrations to create the database. We used another tool to migrate the tables and data. The __MigrationHistory table was not moved during this time. The __MigrationHistory is a system table in our original DB.

I cannot seem to find a way to import or export the __MigrationHistory table so we can allow future migrations to take place.

The only other thought we had, is to have the application recreate the database and migrate the copied data to the new version of the DB. The only issue is we have millions of records to move and it is quite a long process.

1 Answers
Related