Sybase IQ 15.0 ships a script and data that let you create your own demo database. The new database, iqdemo, supports an imaginary sporting goods company.
You can still create the demo database used in 12.6 or 12.7 by specifying the parameter -old when you invoke mkiqdemo.sh or mkiqdemo.bat. Table 2-4 lists the former names and new names of demo tables so that you can update scripts or applications.
12.7 name |
15.0 name |
15.0 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 |
In Sybase IQ 15.0, the demo database password has changed from ‘SQL’ to ‘sql’.
Creating the demo database on Windows
The file %ALLUSERSPROFILE%\SybaseIQ\demo\mkiqdemo.sql contains SQL statements that create the database and %ALLUSERSPROFILE%\SybaseIQ\demo\demodata contains its data.
In the directory %ALLUSERSPROFILE%\SybaseIQ\demo, run the batch file mkiqdemo.bat and respond to the prompts.
Creating the demo database on UNIX
The file $IQDIR15/demo/mkiqdemo.sql contains SQL statements that create the database and $IQDIR15/demo/demodata contains its data.
In the directory $IQDIR15/demo, run the script mkiqdemo.sh and respond to the prompts.
Sybase IQ 15.0 does not include Megaphone Telco Demo.