alapalaya
07-12-2002, 08:35 AM
Hi everybody,
All the products in my company make a large use of DBs (often SQL Server, but sometimes also Oracle DB).
Very often a minor release of a product involves making some changes in the DB schema/contents.
Using Installshield Developer 7 we found very usefule the "create patch" wizard.
We would like to use IS Developer 7 in all our future release, to create a complete installation experience, including also the DB setup / upgrade.
Basically for a new installation, we think to use some InstallScript code to control OCXs to setup the DB. This should be not difficult (btw: all suggestions and code snippets about using OCX in custom actions to setup DBs are welcome ;) ).
Problems arises when releasing a patch to a customer which involves applying some logics to the DB.
I don't know if it is possible to execute some kind of InstallScript during a patch process... thus having all the "db upgrade" logic inside a script.
I can't see any way of updating the DB side of an installation, if not by hand... which is not what I would like.
Have you got suggestions about this issue?
All replys are welcome.
Cheers.
All the products in my company make a large use of DBs (often SQL Server, but sometimes also Oracle DB).
Very often a minor release of a product involves making some changes in the DB schema/contents.
Using Installshield Developer 7 we found very usefule the "create patch" wizard.
We would like to use IS Developer 7 in all our future release, to create a complete installation experience, including also the DB setup / upgrade.
Basically for a new installation, we think to use some InstallScript code to control OCXs to setup the DB. This should be not difficult (btw: all suggestions and code snippets about using OCX in custom actions to setup DBs are welcome ;) ).
Problems arises when releasing a patch to a customer which involves applying some logics to the DB.
I don't know if it is possible to execute some kind of InstallScript during a patch process... thus having all the "db upgrade" logic inside a script.
I can't see any way of updating the DB side of an installation, if not by hand... which is not what I would like.
Have you got suggestions about this issue?
All replys are welcome.
Cheers.