Project Hosting for Open Source Software
SQL Server Compact & SQLite Toolbox
Are you Sure?
By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored.
Change History (all pages)
All Project Updates
Wiki & Documentation
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
You can always get in touch with me on
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)
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
How do I contribute
If you encounter a bug or have a feature request, please use the
The Toolbox is open source and welcomes any contribution.
How to Guides
Mar 5 at 2:25 PM
, version 80
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!
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.
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.
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.
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.
Apr 23, 2013 at 5:31 PM
I have SQL Server CE Cumulative Update 6 installed, and the latest from NuGet (220.127.116.11) says "Runtime 3.5 not found" With no support for SQL CE in SSMS 2012, I really hoped this extension would fill the gap.
Nov 21, 2012 at 5:39 PM
mlshoe: Have you checked the Tools menu?
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.
May 3, 2012 at 4:25 PM
Thanks, updated with new link
May 3, 2012 at 9:55 AM
The link, http://www.vistadb.net/onlineh
elp/_2w90toeg6.htm gives a 404 error
Sign in to add a comment
© 2006-2016 Microsoft
Code of Conduct
Advertise With Us