Your extension will be available shortly on the Visual Studio Marketplace at this link.

SQLite / SQL Server Compact Toolbox

Free

SQLite / SQL Server Compact Toolbox extension for Visual Studio. This extension adds several features to help your embedded database development efforts: Scripting of tables and data, import from SQL Server and CSV files and much, much more.

4.8 Star
(244)
Visual Studio
2017, 2015, 2013, 2012
Download (631,730)
3/26/2017
4.7.87
View
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Description
Sign in to write a review
Sort by:

5 Star
by hardono | December 11 2014

Thank you for this powerful add-in Erik. Many kudos for saving the day. Without this tool many of us would have just skipped SQL Server Compact and forced to use SQL Server Express.

5 Star
by Jeff.Bowman | December 05 2014

It has been with disappointment that we've had to watch as Microsoft over the years has slowly and step-by-step dismantled support for SQLCE in Visual Studio (and SSMS/E as well). Their excellent small-footprint, low-overhead, file-based database has lost their attention; it's gone the way of the venerable FoxPro.

Enter ErikEJ and his suite of tools. He has saved the day. We can confidently continue with our SQLCE-based projects.

It's got a few minor quirks here and there; it's not quite to the level of a commercial product, but then... it's not a commercial product.

Erik is very attentive to any topic surrounding SQLCE. He can be readily found frequenting any of the many SQLCE discussion forums. He's always available for support questions, is very helpful and he replies quickly.

Most projects of this nature require us to choose between support, documentation and quality. With SQL Server Compact/SQLite Toolbox we can have all three.

Thanks Erik, keep up the good work.

Jeff Bowman
Fairbanks, Alaska

5 Star
by Kountree | December 02 2014

I have downloaded and used SQL Server Compact/SQLite add-in for Visual Studio. The tool picks up where our buddies in Redmond (Microsoft) left off. I found his tool to be very intuitivewith a dash of ingenuity. An example would be importing data from a Comma Seperated Value (csv). Initially, I had one column to import the data. The tool is intuitive where the selection is available by right clicking the table. The ingenuity is where the csv will have to be modified to be used by the tool. Here is an example:

My file contains
A,1
B,1
C,1
d,0

The table definition contain fields

(pk) TableID (indentity(1,1) not null
letter (varchar(25) not null
IsCapital (bit not null)

By modifying the file by placing the field names as a first row, helps with the import.

letter,IsCaptital
A,1
B,1
C,1
d,0


Great Job Erik. As we say in Ohio,USA "U are da Man." Translated "You did a wonderful job in developing this tool. Much kudos goes out."

5 Star
by PwAtHotmail | November 30 2014

Very glad that there are people in the world that makes it easier for others ( like me ) to do software development. And they do it for free.
You Erik is one of them, thank you very much for a super product and quick feedback.

5 Star
by ilyasnsk | November 20 2014

Erik, thank you for these very useful tools.

5 Star
by Ahmed Abulwafa | November 16 2014

Helped me a lot with my Universal App project.
overall it's a great tool and a must-have.
Good job Erik!

5 Star
by SilverSideDown | October 16 2014

This tool is a must-have, and I use it daily for project work. It's installed on all Windows dev machines. It's incredibly sad that MS won't support CE in their SQL Management Studio, so thank goodness for Erik's efforts in getting us the next best thing. Microsoft should be sending him checks for doing their work for them.

Also want to personally thank Erik for being responsive on Twitter and quickly posting a build with a bug fix that I needed (for long text fields & row height). I was blown away by the response time, thank you so much.

5 Star
by Ilija Injac [MVP] | October 07 2014

The SQL Server Compact/SQLite Toolbox is a tool EVERY Windows Developer should
have installed.

I made the experience that even if the download count is > 300K,
that many devs still don't know how to leverage the real
power (or potential) of the tool.

Maybe more tutorials (real world scenarios would help). Or just tweeting more
about blog-posts.

Thanks again Eric, great tool!

5 Star
by mattilaj | September 04 2014

Great work! Needed to quickly create documentation for a database and the toolbox provided very nice autogenerated images and HTML. Thanks for the effort!

5 Star
by Hultqvist | August 18 2014

Works as expected with no surprises.

I have been using the code generation for LINQ.
Compared to older DB techniques, automatic generated IDs are just there, no need to request it explicitly.

The tool is now the only one I use.

5 Star
by Ed (DareDevil57) | August 14 2014

Thank you.

5 Star
by mwasson74 | August 13 2014

Great and extremely indispensable tool, I wouldn't be able to do this any other way. Very easy to use and Erik offers wonderful support!!

5 Star
by Someone_Ca | August 13 2014

Excellent tool!..

I am searching for editing of Sql Server Ce database table and I've found this tool. Thanks for it.

5 Star
by Dan Randolph | August 03 2014

This tool is really nice. I just watched the Channel 9 video again and noticed the support for Windows Phone data models.

http://channel9.msdn.com/Shows/Visual-Studio-Toolbox/Visual-Studio-Toolbox-SQL-Server-Compact-Toolbox

I am really interested in developing my own plugin to generate code for my company's SOA design pattern.

5 Star
by Dennis Mlinaric | July 30 2014

Thanks Erik. Amazing work. Your ongoing support of SQL CE is very much appreciated and I regard your tools as being essential.

5 Star
by David Totzke | July 24 2014

If you're working with SQL CE then you need this tool. Actively supported and updated, this toolbox has all the features you could want or need.

5 Star
by nekopczynski | July 24 2014

I recently took over a contract using SQL ce to replicate large data from SQL server. This add in and the bulk copy add in were real life savers. I was able to script around transferring {a million rows plus} data back and forth between the two. Excellent product and really easy to use. Thanks ErikEJ

5 Star
by gepetkov | July 14 2014

Wonderful!

5 Star
by OldSkoolMadSkilz | June 24 2014

Excellent tool. Simplifies tasks that would take a LOT of time using other methods. Wish I has it years ago. Would have saved me countless hours of time.

5 Star
by William Boatin | June 17 2014

I have found your posts and tools useful in getting my MSTest unit tests to use SQL Server CE, successfully.
Thank you!

121 - 140 of 209 Items   
Sign in to start a discussion


  • parameter tables for code support
    2 Posts | Last post September 21, 2016
    • Hi I am still in analysis phase of developing rewriting an application previously developed in MS access over to vb.net with SQL server. One of the techniques I used with access is that I had a number of program support tables - table driven programming (code processing depending on user input are parametrized instead of hard coded) those data were stored in the front-end db rather then in the user's (back-end) database. with vb.net and SQL server as back end the question arises how to store and distribute those front-end data they have to be randomly accessible. Access table, xml or SQL server compact. Is SQL server compact compatible with SQL server on the same machine ?
    • It is completely different product, so if you mean can it be installed side by side with SQL Server, then yes. See my blog for various posts on deployment.
  • Add SQL Server Compact is grayed so cant use it
    2 Posts | Last post September 12, 2016
    • Hi,
      I am using the SqlCe40Toolbox.exe but when I right click to add a connection tha option is gray. What should I do?
      
      Thanks
      
      Eric
    • You need to install the SQL Server Compact 4.0 runtime - https://www.microsoft.com/en-us/download/details.aspx?id=30709 
  • "The specified type isnt supported"-Error during creation of DataSet
    2 Posts | Last post September 05, 2016
    • Hello,
      I want to create a DataSet from a Connection to a Compact 4.0 Database.
      However, every time I am getting the following Error message:
      "An error occurred while retrieving the information from the database:
      The specified type is not supported by this selector".
      The NuGet package Microsoft.SqlServer.Compact as well as the MS Sql Server Compact SP1 x64 are installed.
      Know how to fix it?
    • Without seeing your code it is impossible for me to help you - and not really sure how this relates to the Toolbox... Suggest you post more information, incl code either on Stackoverflow or https://github.com/ErikEJ/EntityFramework.SqlServerCompact/issues/new 
  • Support for vs 2015 express
    3 Posts | Last post September 02, 2016
    • Hello,
       I am trying to use SQL Server Compact/SQLite Toolbox with Visual Studio 2015 Express for web. But i can't  install it. Does exist any version that I could use? thank you. 
    • You can use VS Community instead or there is a standalone version on CodePlex
    • ok erik
      
      Let me change to the community edittion.
      
      thank you.
  • External Tool
    2 Posts | Last post August 30, 2016
    • Hi, i need to schedule export from sdf to sqlite for many db's.
      There is a command line tool?
      
      Thanks
    • Sorry, found it!
      Great Tools. Thanks
  • Toolbox is Empty?
    2 Posts | Last post August 30, 2016
    • After installing the toolbox, when ever i click on it, its empty. It only shows is the SQL Server Compact Data Types. I dont see any of the menu options as shown. Any ideas? Help? Im pulling out my hair..
    • You need to connect to a database, right click the root node (Data Connections) to do that - then you can start working with it.
  • Cannot install on VS 2015 Community
    5 Posts | Last post August 15, 2016
    • Hello
      I have a problem with installing the toolbox on VS 2015 Community version. It says it didn't find any installable applications. Can you help?
      
      Here is the log:
      
      2016-08-15 11:58:59 - Microsoft VSIX Installer
      2016-08-15 11:58:59 - -------------------------------------------
      2016-08-15 11:58:59 - Initializing Install...
      2016-08-15 11:58:59 - Extension Details...
      2016-08-15 11:58:59 - 	Identifier         : 41521019-e4c7-480c-8ea8-fc4a2c6f50aa
      2016-08-15 11:58:59 - 	Name               : SQL Server Compact/SQLite Toolbox
      2016-08-15 11:58:59 - 	Author             : ErikEJ
      2016-08-15 11:58:59 - 	Version            : 4.5.0.2
      2016-08-15 11:58:59 - 	Description        : SQL Server Compact/SQLite Toolbox add-in for Visual Studio. This add-in adds several features to help your embedded database development efforts: Scripting of tables and data, import from SQL Server and CSV files and much, much more.
      2016-08-15 11:58:59 - 	Locale             : en-US
      2016-08-15 11:58:59 - 	MoreInfoURL        : http://sqlcetoolbox.codeplex.com/
      2016-08-15 11:58:59 - 	InstalledByMSI     : False
      2016-08-15 11:58:59 - 	SupportedFrameworkVersionRange : [4.0,4.9]
      2016-08-15 11:58:59 - 
      2016-08-15 11:58:59 - 	SignatureState     : Unsigned
      2016-08-15 11:58:59 - 	Supported Products : 
      2016-08-15 11:58:59 - 		Microsoft.VisualStudio.Pro
      2016-08-15 11:58:59 - 			Version : [10.0]
      2016-08-15 11:58:59 - 		Microsoft.VisualStudio.Pro
      2016-08-15 11:58:59 - 			Version : [11.0]
      2016-08-15 11:58:59 - 		Microsoft.VisualStudio.Pro
      2016-08-15 11:58:59 - 			Version : [12.0]
      2016-08-15 11:58:59 - 		Microsoft.VisualStudio.Pro
      2016-08-15 11:58:59 - 			Version : [14.0]
      2016-08-15 11:58:59 - 		Microsoft.VisualStudio.Pro
      2016-08-15 11:58:59 - 			Version : [15.0]
      2016-08-15 11:58:59 - 
      2016-08-15 11:58:59 - 	References         : 
      2016-08-15 11:58:59 - 		-------------------------------------------------------
      2016-08-15 11:58:59 - 		Identifier   : Microsoft.VisualStudio.MPF
      2016-08-
      
      
    • 2016-08-15 11:58:59 - Searching for applicable products...
      2016-08-15 11:58:59 - Found installed product - Microsoft Visual Studio Express 2012 for Web
      2016-08-15 11:58:59 - Found installed product - Microsoft Visual Studio 2015 Shell (Integrated)
      2016-08-15 11:58:59 - Found installed product - Microsoft Visual Studio Express 2015 for Windows Desktop
      2016-08-15 11:58:59 - Found installed product - Global Location
      2016-08-15 11:58:59 - Found installed product - ssms
      2016-08-15 11:58:59 - Found installed product - ssms
      2016-08-15 11:58:59 - VSIXInstaller.NoApplicableSKUsException: This extension is not installable on any currently installed products.
    • No extensions, including this one, work with VS Express, you need Community edition (free) or higher (Pro/Enterprise)
    • I am guessing that you have installed Express, not Community!
    • Good guess, sorry for trouble
  • SQL Server Compact Toolbox right click not working
    2 Posts | Last post August 12, 2016
    • I have a Compact Server 4.0 database.  I need to look at one of the tables.  When I right click on a table, the context menu only has refresh and properties.  What are the steps to fix this?
      
      I have VS 2015.  When I try to reinstall the toolbox, only VS2013 appears.
      
      Bob
    • You are looking at Server Explorer, open the Toolbox to get the full experience, from the Tools menu, or use the Icon is Server Explorer 
  • Tutorials For Windows IOT Core
    4 Posts | Last post August 02, 2016
    • Please let me know if you are aware of any online tutorial for creating a brand new SQLite database intended for the Windows 10 IOT Core and the Raspberry Pi 3?
      
       I'm interested in creating a Food Recipe database with four tables.The part that I need help with is only with the creation of the database using the scripts generated by your tool.
      
      I will appreciate if you guys can share some links on how to do this using SQLite Toolbox inside Visual Studio 2015.(C#)
      
      Thanks
    • Can you use this: http://erikej.blogspot.dk/2014/10/database-first-with-sqlite-in-universal.html ?
    • Erik:
      
      I was able to create my tables with the link you provided. For one of the tables I created all the needed fields and inserted all the data including images. Now I find myself in a situation where I need to add another field to that table?
      
      Question: Will I loose all the data? Is there a way to add a field without loosing the data already entered?
      
      Thanks
    • You must recreate the table, a SQLite "feature" !
  • Crash on Windows 10
    2 Posts | Last post July 20, 2016
    • Hi, ErikEJ.
      When I moved to Windows 10 and tried to export SQL server database to SQLite I
      got error DataReader.GetFieldType(3) returned null on my table with sys.geography type column. This operation worked for me on Windows 8.1 earlier. Also this error is well known in net and related with versions of SQL Server and .NET types and has solution.
      Is there suggestions?
    • Hi, if this is a "well known" error, could you please create an issue on github with all details. I have never heard about this issue before.
1 - 10 of 117 Items