How do I get started

Congratulations, you have now installed the add-in.
To start using it in Visual Studio, launch the Toolbox from the button in Server Explorer, or from the Tools menu:


If you like this free tool, I would be very grateful for a review

You can always get in touch with me on Twitter

The Toolbox requires one of these SQL Server Compact runtime MSIs to be installed, if you want to connect to a SQL Server Compact database file;
Download 3.5 SP2 - installed with VS 2010
Download 4.0 SP1 - installed with VS 2012
(No runtimes are installed with VS 2013 and VS 2015)

How do I use the SQL Server Compact & SQLite Toolbox

If you would like more information about using the Toolbox, you can watch a 32 minute demo video (version 4, mainly SQLite) or watch a 25 minute demo video (version 2.6 (SQL Compact) on Channel 9, or you can download an overview e-book Building Standalone Data-Driven Applications using SQL Server Compact 4.0. I also have a number of feature blog posts available.

Known Issues

Demo video on Channel 9 (version 4.0)

Demo video on Channel 9 (version 2.6)

How do I contribute

If you encounter a bug or have a feature request, please use the Issue Tracker
The Toolbox is open source and welcomes any contribution.

How to Guides

Last edited Mar 5 at 2:25 PM by ErikEJ, version 80


mommyof4grlz Dec 5, 2015 at 6:06 AM 
I am brand new to development in every way shape and form. I am very confused by sqlite. I know sql but I can't seem to figure out how to use sqlite. I can't figure out what to install or what to add to my VS. I am using VS2015 community, I am trying to learn VB .NET and I'm trying to create a WPF project. Any guidance would be amazing. I keep reading blogs, tutorial, watching videos and reading forum posts and I feel more confused than ever!

dwba Aug 28, 2013 at 4:56 PM 
Ref previous note - now realised need to execute twice, 2nd time for generated script! Problem now is Error Code 80040E14 in trying to match up columns where first column/field is PK (sys gen'd value) name NodeID and extra comma inserted at beginning of each csv line where no value can be passed in.

dwba Aug 28, 2013 at 4:15 PM 
Just created a test sdf database for use in VS2010 Pro and WebMatrix 3. Wanted to input from csv and used the created script from my csv file which which created the insert statements OK but didn't load any data. Does the script have to run somewhere else? Script to Edit a row enabled an insert OK. Tried the standalone and plugin versions with same results .... John M P. Christchurch UK
Be nice to have an option on CSV import to optionally use or not have a first field names line.

Proshuto Jun 18, 2013 at 4:43 PM 
Hi, after installing the add-in for VS2012 I am trying to add a 3.5 connection -> Test Connection succeeds, but when I press Ok no connection is added.

ErikEJ Apr 23, 2013 at 7:33 PM 
Jlomax: You 3.5 install in broken - make sure both the x86 and x64 MSIs are properly installed, or repair/reinstall.

jlomax Apr 23, 2013 at 5:31 PM 
I have SQL Server CE Cumulative Update 6 installed, and the latest from NuGet ( says "Runtime 3.5 not found" With no support for SQL CE in SSMS 2012, I really hoped this extension would fill the gap.

ErikEJ Nov 21, 2012 at 5:39 PM 
mlshoe: Have you checked the Tools menu?

mlshoe Nov 21, 2012 at 12:45 PM 
I just installed the latest upgrade. The button does not appear in my toolbox. I don't see an issue like that in the knowledge base.

ErikEJ May 3, 2012 at 4:25 PM 
Thanks, updated with new link

jradxl May 3, 2012 at 9:55 AM 
The link, gives a 404 error