CODEWITHSUNDEEP
c#.netvisual-studioentity-frameworkentity-framework-core
HelloWorld
HelloWorld

Reputation: 3739

How to add EF Core Migrations to existing db when you have no __EFMigrationsHistory table?

I have an existing database in production which have not previously been involved with EF Migrations. As such, it is missing the __EFMigrationsHistory table.

I'm doing the following:

I'm assuming this occurs because there is no migration history, and it tries to create everything from scratch.

How can I add migrations to a database which have not previously used it?

Upvotes: 1

Views: 1570

Answers (1)

salman_sali
salman_sali

Reputation: 391

  1. If you are sure that your EF model matches the existing database's model then you can create the Migration History table manually and add row entries for the migrations which match the existing database models.
  2. If you have a large database it will be hard for you to confirm that the database model matches your new EF model. You will have to create a new database, run your migration on the new database and export data table by table from old to new.

Upvotes: 1

Related Questions