Is there support for Compact SQL Server?
No, .NET Micro Framework targets very tiny applications where compact SQL server will not fit. However, you can place your database logic on the back-end server and expose it via web-service or other network protocol. .NET Micro Framework supports TCP/IP sockets and HTTP protocol (including web-services). Mechanisms to store data in persistent memory exists in .NET Micro Framework.