How to update MS Access database in the installed application?
-
Hi, I have a setup program that installs my application with an MS Access database. Now, when I have to provide an update to a client, I again build a setup program and give them this setup. The client unistalls his existing program and installs new setup. This process also wipes out his existing database. To overcome this, I set permanent property of database in the setup TRUE. This has resolved the above problem. But now... I have updated few tables in my database. The clients must be provided with the update such that his existing data must be retained intact... HOW to achieve this? Any suggesstion will be greatly helpful?
Regards, -SIFAR.
-
Hi, I have a setup program that installs my application with an MS Access database. Now, when I have to provide an update to a client, I again build a setup program and give them this setup. The client unistalls his existing program and installs new setup. This process also wipes out his existing database. To overcome this, I set permanent property of database in the setup TRUE. This has resolved the above problem. But now... I have updated few tables in my database. The clients must be provided with the update such that his existing data must be retained intact... HOW to achieve this? Any suggesstion will be greatly helpful?
Regards, -SIFAR.
My standard practice is to write migration scripts for new versions of the database. Then you can use the migration scripts to update the old database. This can be a lot of code to maintain so what you do is an iterative update process. IE, convert DB V1 to DB V2 then convert the newly created DB V2 to DB V3, etc. This is much easier than writing infinite migration scripts. Be cautious because you will come across database that just cannot be upgraded with 100% accuracy if you do not have a solid change control policy in place.
Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. A man said to the universe: "Sir I exist!" "However," replied the universe, "The fact has not created in me A sense of obligation." --Stephen Crane