To create a database, you need the 'Create database' permission
To create a database, you need the 'Create database' permission
Warning: Databases cannot be copied. Do not attempt to create or copy a database from within SQL Server or Oracle as invalid references are likely to be created, leading to data corruption. All new databases must be created and registered in the usual way via the System Management module.
To create a new database, follow the steps below.
Select Database > Create
Database or right click on the 
icon
in the tree view. The Create New Database window is displayed.
Choose either SQL Server/MSDE Database or Oracle Database by clicking the option button next to the type of database that you wish to create.
Click OK to create a new database or Cancel to close the window without creating a database.
Enter the connection values. There is a limit of 15 characters for the DB Alias.
When all the fields have been completed, click Test to test the connection.
If the connection tests successfully, click Create to create the database.
Note: You must register a new database before it can be used.
This enables you to save the database creation script as a text (.txt) file. You may then open and edit the script to your own requirements at a later date.
After completing steps 1 - 4 above:
Check the Write DB creation script to file box and click OK.
Enter a name for the file ending with .txt and click OK.
Enter a site name or click OK to skip this step. The .txt file will be created in the application folder.
Creating and administering sites