Installing Sample Databases

This section describes how to install the U.S. English and international language sample databases.

For installation instructions specific to each sample database, see the following sections:
Sample Database Scripts

Script

Description

instpbs2

Installs the pubs2 sample database.

This database contains data that represents a publishing operation. Use this database to test your server connections and to learn Transact-SQL. Most of the examples in the Adaptive Server documentation query the pubs2 database.

instpbs3

Installs the pubs3 sample database.

This updated version of pubs2 uses referential integrity. In addition, its tables are slightly different than the tables used in pubs2. Where noted, the Adaptive Server documentation uses the pubs3 database in its examples.

instpix2

Installs the image data that is used with the pubs2 database.

Note:

The master device size should be at least 30MB to install the full pubs2 database, including the image data. Be sure to run the instpix2 script after you run instpbs2.