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

image

And of course don’t forget your Powershell !

Here is a shortlist :

SQL CE Schema Script Utility

http://exportsqlce.codeplex.com/

image

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/

image

SQLCE Commandline tool

http://sqlcecmd.codeplex.com/

image

Bulk Insert Tool

http://sqlcebulkcopy.codeplex.com/

image

SQL CE Toolbox

http://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1/

image

Query and Database Management Tools

MS SQL CE Analyzer

http://sqlcequery.codeplex.com/

image

CompactView

http://sourceforge.net/p/compactview/home/Home/

image

LinQPad : Supports SQL CE, SharePoint and SQLite, and moreMust have tool ++++

http://www.linqpad.net/

image

SQLite and SQL CE together in 1 GUI

image

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/

image

Open MS SQL Compact using the management Studio
Choose the correct Server Type !

image

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: