Enterprise
Schedule Free DemoSupportBlogDemos
Try it Free
Search results
Suggest a FeaturePDF

Starting from version 7.1, Bold Reports® introduced a feature that supports a single database for all sites.

Single Database For all sites

Bold Reports® now supports a Single Database for All Sites, enabling all sites to share the same database while reusing existing tables. Unlike traditional multi-tenancy, where each site has separate tables, this approach leverages a common set of tables for all sites, ensuring efficient resource utilization, simplified maintenance, and enhanced performance.

This feature is designed to minimize database overhead, improve scalability, and ensure logical data isolation at the application level.

Note: Currently supported only for PostgreSQL and MSSQL databases. Other database engines are not yet compatible with this feature.

Step 1

Application Installation and Activation

  • Download the Bold Reports® application from the Downloads page.
  • After downloading the application, create a new user account. Application Startup Page

Step 2

Database Configuration

  • Select the Shared Database option to configure a single database for all tenants, eliminating the need to create separate databases for individual sites.

    Single Database For All Sites

  • When you choose the Shared Database option, the available server types are MSSQL and PostgreSQL.

  • Provide the Server Type (either MSSQL or PostgreSQL) and the corresponding server connection details. Server Types

MSSQL Database Configuration:

  • Select the server type as MSSQL.

  • Enter the server name and provide the MSSQL credentials.

  • You can connect to the MSSQL Server using the below options.

    • New database.
    • Existing database.

    MSSQL Server Type

PostgreSQL Database Configuration:

  • Select the server type as PostgreSQL.

  • Enter the server name and provide the PostgreSQL credentials.

  • You can connect to the PostgreSQL Server using the below options.

    • New database.
    • Existing database.

    Database Option

Common Configuration Steps

  • You can configure the server details in both Simple and Advanced modes. Please refer to the relevant section for more details.

  • If you proceed with Advanced mode, refer to this section for Storage Configuration.

    Note: When trying to create a site after deploying the application, the select database option doesn’t appear because the Shared Database option was selected during deployment. No Database Option

See Also:

Key Benefits

  • Optimized Resource Utilization – Reuses existing tables instead of duplicating them for each site.

  • Simplified Maintenance – Eliminates the need to manage multiple sets of tables for different sites.

  • Data Segregation & Security – Ensures that each site accesses only its own data using secure identifiers.