update an sql server database using entity framework code first migration
I have an application that uses a local database. And I have something like 300 databases to update. All of them in remote places.
I then created an application that has two projects. a model with the database tables and another to the context ..
then follow the sequence:
1. the development machine ran the application. that's perfect. created the database.
2. altered a model class.
3. ran the "enable-migrations"
3. ran the "add-migration class1"
4. I ran the "update-database"
copied the compiled application and took her to a remote machine. I ran the application and it worked perfectly.
I returned the development machine and changed a new class. performed the following:
1. "add-migration class2"
I copied the compiled application and took to the remote machine (the same) and ran the program and get an exception saying that the context has changed since the database was created and that I must consider the code first migration.
I will use the program exactly not to need the presence on site.