DataSight Database Management

DataSight Database Management

Manage your Databases

  • Click Database Management in the DataSight Database group of the DataSight Administrator Ribbon. The View & Delete Database window appears in the Main panel.

View a Database

  1. Select a database from the list of DataSight databases. You will be able to see the data created, and the location and size of the database.
  2. Scroll through the Table Names and Row Counts in the database details grid to see the DataSight tables and how many records they contain.

Set the Database Time Zone

  1. Select a database name from the list of DataSight databases.
  2. Under the Database TimeZone column, select the Time Zone for your database from the drop-down list.
  3. Click the Save button to save the Time Zone settings.

Delete a Database

Note

The deletion of a database from the SQL Server is not a reversible process. You have must be sure you wish to perform this function before you proceed.
  1. Click to check the Delete checkbox(es) against any database that you wish to delete.
  2. When you close the panel, a confirm dialogue will display, asking if you wish to delete the database. Click Yes.

    • Related Articles

    • DataSight Database Upgrade

      DataSight is continually improving its database functions to deliver optimal solutions to users. For this reason, DataSight Administrator is provided with options to easily carry out the process of upgrading DataSight databases to the latest release. ...

    • Create a DataSight Database

      Click New Database in the DataSight Database group of the DataSight Administrator Ribbon. The Create Database view appears in the Main panel. Enter Database Database names can be alphanumeric and include spaces and underscore characters. Assign the ...

    • Restore DataSight database

      Thursday, 15 June 2017 Backing up a database and storing it at a secure location is excellent practice for preventing data loss. This is implemented by data houses on a regular basis. DataSight databases can be backed up and restored on the SQL ...

    • DataSight Administrator Ribbon

      The DataSight Administrator Ribbon is divided into sections which have different groups of features that carry out various database and user functions. The groups are as follows: DataSight Database DSWeb Database User Upgrades Minimize the Ribbon ...

    • DSWeb Database Management

      Manage your DSWeb Databases Click Delete DSWeb Database in the DSWeb Database group of the DataSight Administrator Ribbon. The View & Delete DSWeb Database window appears in the Main panel. View a DSWeb Database Select a database from the list of ...