Demo database

Sybase IQ 15.1 includes a demo database. In the $IQDIR15/demo directory, you will see the script mkiqdemo.sh. This script creates the demo database by modifying, then running the script mkiqdemo.sql, which loads sample data from the adata subdirectory.

The sample data supports an imaginary sporting goods company. The demo database has been updated for the 15.x release. If you are upgrading from a previous edition, see “Table names” for demo database table names. The table includes the former names and new names of sample tables so that you can update scripts or applications.

Creating the demo database

The file $IQDIR15/demo/mkiqdemo.sql contains SQL statements that create the database and $IQDIR15/demo/adata contains its data.

In the directory $IQDIR15/demo, run mkiqdemo.sh.

For customers who prefer the older asiqdemo database, you can still create that database by passing in the flag -old to the mkiqdemo.sh script. Use mkiqdemo.sh -help to display additional options.

Table names

If you are upgrading from a previous edition, see the following table for a list of current table names in the demo database. Use this table to update scripts or applications.

**Table 4-1: demo database table names**
12.7 name	15.1 name	15.1 owner
contact	Contacts	GROUPO
customer	Customers	GROUPO
department	Departments	GROUPO
emp1	emp1	DBA
employee	Employees	GROUPO
fin_code	FinancialCodes	GROUPO
fin_data	FinancialData	GROUPO
iq_dummy	iq_dummy	DBA
product	Products	GROUPO
sale	sale	DBA
sales_order_items	SalesOrderItems	GROUPO
sales_order	SalesOrders	GROUPO
SYSOPTIONDEFAULTS		DBA

Megaphone Telco is not included with Sybase IQ 15.1.