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
http://exportsqlce.codeplex.com/
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]
http://sqlcetoolbox.codeplex.com/
SQLCE Commandline tool
Bulk Insert Tool
http://sqlcebulkcopy.codeplex.com/
SQL CE Toolbox
http://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1/
Query and Database Management Tools
MS SQL CE Analyzer
http://sqlcequery.codeplex.com/
CompactView
http://sourceforge.net/p/compactview/home/Home/
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
http://blog.bendsoft.com/2013/01/minisqlquery-with-sharepoint-connector-3-0/
http://blog.bendsoft.com/2013/01/minisqlquery-with-sharepoint-connector-3-0/
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.
Also see social.msdn.microsoft.com/Forums/en-US/sqltools/thread/… and
weblogs.asp.net/scottgu/archive/2011/01/11/…