Sybase IQ includes scripts to create a demo database. In the %ALLUSERSPROFILE%\SybaseIQ\demo directory, you will see the script mkiqdemo.bat. This script creates the demo database by modifying, then running the script mkiqdemo.sql, which will load in data from the sub-directory \adata.
The sample data supports an imaginary sporting goods company. The sample database has been updated for the 15.1 release. If you are upgrading from a previous edition, see “Table names” for demo database table names.
This table includes the former names and new names of sample 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 |
The previous demo database, Megaphone Telco, is not
included with Sybase IQ 15.1
Use these instructions to start the demo database installed with the product.
Click Start, point to Programs | Sybase | Sybase IQ 15.1 | Start Sybase IQ Demo Database. This step also creates iqdemo if it does not exist.
For customers who are use to the older asiqdemo database,
you can still create that database by passing in the flag -old to
the mkiqdemo.bat script.
Starting the demo database