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.

  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.

Tip: If newly-created SQL servers or database names do not appear in the respective lists within the dialog box, click the Refresh button to make them appear.

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

  2. 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.

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

  4. 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.

  5. 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.

 

Note: There are several reasons why a database may not be created. If you don't have sufficient user privileges to create the SQL Server database, or if you have specified a database name that does not exist, then an error will occur. Check the user account and its privileges in the SQL Sever Management application you use (such as SQL Server Management Studio Express), as well as the existence, correct name, and path to troubleshoot the issue.

 

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. Right click the name of an inactive database and select 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.

 

Warning. Disconnecting a database can cause your applications to stop running. Be certain that you want to perform this operation and that you are disconnecting and connecting the correct local databases.

 

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.

  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.

  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.

Tip: If newly-created SQL servers or database names do not appear in the respective lists within the dialog box, click the Refresh button to make them appear.

 

  1. 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.

Note: You might see an error message appear indicating that the database is already on another server or does not exist. Check your current TrendWorX64 Logger configuration to ensure that the database does not already appear in the navigation tree, and make sure that you have created the local database before attempting to connect it to a server.

 

 

See also:

TrendWorX64 Logger