Sales
Denmark +45 7944 7000
Europe +45 7944 7000
North America +1 (202)-536-4165
Support
Denmark +45 7944 7002
North America +1 (202)-536-4165
Start a conversation

Different database possibilities for DS Service

Summary

DS Service can be used with different databases, each of which is suitable for a purpose or a scale. This knowledge base will provide you with features of each database possibility so you can make your own decision.

Compare Microsoft SQL Server Compact (DB Compact) with other SQL Server editions


Criteria
SQL Compact Edition (Default)
SQL Server Express
SQL Server on-prem or on Azure
Database size
4 GB
10 GB
524 PB
Performance
Limited Good
Excellent
Is recommended?
No
Yes
Yes
Recommended max. number of resources
5 resources
20 resources No limitation
License
Included in DSS for Server installer
Free
Paid
Plan to support future advanced features such as reports, statistics?
No
Yes
Yes

Recommendation

The default implementation of SQL Compact Edition with the product is intended for easy demo deployment, and might suffice for a smaller customer. We recommend to use SQL Express/Web or a fully licensed SQL version to achieve better performance, and we do support migration of data from the initial SQL Compact Edition database when an SQL option is configured.

For more details about the different SQL editions, please have a look at this brochure.

Here is a link to download SQL Express. If you want to know about system requirements before installing SQL server, please visit this webpage.

Properties

Applies toDSS 4
Reference: TFS #221756
Knowledge base ID: 0277
Last updated: Jan 09, 2020

Choose files or drag and drop files