We have created an installer for an application that uses a database.
The installer creates some tables on installation and removes them on deinstallation...
(simple sql-scripts executed on install/uninstall)
Now we want to create an upgrade for some installations of our application. Unfortunately the
database is being removed and then created new when an upgrade is being installed.
Thats bad, because all the stored data is gone then...
Is there a way to keep the old database on an upgrade?
If that is not possible, how should we design our installer that it would be possible in the future?