I'm trying to come up with a good way to distribute database changes when distributing an update for my Foxpro application. I searched the forums and came across a couple of things but nothing that was solid. What is the best way to modify the tables/index/relations in a database with an install set? We are using Installshield to create installsets.Sorry for the late entry here, but thought I'd mention that I am using InstallShield as the "application update wrapper" which takes care of copying down the new executables and reports. I then have InstallShield launch a data update utility I wrote in VFP which makes use of Stonefield for updating the table structures. After the data update is done, I validate the database and then have IS launch any other post-upgrade utilities that need to be run.
Distributing the patch as a single self-extracting InstallShield executable makes for a very easy and painless upgrade for the clients.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer