Manage Databases

Three main databases are created during System Manager installation:

  • Job Database - Contains the configuration data for all devices in the job.

  • Trending Database - Contains time series data for reporting and notional power calculations.

  • Alarms & Events Database - Contains records of system alarms and events.

Click the Manage DB’s button to open the Database Maintenance window. From here, you can perform the following actions:

  • Choose a working database

  • Back up your existing database

  • Restore your database from a backup

  • Archive old historical data

  • Reload and upgrade your database after making changes in System Builder

sm db maintenace
Regular database backups protect your information in the event of a computer failure.

Choosing a Database

  1. Click the Choose a Database button from the Database Maintenance window. This opens the Job Database wizard.

  2. Set the Server Name to Computer Name\EMSERVER and select the working Database Name from the dropdown list. Click Next

    sm choose db

  3. Select the Trend database or if the database does not yet exist, enter a name and check Create new database. Click Next.

  4. Select the Alarms and Events database. or if the database does not yet exist, enter a name and check Create new database. Click Next.

  5. Select the Reports database, if required or if the database does not yet exist, enter a name and check Create new database. If there is no requirement to export your reports to a database, then leave this field blank . Click [.sbbutton]#Next*.

  6. Click Execute.

  7. Click Finish to exit the wizard.

Backing up a Database

Backup the databases regularly to create a recent copy, in case the active database becomes corrupted.

  1. Click Backup Database from the Data Maintenance window.

    sm db backup

  2. Check the databases that need to be backed up and click Next.

  3. Click Execute to backup databases.

  4. Click Finish to close the wizard.

Restoring a Database

The Restore Database wizard retrieves the data from a previous backup.

  1. Click Restore Backup from Database Maintenance window.

  2. Check the databases that need to be restored and click Next.

    sm db restore

  3. Click Execute to restore database.

  4. Click Finish to close the wizard.

Archiving a Database

If you do not need to retain all historical data in the database, it is possible to move this data to an archive database.

  1. Click Archive Database from the Database Maintenance window.

  2. Select the Archive data before date so that the data before the selected date can be archived.

  3. Select the databases that need to be archived. Click Next.

    sm db archive

  4. Click Execute.

  5. Click Finish to exit the wizard.

Reloading and Upgrading Databases

If the working database is modified by System Builder, then before running System Manager client, the database should be reloaded and upgraded to the modified version.

  1. Click Reload & Upgrade Databases from the Database Maintenance window.

  2. Click Next.

  3. Click Execute.

  4. Click Finish to exit the wizard.

    sm db reload

Saving to a database in System Builder

You can save an existing System Builder job file as a database for use in System Manager.

  1. Open the job file for an existing project with System Builder.

  2. Click File > Save As > Save To Database.

    sm db save to

  3. Enter the Server Name

  4. Select the database from the Database name drop-down list, or if you want to save the project as a new database, enter the name of the new database.

  5. Click OK

Your project has now been saved to the database and can be opened with System Manager.

Creating a new database in System Builder

You can create a new System Builder project as a database for use in System Manager.

  1. Open System Builder.

  2. Click File > New > New Empty Database.

    sm db create empty

  3. Enter the server name or enter .\EMSERVER.

  4. Enter the database name.

  5. Enter the Job title name.

  6. Click OK.

Now you have created a blank project database.

Opening a database in System Builder

You can open a System Manager database in System Builder, make changes, and resave to the database.

  1. Stop System Manager Server from Windows Task Manager services.

  2. Open System Builder.

  3. Select File > Open > Open database

  4. Select the active System Manager database.

  5. Click OK.

    sm db open

  6. Make the required configuration changes in System Builder.

  7. Select File > Save to save the database.

  8. Close System Builder.

  9. Start System Manager Server from Windows Task Manager services.

If you do not save to the database, you may lose all the changes you have made to the System Manager configuration.