Creating a New Database

The Administration Tool provides the functionality to create a new database on the database server. However, it is recommended that you create your own databases using the Enterprise Management tools that come with your server software. This has the advantage of enabling you to fully control the preparation, deployment, and configuration of the database.

To create a new database, perform the following:

  1. Right-click the database registration node and select New, Database .

    The Add a New Database dialog box is displayed.

  2. In the Name field, enter the name of the new database.

    Note: You cannot use any SQL reserved keyword such as Select, Where, Break, Continue, From and so on as a database name. For example, if you use "Select" keyword as the database name, the following error message is displayed and the tool may crash: “Select:- Incorrect syntax near keyword 'Select’" Refer to MSDN documentation for more information on SQL keywords.

  3. Click OK.

    This adds a new database on the database server.