MS SQL – (CE) Compact Edition – Tools

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

http://sqlcecmd.codeplex.com/

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 ++++

http://www.linqpad.net/

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/…