upgrading databse issue
-
If you have created an application which uses database, and installed it for your client. Next you have updated the application and updating the database structure. So the client's database and the newest database has different structure. What is the ideal way to update the database structure, and still using client's previous entered data. I use C#.
Don't work hard, but work effectively. Web hosting | Buy stock | Option strategy | home mortgage
-
If you have created an application which uses database, and installed it for your client. Next you have updated the application and updating the database structure. So the client's database and the newest database has different structure. What is the ideal way to update the database structure, and still using client's previous entered data. I use C#.
Don't work hard, but work effectively. Web hosting | Buy stock | Option strategy | home mortgage
This has been discussed a lot; it's a common scenario. Here's a thread on the MSDN forums that discuss dealing with SQL schema changes from the C# side of things.
Tech, life, family, faith: Give me a visit. I'm currently blogging about: Feelings-Based Morality of the Secular World The apostle Paul, modernly speaking: Epistles of Paul Judah Himango
-
This has been discussed a lot; it's a common scenario. Here's a thread on the MSDN forums that discuss dealing with SQL schema changes from the C# side of things.
Tech, life, family, faith: Give me a visit. I'm currently blogging about: Feelings-Based Morality of the Secular World The apostle Paul, modernly speaking: Epistles of Paul Judah Himango
I'm currently creating an application that reads the structures of old and new database, creates insert query and executes it to the new database from C# application. This means I have to executes lots of rows. I'm looking for a better way if any.
Don't work hard, but work effectively. Web hosting | Buy stock | Option strategy | home mortgage