Entity Framework generate update script for dev/production

Question

I have been made a few changes to my database locally and have been adding migrations and updating the database via the Package Manager Console.

Now I've checked in and deployed out to the dev server however I am getting the error:

The model backing the 'MyProjectContext' context has changed since the database was created. Consider using Code First Migrations to update the database (http://go.microsoft.com/fwlink/?LinkId=238269).

I know this is telling me that my version of the database is out of date however I don't want to drop the database this time so im trying to generate a script to manually run on the database however I don't fully understand how I can tell it which is the last migration that the dev db is aware of and which is the current, up to date one, ive tried the below however its not working:

So If "Added IsImportant to exceptions" was the last migration updated on the dev server, and "Set ImportantId as Identity Specification" was the last update I manually run locally, how do I generate the right script for dev?

JsonStatham · Accepted Answer · 2015-07-30 11:51:28Z

3

Turns out I was doing it right but needed the full configuration name with double quotes.

Update-Database -Script -SourceMigration:"201507091527309_Added IsImportant to exception" -TargetMigration:"201507281410132_Set ImportantId as Identity Specification"

Once I ran this it generated the script and I was able to upgrade the database.

answered Jul 30, 2015 at 11:51

JsonStatham

10.5k29 gold badges113 silver badges190 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework generate update script for dev/production

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related