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

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?

Answer 1

User-1007037156 posted

Hi Weera,

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

Answer 2

User1492915735 posted

Hi markberr,

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

 

 

Answer 3

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