Alarm Server Databases

When you install AlarmWorX64 , it creates a default SQL database for you to use. The Configurator A configurator is a form or set of forms that allow you to create, edit, and manage properties for a component. Configurators are an alternative graphical representation of property sheets with better descriptions and more access to tools. provides a Configuration Database Wizard for creating new SQL Server and SQL Server Express configuration databases for AlarmWorX64 Server.

Creating Databases

When you are creating a database for an Alarm Server, you can use an existing database as its basis or starting point if such a database already exists. To do this, you use the Import and Export features that are available in AlarmWorX64 Server. (For instructions, refer to Exporting and Importing AlarmWorX64 Server Components.) Otherwise, you must create the database from scratch.

To create a new database from scratch, follow these steps:

1. Right-click the database node, then select the New Database command from the context menu. Or, select the database node, then select the Database, New Database command from the Workbench Workbench is centralized Web-based environment for all GENESIS64 components' configuration. The WorkBench can also act as an advanced operator interface for service management and has built-in project management functionality Home ribbon. This launches a wizard.

   

2. In the AlarmWorX64 Server - SQL Database Wizard Select the SQL Server step, select Use Default SQL Server (recommended) or deselect that option and Select the SQL Server from the drop-down list. If you select the Select the SQL Server you will need to select the security option for accessing the database either: Windows Integrated Security (which is recommended) or User Name and Password. If you choose User Name and Password enter the User Name: and Password: in the text boxes.

   AlarmWorX Server New Database Wizard Step 1

   

3. Click the Next button.

4. On the Change the Most Common Database Options step, click the Database Name field and edit the name of the database to the one you want to create.

   AlarmWorX Server Change DB Options for New Database

   

5. To alter the size of the initial database file and log files as well as the manner in which they grow when filled, click the ellipsis button and select the method you desire. The file growth can be in terms of the number of megabytes added or a percentage of the file size; you can also specify the maximum size in MB or leave the maximum size unrestricted, if desired.

6. Click the Finish button.

AlarmWorX64 Server creates the new database file which should automatically appear in the tree control. If the database name does not appear within a few seconds, click the Refresh button to refresh the tree control.

7. After a database is configured, you can attach it and make it active (as described in this topic, below) and define the alarm configuration where OPC alarm tags will be defined (refer to Database Configurations).

Making a Database Active

Only one database can be active at a time. Active databases have an icon with a green arrow ; while inactive databases have an icon with a red icon .

To Make a Database Active:

• Right click the database name and select the Make Active command from the context menu.

Attaching and Detaching Databases

When you attach a local database A local database is one that is running on your current system. to the AlarmWorX64 Server it appears in the tree control where it is available to be used. You would need to make the database active to work with that database. If you want to move a database from one physical location to another, perhaps because it has run out of disk space, then you make an active database An active SQL database is one you can see in an application tree control, and which you can INSERT, APPEND, or DELETE records from. Only one database may be active at any one time. An active database is in a Read/Write state. inactive and detach it. The act of attaching and detaching a database applies to local databases only. Since the Workbench is a distributed .NET Framework application what you see in the navigation tree control is populated by an IIS web service, which can be either local or remote. Similarly, the databases you see in the tree control can be either local or remote. Therefore you should only apply attach and detach to databases you know are local, and be able to specify exactly the server instance and local database you want to operate on.

To Detach a Local Database:

1. Right click the database in the tree control that will be the active database, and then Make Active from the context menu, if necessary.

2. Right click the Database name in the tree control that you want to detach.  The context menu will display.

3. Select Detach from the menu.  The Detach Database confirmation message box displays.

4. Click Yes if the database named is the one you want to detach.

To Attach a Local Database:

1. Right click the Database host (localhost).  The context menu displays.

2. Select Attach Database... The AlarmWorX Server SQL Attach Database Wizard displays.

3. By default the Use Default SQL Server (recommended) is selected.  If you want to use the Default option skip to step 5 otherwise deselect that option and continue to the next step.

4. Select the SQL Server from the drop down list.  If you select the Select the SQL Server you will need to select the security option for accessing the database either: Windows Integrated Security (which is recommended) or User Name and Password.  If you choose User Name and Password enter the User Name: and Password: in the text boxes.

5. Click the Next button.

6. Click the Ellipsis button at the end of the Database file to Attach box to locate the database.  The Open database dialog box displays.

7. Locate and select the database you want to attach; then click the Open button.

8. Click the Finish button.

9. Right click the database and select Make Active from the context menu if you want to work with the database.