To use the demo database to test your installation, create iqdemo.db and load the sample data. Scripts that create and load the demo database are located in the %ALLUSERSPROFILE%\SybaseIQ\demo directory.
To create or start the demo database, use the Start IQ Demo Database option from Sybase IQ 15.2 program group:
Click Start, point to Programs | Sybase | Sybase IQ 15.2 | Start Sybase IQ Demo Database.
The first time you use this option, Sybase IQ may prompt you for some additional information.
15.x demo database table names are different than those in the 12.x versions of the software. Table 4-1 includes current and former iqdemo table names. If you are upgrading from an earlier version of Sybase IQ, use this table to update the table names or permissions in your scripts or applications.
12.7 name |
15.x name |
15.x owner |
|---|---|---|
contact |
Contacts |
GROUPO |
customer |
Customers |
GROUPO |
department |
Departments |
GROUPO |
employee |
Employees |
GROUPO |
fin_code |
FinancialCodes |
GROUPO |
fin_data |
FinancialData |
GROUPO |
product |
Products |
GROUPO |
sales_order_items |
SalesOrderItems |
GROUPO |
sales_order |
SalesOrders |
GROUPO |
emp1 |
emp1 |
DBA |
iq_dummy |
iq_dummy |
DBA |
sale |
sale |
DBA |
SYSOPTIONDEFAULTS |
DBA |
To create the older asiqdemo version
of the demo database, open a command window, change to %ALLUSERSPROFILE%\SybaseIQ\demo,
and run this command: mkiqdemo.bat -old
