Sybase 15.0.2 manual Installing sample databases, Default devices for sample databases

Installing sample databases

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:

	•	“Running the database scripts” on page 45
	•	“Installing the interpubs database” on page 46
	•	“Installing the jpubs database” on page 47
	The sample databases contain information about a fictitious business. You can
	use this information to learn about the Sybase products, without affecting
	essential data.
	Table 3-1 lists the scripts that you can use to install the sample databases.
		Table 3-1: 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.

Default devices for sample databases

The %SYBASE%\%SYBASE_ASE%\scripts directory contains scripts for installing the us_english sample database, foreign language sample databases, and the image data associated with the U.S. English pubs2 sample database.

44 Adaptive Server Enterprise