SQL Server Compact/SQLite Toolbox

VSIP Partner Free

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.

(136) Review
Visual Studio
2015, 2013, 2012, 2010
Download (450,566)
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Reviews (136)
Q and A (92)
Sign in to write a review
Sort by:

by ClevelandClete | Wed 3:23 PM

Having to Check the "Results to Grid" EVERY TIME I run a query is quite distracting.

ErikEJ Fri 2:23 PM
| Edit |

You dont have to, just use Tools/Options to set the default value for all new windows

by jecs.pt | Tue 2:48 PM

Outstanding tool!!

Thank you.

by cemremengu | Mon 1:33 PM

Great, great work thanks so much.

by Sapan Ghafuri | November 05 2015

I just come here to tell you thanks. Your tool helped us too much.

by pehu71 | November 04 2015

Very nice update!

by bobthecoder1 | November 03 2015

You can't scroll with mouse wheel when the mouse is positioned over table names. However scroll works when ur mouse is positioned near the scrollbar! Otherwise pretty nifty little tool.

ErikEJ November 04 2015
| Edit |

Hi, thanks for your feedback. could you post an issue here: https://sqlcetoolbox.codeplex.com/WorkItem/Create with a screenshot, thenI will look into it

by Ruud Borst | November 03 2015


by ryan.gillies | October 20 2015

Considering SQLCE is a product of Microsoft, its increasingly frustrating how they continue to remove support for this format bit by bit.

Thankfully ErikEJ's set of tools do just about everything - all of his tools are must have for anyone working with SQLCE databases.

by The Doron Team | October 13 2015


by Codinator12 | October 07 2015

Crazy good. Should be part of VS.

by Eumar Assis - Microsoft | October 05 2015


by lorax11 | September 30 2015

Can't live without it. Essential part of my workflow!

by JohnyL | September 25 2015

Invaluable tool for SQL Server Compact databases. The editor has now more capabilities which is important. Welcome fix for Save button which now does not open Save File dialog! SQL Server Compact Toolbox is just "must have"! Thanks, Erik! :)

by Rouf0007 | September 25 2015

Very good tool and ErikEJ is very helpfull. Many tanks

by sinfon | August 21 2015

Easy to use, lots of features, excellent for debugging. I can't imagine using SQL Server Compact without this tool. Awesome!

by FoosFam | August 16 2015

I am just getting started in the world of SQL CE development (long story) but it's nice to see great tools like this exist and have the backing of a great technologist like the author. I actually reached out to him about some Windows Mobile questions and he was happy to answer those. Reminds me of the days when the internet was great, the PreMIFT days. (that's Pre-MyspaceInstagramFaceBookTwitter)

But I digress - an absolute must have for any jumping into SQL server compact and SQLite. Thanks for the support and the tools.

by Thronic | August 01 2015

Excellent tool for managing SDF / Compact database files. I loaded an older VS2010 project in the newest VS2015 Community edition without any hassles and have even greater and easier control now than I had before. This will be bookmarked with me for a long time. CE is still an excellent option for standalone and portable applications.

by Base64 | July 23 2015

Great tools for working with SQL Server compact, much better than the Visual Studio built-in functionality.

by machal85 | July 21 2015

The best and the simplest!

by engenious | June 18 2015

Thank you so much for that great toolbox.

1 - 20 of 136 Items   
Sign in to start a discussion

    2 Posts | Last post September 08, 2015
    • How can I create a foreign key using 2 columns and refering to a 2 columns primary key ?
      I use sqlce 4 and visual studio community 2015
    • You can do that using SQL script currently, support for it in the UI is pending, planned for NeXT release: https://sqlcetoolbox.codeplex.com/workitem/11501 
  • How to expand tables of a database
    3 Posts | Last post September 06, 2015
    • Hi, I installed the tool, but cannot expand the database to see the tables, etc.
      I'm using VS 2015 Community and created a database in toolbox and after created tables with code first. The database is there, but I cannot expand it and see the tables of the database.
    • I am guessing you are looking at the wrong database file. Suggest you post an issue on CodePlex with reproduction steps
    • You were right! I've created the DB through the toolbox and when the solution was built it created other DB in Debug folder, but until now I didn't know that. Now I pointed the toolbox to the correct .sdf file and all is OK.
      Thanks very much for your hint!!!
  • Unable to add datasource
    6 Posts | Last post August 22, 2015
    • Hello,
      I tried creating a project to test your tool. First, when I display the about box, I notice a bunch of 'no' (see http://i58.tinypic.com/2dv5p4k.jpg). I've already pressed 'Register DDEX Providers' button. Second, when I try to add a new datasource in my project to access a sqlite db file, your tool doesn't show up in the 'Choose provider' window. How to fix that ?
    • My tool does not provide features for adding a sqlite dataSource, you must install the SQLIte VS tools, as described here: http://erikej.blogspot.dk/2014/11/using-sqlite-with-entity-framework-6.html 
    • OK. I've downloaded and installed the file mentioned but I get an error ('An unexpected error occured in the .NET Framework data provider...'), although the connection test succeeded.
    • Hello again,
      trying to get rid of my problem, I get an error, this time from YOUR tool: I chose Script Database from the menu and then Script Database schema. See http://i59.tinypic.com/2lsxgxs.jpg for the error. The db is a valid one though, it's been created by a video game and can be opened with any sqlite browser tool...
    • Please try to uninstall and reinstall so you have the latest refresh, version 4,3,0,2. Please let me know if that fixes the issue for you.
    • No error with the latest version! Thank you! ;)
  • How to upgrade?
    6 Posts | Last post August 02, 2015
    • Hi, I was using C# 2010 with SQL Compact on an old laptop and recently bought a new laptop with WIndows 8 and installed Visual Studio 2015. The database program I developed on the old laptop doesn't run under VS 2015 since I don't have SQL Compact on it. 
      Is there some easy to find and understand how to get SQL CE on 2015? I seem to be in a tailspin trying to figure it out.
      Also, this toolbox is a VS extension and can someone point me in the right direction to install this?
      Thanks   Ron R
    • To get SQL CE Installed, just install the required runtime as described here: https://sqlcetoolbox.codeplex.com/wikipage?title=Known%20Issues&referringTitle=Documentation - and then install VS 2015 Community (not Express), and then you can simply install the Toolbox from the "Tools, Extensions and Updates" menu
    • Thanks Erik, Seems I have everything downloaded by VS 2015 Community does seem to know about SQL Compact. Do I need to add it somewhere?
      Ron R
    • Did you install the runtime and addin? And what does "not know" mean?
    • Got it thanks for your help Erik. I was missing the runtime.
      Ron R
    • You are welcome, Ron. If you like my tools, I would be grateful for a review here :-)
  • SqlMetal missing
    8 Posts | Last post July 30, 2015
    • Hello, 
      Anytime I want to add a LINQ to SQL for my SQL compact 3.5, I get this error message:
      SQL Server Compact - Couldn't find SqlMetal in the expected location: bin\NETFX 4.0 Tools\sqlmetal.exe; 
      Can you help me? 
      Thank you in advance 
    • Which OS version, and which VS version? And where is sqlmetal.exe located on your machine (if at all)?
    • Thank you for answering, 
      OS: Windows 8.1 Pro 
      VS version: Visual Studio 2015 Community
      Sqlmetal location: 
    • That is not the location of sqlmetal.exe, but sqlmetal.exe.log
    • Hello, 
      I have found the location but SqlMetal.exe wasn't there at all:
      C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\NETFX 4.0 (The tool points to that file path location.) 
      1 - I uninstalled the extension and reinstalled it thinking that all the default files will be added; but no luck.
      However I found other versions where the SqlMetal.exe already exists
      C:\Program Files (x86)\Microsoft SDKs\Windows\v8.1A\bin\NETFX 4.5.1 Tools
      C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.6 Tools
      2 - How can I change the path so SQL Server Compact/SQLite Toolbox will point to one of the versions where the SqlMetal.exe already exists ? 
      Thank you 
    • I have improved the sqlmetal.exe detection, could you remove, download and reinstall this newer build, and let me know if it Works for you https://sqlcetoolbox.codeplex.com/releases/view/612989 
    • Hello, 
      Thank you very much, it works perfectly. And by the way thank you for the tool it is very useful. 
      Ailiam A.   
    • You are welcome, feel free to post a review of the Toolbox here...
  • How to insert from CSV file?
    3 Posts | Last post July 24, 2015
    • Hello,
      Apologies if this has been answered elsewhere, but I wasn't able to find out after doing some web searching. I'm trying to insert into a .sdf database from an external CSV file. When I try the BULK INSERT command, it appears to not be supported. 
      SQL Server Compact gives me:
       Error Code: 80040E14
       Message   : There was an error parsing the query. [ Token line number = 1,Token line offset = 1,Token in error = BULK ]
       Minor Err.: 25501
       Source    : SQL Server Compact ADO.NET Data Provider
       Num. Par. : 1
       Num. Par. : 1
       Err. Par. : BULK
      What's the recommended way to do a bulk insert? I'm runnign version 4.3.0 on VS2015 Thanks!
    • Right click a table and select Import from CSV
    • Thanks EricJ!
  • DataSet (XDS) Visual Design with Sql Server Compact 3.5/4.0
    2 Posts | Last post July 21, 2015
    • Can i use DataSet (XDS) Visual Design with Sql Server Compact 3.5 with this tools on Visual studio 2013?
    • Nope, the DDEX provider is not fully featured enough for that. But using DataSet with SQL Server Compact is generally a bad idea
  • VS 2013 Community Database installation
    2 Posts | Last post July 15, 2015
    • Installed SQL Server Compact/SQLite Toolbox but in my version of VS, the option SQL Server Compact/SQLite Toolbox in the menu Tools shows that SQLCE 4.0 & 3.5 is missing. My question is why? In menu Tools\Extension and Updates it shows that version 4.2 is installed. 
      Some more information in order to understand my problem is when I right click "Data Connections" it is not possible to add SQL Compact 3.5.... as well as 4.0 option. Only possibility is to Add SQLite Connection... 
      Many thanks in advance for your reply.
    • You must install the SQL Server Compact runtimes on your nmachine, as described here: https://sqlcetoolbox.codeplex.com/wikipage?title=Known%20Issues&referringTitle=Documentation 
  • Entity Framework 6 and model first with sql server compact database
    11 Posts | Last post June 21, 2015
    • I have a project with an entity framework model first pattern. I will generate a database from this model, but first it must be a sql server compact (sdf) database. For that I installed the sql server compact/sqlite toolbox. The dialog to choose the datasource appears, but if I press next, than the dialog will be closed and I don't know why. I think before updating to EF 6 it worked with EF 5. Does anybody have a solution? Thanks Andreas
    • I'm using visual studio 2013.
    • Make sure to install the latest EF 6.1.3 Visual Studio Tools
    • Yes I installed 6.1.3. But the version of the reference is Is this correct?
    • Can I send you my model edmx file to check if it is corrupt?
    • Yes, but it is not the NuGet version that matters, it is the vs tools!
    • What do you mean? To which email can I send you the edmx file?
    • Hi Erik. Sorry but I need a solution for that. I'm hanging with my project. Here is the link to a demo sample.
      In this small sample I have the effect I described. Just open the edmx file and try to generate the database from model based on an existing sdf file.
    • Hi, I am always happy to assist for free, but if you need urgent support, pleaase contact MS support, they have a number of paid options
    • As I said in my first reply to you: Make sure to install the latest EF 6.1.3 Visual Studio Tools! That Works fine on my PC https://www.microsoft.com/en-us/download/details.aspx?id=40762 
    • Thanks I will try this.
  • issue with UniqueIdentifier
    6 Posts | Last post June 04, 2015
    • Hello
      I've got a table (using compact 4.0 connection) with 2 columns (id and name)
      Id is a uniqueidentifier and name is nvarchar(25)
      the Id column is not filling in automatically though as I believe it should be and result in me getting an error when i try to enter new rows.
    • Suggest you post a question to the CodePlex issue tracker, with a screenshot and your create table statement - SQL CE does not autocreate GUIDs...
    • Thanks for reply ErikEj
      To be honest i'm not a big fan of signing up for various site for 1 app. which is why i posted here since this is where I got the extension at.
      As for my guid problem. I've been using CE tables in the past that did autofil Guid's. In fact I can connect to a previous existing CE database that was created using VS2012 and then add rows to it with your extension with no problem and it auto fills not problem. But if I Create any new tables (which are successful) and then go to add new rows that is when the autofill doesn't happen. Also, I am now using 2013 community.
    • You can just use the same Windows Live account on CodePlex that you use here to post these comments. And I cannot help you unless you provide more info as requested
    • urg.... I hit the other site once I find it again. but honestly trully agittated by it..
      What more information will you need. You were asking the create table script, but as I said in the previous post, creating the table is not the issue.
    • Just tried to sign into the codeplex site and even with my live account i still have to provide the same sign in info just as if i was hitting a new site. 
11 - 20 of 92 Items