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
-
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
I have used this method successfully before ... Create a set of "Upgrade" scripts for your database. You could have a UpgradeSchema script where you would alter tables, indexes, etc and have a "UpgradeSystemData" script where you could populate your systems tables like a table of States, or a Tax table. Best advice is to TEST, TEST, TEST these scripts an important test is to run the script once, then run it again on the newly upgraded database ... you will need to trap for the case where you want to add a column to a table and the table already exists. Also, trap for duplicate keys when inserting data. Good luck.
-
With over 900 posts you should know better than to cross post :mad:
Bob Ashfield Consultants Ltd
Which post are you referring?
Don't work hard, but work effectively. Web hosting | Buy stock | Option strategy | home mortgage
-
Which post are you referring?
Don't work hard, but work effectively. Web hosting | Buy stock | Option strategy | home mortgage
-
Yours of course. You posted this same question here and the C# forum- maybe a mistake?
Bob Ashfield Consultants Ltd
Oh, that's right. I though the problem is related to C# and database. Don't know where to post.
Don't work hard, but work effectively. Web hosting | Buy stock | Option strategy | home mortgage