Running the Database Scripts

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

Prerequisites

Determine the type (raw partition, logical volume, operating system file, and so on) and location of the device where you plan to store the pubs2 and pubs3 databases.

Back up the original installpubs2 and installpubs3 scripts, in case you have problems with the edited scripts.

Task

Start the server instance.
Go to the Adaptive Server scripts directory at $SYBASE/$SYBASE_ASE/scripts.
Use isql to log in to the instance 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/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.

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