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
||SQL Compact Edition (Default)
||SQL Server Express
||SQL Server on-prem or on Azure
|Recommended max. number of resources
||20 resources||No limitation
||Included in DSS for Server installer
|Plan to support future advanced features such as reports, statistics?
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.
Applies to: DSS 4
Reference: TFS #221756
Knowledge base ID: 0277
Last updated: Jan 09, 2020