CodeFirst DB Migrations with Azure

DiscontentDisciple

I've so far been unsuccessful at getting automatic migrations to work from a Visual Studio Online Code Repo that's configured to automatically deploy to Azure.

There's a Similar Question here that's unanswered: EntityFramework Automatic Migrations with Azure Git Deployment

My issue right now, is that the databases get out of Sync between the local working copy and the Azure DB, so when the code deploys successfully, the application no longer functions, since the database is not updated to match the new classes.

I've tried Several approaches:

  1. Webapi.config updated to include a Migrator.

    var migrator = new DbMigrator(new Configuration());
    migrator.Update();
    
  2. Web.Config Updated to Include Migrate To Latest Version

    <add key="MigrateDatabaseToLatestVersion" value="true"/>
    
  3. Migrations Configuration Updated to Enable Automatic

    AutomaticMigrationsEnabled = true;
    
  4. Publishing Directly from Visual Studio Via the Publish Manager - This still doesn't execute the DB Updates on the Azure site. (Including Checking the Option Box to Execute Migrations)

Anyone been able to get this to work?

Edit: I've also tried this, unsuccessfully, as a post deploy work-around, but no luck either. http://robertgreiner.com/2012/05/using-entity-framework-database-migrations-to-update-a-remote-database/

DiscontentDisciple

I've Discovered what I believe to be the root cause (Code Wise, Actual Root Cause is I'm an idiot). I have configured in the web.config the LocalDB Client, to the migrations were all happening against that DB. Commenting out that DB and allowing the Update-Database Command in the package manager to run against the AzureDB updated the database on Azure correctly.

I'm still not totally sure why the migrations aren't working, but I'm suspecting it's due to the Web.Config File I'm deploying with the default DB set to something Azure doesn't know about (LocalDB).

So this is a work-around at least, while I fix my Web.Config Settings to deploy with the correct DB to Azure.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

TOP Ranking

  1. 1

    Failed to listen on localhost:8000 (reason: Cannot assign requested address)

  2. 2

    How to import an asset in swift using Bundle.main.path() in a react-native native module

  3. 3

    Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

  4. 4

    pump.io port in URL

  5. 5

    Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

  6. 6

    BigQuery - concatenate ignoring NULL

  7. 7

    ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

  8. 8

    Do Idle Snowflake Connections Use Cloud Services Credits?

  9. 9

    maven-jaxb2-plugin cannot generate classes due to two declarations cause a collision in ObjectFactory class

  10. 10

    Compiler error CS0246 (type or namespace not found) on using Ninject in ASP.NET vNext

  11. 11

    Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

  12. 12

    Generate random UUIDv4 with Elm

  13. 13

    Jquery different data trapped from direct mousedown event and simulation via $(this).trigger('mousedown');

  14. 14

    Is it possible to Redo commits removed by GitHub Desktop's Undo on a Mac?

  15. 15

    flutter: dropdown item programmatically unselect problem

  16. 16

    Change dd-mm-yyyy date format of dataframe date column to yyyy-mm-dd

  17. 17

    EXCEL: Find sum of values in one column with criteria from other column

  18. 18

    Pandas - check if dataframe has negative value in any column

  19. 19

    How to use merge windows unallocated space into Ubuntu using GParted?

  20. 20

    Make a B+ Tree concurrent thread safe

  21. 21

    ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements

HotTag

Archive