MS SQL (CE) Compact Edition – Tools

July 1, 2014

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


Display Line Numbers in SSMS Query Window

June 25, 2014

I am always looking where exactly I can activate the line numbers to show up, in the SSMS Query Editor.

image

Just for my own memory.


MS SQL Compressed Back Tool

February 17, 2013

Making MS SQL backups is quite easy using the build-in features.

But it is more efficient using the Compressed Backup Tool which you can download here http://mssqlcompressed.sourceforge.net/doc_command.shtml

The syntax us as follows :

msbp.exe backup "db(database=YourDB)" 
"zip64(level=3;filename=YourDB)" 
"local (path=D:\Temp\YourDB.zip)" 

The benefits are highly compressed backups compared to the native MS SQL backups.

image

Just give it a try