Create a DSWeb Database

Create a DSWeb Database

  1. Click New DSWeb Database in the DataSight Database group of the DataSight Administrator Ribbon. The Create Database view appears in the Main panel.
  2. Enter Database Database names can be alphanumeric and include spaces and underscore characters.
  3. A Microsoft SQL database has two physical files for a database; one for data and one for transaction logs. DataSight automatically sets the location and file name for these files, however you can choose alternate file names and locations. Data and log files don't have to be in the same location. You can put them onto different disks to increase database performance.
  4. Click Create. A dialogue box will open with the message Database: "<database name>" has been successfully created.

    • Related Articles

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

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

    • Update DSWeb

      Setup MS SQL Server Backup DS_WEB database. Execute the attached DS_Web_update.sql to update data schema for DS_WEB database. Please note that this SQL script includes cumulative updates since v2.5. Run the required scripts only and skip the scripts ...

    • DSWeb Administrator

      A DSWeb administrator controls aspects of the site appearance, data security and multi-level user access to specific data. An administrator manages: Log-in page logo and text User accounts Connections to DataSight databases Database banners and logos ...

    • Database Security

      DataSight database security is a combination of Microsoft SQL Server security coupled with DataSight application security. Both forms of security need to be implemented. DataSight Administrator helps you: Create and authenticate Microsoft SQL server ...