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 Server Compact (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 | Free (Included in DS Service installation) | Free | Paid |
| Plan to support future advanced features such as reports, statistics? | No | Yes | Yes |
Recommendation
The default implementation of Microsoft SQL Server Compact included with the product is intended for easy demo deployment and may not be sufficient for a production environment, for better performance, we recommend using Microsoft SQL Server Express or a fully licensed version of Microsoft SQL Server. We also support data migration from the initial Microsoft SQL Server Compact database when an upgraded SQL option is configured.
For more details on the different Microsoft SQL Server editions, please refer to this brochure.
If you'd like to download Microsoft SQL Server Express or review the system requirements, please visit this Microsoft webpage.
Properties
Applies to: DSS 4
Reference: TFS #221756
Knowledge base ID: 0277
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article