Manage Databases

The Manage Databases page allows you to perform operations on the engine and archive database.

Database Creation

The options under Database Creation allow you to perform operations on the engine database.

Option	Description
Drop the database	Generates SQL commands to drop an existing engine database. You should select this option only if you want to remove an existing engine database before creating a new one.
Create the database	Generates SQL commands to create a new engine database.
Create the data structure	Generates SQL commands to create the required schema for the engine database.
Database Administrator User	Specifies the username of the administrator user.
Database Administrator Password	Specifies the password of the administrator user.

The options under Archive Database Creation allow you to perform operations on the engine database.

Note: This section is only visible if you have enabled archiving. SeeEnabling Archiving.

Option	Description
Drop the database	Generates SQL commands to drop an existing engine database. You should select this option only if you want to remove an existing engine database before creating a new one.
Create the database	Generates SQL commands to create a new engine database.
Create the data structure	Generates SQL commands to create the required schema for the engine database.
Database Administrator User	Specifies the username of the administrator user.
Database Administrator Password	Specifies the password of the administrator user.

Action	Description
OK	Performs the database operation based on the options you have selected.
Cancel	Cancels the selected operations and returns to the Edit Engine page.
Show SQL Statements	Generates a .sql file based on the options you enter. If you do not have DBA privileges, you can give this file to your DBA to create the engine or archive database.