-
I have a system that uses sql scripts to install the software. This script does everything from creating database objects like tables, views, stored procedures etc. But the script needs to be run by the user after connecting to sqlplus. I would like to upgrade this so that the whole process is automated (kind of a windows installer look and feel) preferably with a GUI interface. If anybody has experience with such work and can name any products in the market that can be used to to do such work, please post it on this thread.
Thanks for your time.
-
If you have all the necessary scripts for the database creation, see if you can write a batch file and call the scripts from there.
example:
content of test.bat
@echo off
@echo This batch file will ......
sqlplus system/password@mydatabase.world
@z:\yourlocation\script1.sql
@z:\yourlocation\script2.sql
but for this to work, the machine should already have the oracle client software installed on it and a netservice already configured.
I'm not sure if this helps but I'm not aware of other commercial software for this task. Hopefully someone esle will have a better input.
-
