Sybase Adaptive Server 15.0.2, Руководство по установке

Страница: 58 / 160

Installing sample databases
44
Adaptive Server Enterprise
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
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.
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.