Creating a Database

When you create a database, the Data Source Manager automatically registers it for use with Touchstone. You do not need to attach it. After creating one or more databases, you can view the list of databases.

To create a database:

1.     Launch Touchstone.

2.     Access the Data Source Manager.

3.     Click in the Database Name field of the blank row with the white Add icon.

The field becomes editable.

4.     Enter the following information:

a.     In the Database Name field, enter a name.

Avoid using the following characters in the database name: `-=~!@#$%^&_+{};',

b.     In the Type field, select EXP (exposure) or RES (results).

c.     Optionally, in the Size field, enter the size of the database (in kilobytes).

d.     Optionally, in the Growth field, enter the maximum size of the database (in kilobytes).

e.     In the MDF Path and LDF Path fields, accept the default paths (recommended).

The path fields are already populated with the default paths specified in the Server Definition pane.

You can also browse to a folder or file and navigate to a target database server, or enter a UNC path to a target location.

f.       Optionally, in the Description column, enter a description.

5.     On the ribbon, click Create.

The Registered value is "Yes" and the Status value is "Submitted".

6.     Press Enter.

The newly created database moves to the next row.

7.     Refresh the list.

The Status is now "ONLINE".

Related topics

•       Viewing the List of Databases