The sample databases contain fictitious information and are intended to help you learn how to use Adaptive Server.
Note: The sample databases are intended for training purposes only. Do not install them in an Adaptive Server production environment.
installpubs2 – 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.
installpubs3 – 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.
installpix2 – 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.
Run the installpix2 script
after you run installpubs2.
Default Devices for Sample Databases
The Adaptive Server installation includes scripts for installing the us_english sample database, foreign language sample databases, and the image data associated with the US English pubs2 sample database.
Maintaining Sample Databases
The sample databases contain a guest user option that allows authorized users to access the database. Guest users have a wide range of privileges, including permissions to select, insert, update, and delete user tables.