DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Automating install scripts.

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    21
    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.

  2. #2
    Join Date
    Nov 2000
    Location
    Potomac, Maryland
    Posts
    85
    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.

  3. #3
    Join Date
    Oct 2000
    Posts
    21
    Any more ideas?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width