Procedure documentationCreating the Demo Database DEMODB Locate this document in the navigation structure

 

A demo database was developed for demonstration purposes. This demo database with the name DEMODB is the basis for the examples in the SAP MaxDB documentation.

If you want to use the demo database, you must first create it and fill it with demo data. Use Installation Manager to do this (see also: Using Installation Manager).

Note Note

The values of individual demo database parameters have been defined especially for testing purposes. Therefore, do not use this demo database in a production system.

End of the note.

Procedure

  1. Call Installation Manager.

  2. Choose the Start Installation/Upgrade option.

  3. On the Select Component Group to be Installed screen, choose Server + Client.

  4. On the Choose Installation Type screen, choose Install Software and Create Database.

  5. On the Select Database Configuration screen, choose Desktop PC/Laptop.

  6. On the Database Configuration screen, you can choose whether you want to load the demo data.

    • If you want to load the demo data, leave the Load Tutorial Data option selected.

      You need the demo data for working with the Database Manager CLI Tutorial and Loader Tutorial, for example.

    • If you do not want to load the demo data, remove the selection of Load Tutorial Data. In this way, you maintain the possibility to enter the demo data manually into the database using SQL statements, as described in the SQL Tutorial.

    • Enter DBADMIN as User name and SECRET as User password. Enter these values again in the Confirm password field.

    • Enter DEMODB as Database name.

  7. Confirm all default values of Installation Manager in succession to create the database.

Result

You have created the demo database with the following data:

  • Name of the database: DEMODB

  • Name of the database system administrator: DBADMIN/SECRET

  • Name/password of a database user: MONA/RED

  • Name of the demo schema: HOTEL

This enables you to reproduce step by step the examples shown in the SAP MaxDB documentation and to obtain similar results.

For further information on demo data, see Objects in the Schema HOTEL.

More Information

Concepts of the Database System, Demo Database

Database Administration, Creating Databases

SQL Tutorial

Database Manager CLI Tutorial

Loader Tutorial