Running the Database Scripts

After you determine your default device, run the scripts to install the sample databases.

Prerequisites

Back up the original instpbs2 and instpbs3 scripts, in case you have problems with the edited scripts.

Task
  1. Start SAP ASE.
  2. Go to the scripts directory at %SYBASE%\%SYBASE_ASE%\scripts.
  3. Use isql to log in to the SAP ASE server and run the script:
    isql -Usa -P*****-Sserver_name -iscript_name
    Where:
    • server_name – is the destination server for the database.
    • script_name – is the full path to and file name of the script to run.
    For example, to install pubs2 on a server named VIOLIN, enter:
    isql -Usa -P***** -SVIOLIN -i %SYBASE%\%SYBASE_ASE%\scripts\instpbs2
  4. Install the image data associated with pubs2:
    %SYBASE%\%SYBASE_ASE%\ isql -Usa -Ppassword -Sservername
    -i%SYBASE%\%SYBASE_ASE%\scripts\instpix2

    The pubs3 database does not use image data.

    For more information about running these scripts, see the Configuration Guide for Windows.