0

at the moment we have a migration project that will utilize entity framework's migrate.exe and update the database models to match the current object models. The solution works great for data I have immediate access to, meaning locally or any that are on our servers. Not only do I update the models, sometimes I add data to populate the new columns as well. Now I'm coming across some clients that want to host their data locally.

The current strategy that we thought of is to grab a backup of their local database, restore it locally onto our machines and update then restore it back to their servers.

My question is what is the best strategy to use to update databases that are located locally and to populate them.

Master
  • 2,038
  • 2
  • 27
  • 77
  • 1
    Do a google search for "sql server update schema", – jdweng Apr 05 '17 at 13:49
  • Thanks for the suggestion, will read on that right now. – Master Apr 05 '17 at 13:50
  • Possible duplicate of [Using Entity Framework (code first) migrations in production](http://stackoverflow.com/questions/10848746/using-entity-framework-code-first-migrations-in-production) – Iuri Farenzena Apr 05 '17 at 13:59
  • @luri Farenzena, it's actually not. That's for production servers meaning you can connect to it via internet, major difference between my post and that post. – Master Apr 05 '17 at 14:05
  • It is not true that production servers are always internet accessible. It depends on what they are being used for. The solution in the possible duplicate should work for your situation as well. – GrandOpener Apr 05 '17 at 14:22
  • @GrandOpener At the moment that IS the solution I'm currently using. It's part of my migration project. That solution isn't applicable because the client's servers aren't accessible to me directly. – Master Apr 05 '17 at 14:43
  • With the information given thus far, the solution appear to be applicable. If you modify your software so that it does the migration on startup, then they will automatically get migrated the first time they run the new version of the software. If that is not possible, can you clarify why? – GrandOpener Apr 05 '17 at 21:49

0 Answers0