locked
2 Years from now, There's more than 20,000 who use my App. RRS feed

  • Question

  • User1492915735 posted

    Hi,

    SQL Azure.

    So that how to update all database shcema at rum time without abandon the data before make change?

    Is it possible to do that?

    Friday, October 5, 2012 2:10 AM

All replies

  • User-1007037156 posted

    Hi Weera,

    Any chance you're using EF for your data? If so, EF migrations might be solution to your problem.

    Tuesday, October 9, 2012 11:49 AM
  • User1492915735 posted

    Hi markberr,

    I will take a look at that again, However seems like it doesn't support.

     

     

    Wednesday, October 10, 2012 1:35 AM
  • User35838176 posted

    The easiest way would be to do an SQL dump of the data - update the schema and do a bulk import of the data.

    However, the proper way of doing this is rather coy - you should be writing the schema so that it can be readily updated, and think about the future when designing your database.

    Dave

    Wednesday, December 12, 2012 11:39 PM