Running the Database Scripts

Learn how to run the database scripts.

Note: The image data requires 10MB—there are six pictures, two each in the PICT, TIFF, and Sun raster file formats. Run installpix2 script only to use or test the image datatype. Sybase does not supply any tools for displaying image data. You must use appropriate window graphics tools to display the images after you have extracted them from the database.

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

Start Adaptive Server.
Make a copy of the original installpubs2 and installpubs3 scripts. Be sure you can access the copies, in case you have problems with the edited scripts.
Use a text editor to edit the script, if necessary, to specify a default device other than the master device, or use sp_diskdefault.
Go to the Adaptive Server scripts directory, at $SYBASE/$SYBASE_ASE/scripts, to run the scripts.
Use isql to log in to Adaptive Server and run the script:
```
isql -Usa -P*****-Sserver_name -iscript_name
```
where:
- server_name – represents 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/installpubs2
```

Install the image data associated with pubs2:

isql -Usa -Ppassword -Sservername
  -i$SYBASE/$SYBASE_ASE/scripts/installpix2

The pubs3 database does not use image data.