Adding a Database

Once you have added the database server registration you can start adding databases. There are two ways in which to add a database.

Creating a New Database

The Administration tool provides the functionality to create a basic database on the server. However, it is recommended that you create your own databases using the Enterprise Management tools that come with your database 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 required Registration node, point to New, and then select Database.

    The Add a New Database dialog box appears.

  2. In the Name box, 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 might crash: “Select:- Incorrect syntax near keyword 'Select’" Refer to MSDN documentation for more information on SQL keywords.

  3. Click OK.

Attaching an Existing Database

To add an existing database, you must attach the database to the new Windows Runtime environment using the Administration tool. An existing database can be:

To attach an existing database, perform the following:

  1. Right-click the Database Server node and select All Tasks, Attach Existing Database.

    The Attach a Database dialog box is displayed with a list of databases that can be attached.

    Notes:

    • The list includes AB Suite 2.0, 3.0, 4.0, 5.0, 6.1, or 7.0 runtime environment databases and existing SQL server databases.

    • Only the AB Suite runtime database names are appended with “(AB Suite)”.

  2. Select a database from the list.

  3. Click OK.

After attaching the database you can start the AB Suite system.