SQL Server 2005 Compact Edition (aka SQL Server Everywhere) Downloads

SQL Server Compact Edition Runtime

"SQL Server 2005 Compact Edition includes a Microsoft Windows Installer (.msi) file. The .msi file installs redistributable components to a specific location on the destination computer. To ensure serviceability and technical support, use the .msi file to deliver software components. Please see Redist.txt included in the package for component information.

SQL Server 2005 Compact Edition can be installed by running the installer - SQLServerCE31-EN.msi. Installing SQL Server 2005 Compact Edition by running SQLServerCE31-EN.msi installs the provider (System.Data.SqlServerCe.dll) in the GAC (global assembly cache) and registers the OLEDB provider (sqlceoledb30.dll). Doing this ensures that the components can be serviced in future by Microsoft Update..."

SQL Server 2005 Compact Edition Server Tools

"Microsoft SQL Server 2005 Compact Edition Server Tools installs the SQL Server 2005 Compact Edition Replication Components on the IIS box. The components are required for connecting the SQL Server 2005 Compact Edition database on a mobile device or a desktop or a tablet PC to a SQL Server database that are SQL Server 2000 SP3a, SQL Server 2000 SP4, SQL Server 2005, or SQL Server 2005 SP1 database....

SQL Server 2005 Compact Edition Developer SDK

"Microsoft SQL Server 2005 Compact Edition (SQL Server 2005 Compact Edition) is designed for developers who need light weight, in process relational database solution for their applications that can be developed and deployed on desktop, tablet PC and mobile devices.

• CAB files for installing SQL Server 2005 Compact on mobile devices
• MSI file for installing SQL Server 2005 Compact Edition on desktop and tablet PC
• Header files required for developing a native SQL Server Compact application
• MSI for installing the SQL Server 2005 Compact Edition Help Files
• Northwind sample application

"

More fun stuff to play with... I still which SQL 2005 CE supported SP's and triggers, but even without it's pretty darn cool and will be better than Access for many local host DB related projects.

Related Past Post XRef:
Visual Studio 2005 : Prepare for SQL Server Everywhere