Creating databases

Under certain circumstances, you might need to create a new database, overwrite the default database assigned to a role, or assign a different database that is prepared by your IT Department if you plan on using a dedicated database server.

Before you begin

If you plan on overwriting the existing database with the new one, you should backup the existing database.

What you should know

All role databases are created from Config Tool, except the Directory database, which must be created from the Server Admin - Main Server page. The procedures are very similar in both cases. Therefore, only creating from Config Tool is described here.

To create a database:

  1. From the Config Tool home page, open the System task, and click the Roles view.
  2. Select a role, and click the Resources tab
  3. From the Database server drop-down list, type or select the name of the database server.
    The value (local)\SQLEXPRESS corresponds to Microsoft SQL Server 2014 Express Edition that was installed by default with Genetec™ Security Center. To specify a database server on a different server than the one hosting the role, enter the name of that remote server.
  4. From the Database drop-down list, type or select the name of the database.
    The same database server can manage multiple database instances.
  5. Click Create a database.
  6. Specify the database creation options.
    CAUTION: If you select the Overwrite existing database option, all current content of the selected database is lost.
  7. Click OK.
    The database creation starts. A window opens, showing the progress of this action. You can close this window and review the history of all database actions by clicking Database actions in the notification tray.
  8. Wait until you see Database status indicating Connected.