TrendWorX Server Databases

The TrendWorX64 Logger includes a new database dialog box for creating new SQL Server and SQL Server Express configuration databases. When you install TrendWorX64 some default databases are created for your use. However, you may wish to create additional databases for specific purposes or to run in multiple locations.

Creating Databases

1. Right click the server node in the TrendWorX64 Logger navigation tree (called "localhost" by default), then select the New Database command from the context menu. Or, select the server node, then select the New database... command in the Edit group on the Home ribbon. The Create a new Database dialog box appears.

   Creating a New Database with the "Create a new Database" Dialog Box

   

    

   
   Creating a Database with the "New Database..." Command
   
     

    

2. Under SQL connection Settings, select the SQL server from the provided list that contains the database to which you wish to connect the logger.

3. Enter a database name or select one from the list.

4. Enable the Include sample data check box if you would like the selected database to contain data for testing the logger configuration.

5. Under File Size Settings, set the initial size of the database file in megabytes as well as the manner in which it grows when filled. You can specify the growth as an absolute amount in megabytes or as a percentage of the database size.

6. Enable the Restrict max size to check box to limit the size of the database file to a specific amount in megabytes.

7. Under Log File size settings, you can complete the same file size and growth configuration for log files as you did in steps 5 and 6 for database files.

8. Click OK to close the dialog box. The new database appears as an inactive database in the navigation tree. If the database does not appear within a few seconds, click the Refresh button, and the new database should then be displayed in the navigation tree.

Activating Databases

Only one database can be active at a time. An active database has a database symbol with a white arrow in a green filled circle while an inactive database has a database symbol with a white square in a red filled circle .

To Make a Database Active:

1. 1. Right click the name of an inactive database and select the Make Active command
      Activating a Database with the "Make Active" Command
      
      from the context menu. You can also select an inactive database and click the Make Active command in the Edit group on the Home ribbon. The database becomes active, and the database that was previously active becomes inactive.

Connecting and Disconnecting Databases

When you attach a local database to TrendWorX64 Logger it appears in the TrendWorX64 Logger navigation tree where you can use it. You need to make the database active in order to work with that database. If you wish to move a database from one physical location to another, perhaps because it has run out of disk space, then you can make an active database inactive and disconnect it.

The act of connecting and disconnecting a database applies to local databases only. Since the the Workbench is a distributed web application what you see in the TrendWorX64 Logger navigation tree is populated by an IIS web service, which can be either local or remote. Similarly, the databases you see in the tree explorer can be either local or remote. Therefore you should connect and disconnect only the databases that you know are local, and you should be able to specify exactly the server and local database on which you wish to operate.

To Disconnect a Local Database:

1. If the database to disconnect is active, make a different database on the server active by following the instructions for activating databases.
2. Right-click the database in the TrendWorX64 Logger navigation tree to disconnect and select the Disconnect Database command. You can also select the database and click the Disconnect Database button in the Edit group on the Home ribbon.

   Disconnecting a Local Database with the "Disconnect Database" Command

   

    

3. A message appears, asking you to confirm your disconnecting action. If you are sure you want to disconnect the local database you have selected, click OK.
4. The database disappears from the navigation tree but remains on the SQL server.

To Connect a Local Database:

1. In the TrendWorX64 Logger navigation tree, right-click the server to which you wish to connect a local database and select the Connect Database command. You can also select the server and click the Connect Database... button in the Edit group on the Home ribbon. The Connect an existing Database dialog box appears.

   Connecting an Existing Local Database to a Server with the "Connect an existing Database" Dialog Box

   

    

   Connecting a Local Database to a Server with the "Connect Database" command

   

    

2. Under SQL connection Settings, use the pulldown lists to select the SQL server on which you wish to connect the local database as well as the Database name corresponding to the database you wish to connect.

3. Click OK to exit the dialog box. The database appears beneath the selected server in the navigation tree. If the database does not appear within a few seconds, click the Refresh button, and the connected database should then be displayed in the navigation tree.

See also:

TrendWorX64 Logger