Deployment Considerations

  • Article

This section describes two primary considerations for deploying SQL Server Compact 3.5 applications:

Besides these topics, if you are upgrading an existing SQL Server database, see Upgrading from Earlier Versions (SQL Server Compact).

Important

SQL Server Compact 3.5 is not currently optimized to serve as a database for Web sites. By default, connections from ASP.NET-connected applications are blocked.

SQL Server Compact 3.5 is optimized for use as an embedded database within applications. Using SQL Server Compact 3.5 as a database for Web sites requires support for multiple users and concurrent data changes. This can cause performance problems. As a database for Web sites, use SQL Server 2005 and later versions, or SQL Server 2005 Express Edition and later versions. These platforms are more appropriate for Web sites.

Use SQL Server Compact 3.5 with ASP.NET in application scenarios where ASP.NET is used to create SQL Server Compact 3.5 databases for synchronization. Use the following code to change the default behavior of SQL Server Compact 3.5 to work within ASP.NET.

AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", true)