How can I manage SQL CE databases in SQL Server Management Studio?
You can create .sdf files with SQL Server 2008 Management Studio. In the File > Connect Object Explorer dialog, change the Server Type dropdown to SQL Server Compact Edition. Then in the Database File dropdown choose New Database…. and you’re ready to go.