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 to: DSS 4
Reference: TFS #221756
Knowledge base ID: 0277
Last updated: Jan 09, 2020
Tuan Dinh Cong
Comments