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

Advertisements

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