There a lot of nice Tools and utilities around to work with MS SQL CE, apart from the Webmatrix interface
And of course don’t forget your Powershell !
Here is a shortlist :
SQL CE Schema Script Utility
Also has commandline utils that can convert SQLCE to SQLite
Usage : (To script an entire database to SQLite format)
ExportSQLCE.exe [SQL CE Connection String] [output file location] [sqlite]
SQLCE Commandline tool
Bulk Insert Tool
SQL CE Toolbox
Query and Database Management Tools
MS SQL CE Analyzer
LinQPad : Supports SQL CE, SharePoint and SQLite, and more … Must have tool ++++
SQLite and SQL CE together in 1 GUI
Mini SQL Query : Supports SharePoint and SQLite
Open MS SQL Compact using the management Studio
Choose the correct Server Type !
Some issues in later versions of the SQL CE edition :
Just to add a brief update now that SQL CE 4.0 is out. SQL management studio 2008 does not support SQL CE 4.0.
There are some helpful tools at sqlcetoolbox.codeplex.com.