With VS2010 sp1, we added SQL CE 4.0 support. You can view more information about SQL CE 4.0 from the following sites: Here is a walk through of how to deploy a SQL CE database to SQL Server database using web application publish. 1. Create a web application 2. Add a SQL CE 4.0 database via “Add New item”: 3. In server ...