Umbraco 4.6.1 adds support for Microsoft SQL CE 4 which is an embedded database that works on shared hosting in medium trust. This page will explain how to configure and use SQL CE in Umbraco.
There are three ways to add SQL CE support to your Umbraco 4.6 instance:
1 - Download the prepared WebDeploy package with the required SQLCE assemblies included: http://umbraco.codeplex.com/releases/
2 - Add the Umbraco feed to Microsoft Web Platform Installer (WebPI) and install directly from WebPI
3 - Manually add the assemblies per the following instructions.
Requirements:
- Umbraco 4.6.1 (download from Codeplex)
- The SQLCE4Umbraco.dll assembly, which can be found on the release page
- The SQL CE 4 runtime binaries. If you already have SQL CE installed on your machine, these will be found in the folder %Program Files%\Microsoft SQL Server Compact Edition\v4.0\Private, or you can download using the links below. Make sure to pick the correct version (either 32 or 64bit):
– x86: go.microsoft.com/.../
– x64: go.microsoft.com/.../
Configure:
- Copy the SQL CE 4 binaries to the /bin folder of the Umbraco installation (the System.Data.SqlServerCe*.dlls and the amd64 and x86 folders)
- Also copy the SQLCE4Umbraco.dll assembly to the /bin folder
- Start the Umbraco installer /install
- In the database step choose "SQL CE 4" as the type
- Finish the installer.
Known issues: