Selecting the right database format

What is that database for?

Promodag Reports requires a database in order to store the data it collects from native Exchange data sources . It will then use this data to generate reports. It is possible to create multiple databases. See Also

Supported database types

The database must be created using Promodag Reports because of its specific structure . The product supports two different database management systems depending on the edition used in licensed or evaluation mode.

SQL Server Express LocalDB

• Best suited for small Exchange organization.
• Usable with all editions of Promodag Reports.
• The physical size limit set by Microsoft to SQL Server Express LocalDB database files is 10 GB (10,240 MB).
• Microsoft SQL LocalDB 2017 is installed with Promodag Reports.
• No multi-user access.
• The database file should be located on the same computer as Promodag Reports.
• Easy upgrade to SQL Server.

Microsoft SQL Server

• Best suited for medium or large Exchange organization.
• Requires the Enterprise edition of Promodag Reports.
• The database size is only limited by disk space on the SQL Server.
• An additional SQL Server license (not provided) may be required.
• Multi-user access.
• Performance is determined by the power of the SQL server.

For more information about available editions and supported database types, see Licensing schema, Using Promodag Reports and SQL Server Express LocalDB and Using Promodag Reports and Microsoft SQL Server.

SQL Server Express (2008 to 2022) may be used with Promodag Reports Enterprise edition; however, database size is limited depending on the version (10 GB for SQL Server 2008 R2/2022 Express and 4 GB for SQL Server 2008 Express).

For more information about creating and opening a database in Promodag Reports, see Creating a new Promodag Reports database, Open database, and Recent Databases.

of