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.

(117) Review
Visual Studio
2015, 2013, 2012, 2010
Download (400,062)
5/30/2015
4.2.0.0
View
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Description
Reviews (117)
Q and A (75)
Sign in to write a review
Sort by:

by engenious | June 18 2015

Thank you so much for that great toolbox.

by RandyTheBear | June 18 2015

This toolbox is great! When I got tasked with creating an embedded
database for a tablet app using SQL Compact, I had never done it before.
This toolbox and Erik's blog made it simple. I recommend it to everyone.
I have used it on several applications since then.

by port_al | June 03 2015

Great and professional tool!
Looks and works like native VS toolboxes.
That was like life saving when i found it because at the moment i was nervously thinking of what to do in order to develop and maintain SQLite database under Windows Runtime platform on Windows Phone 8.1.
Other tools i tried are not comparable. I might not try them that many but as soon as you find this one you don't want to be searching for a tool further.
Thank you very much!

by Can Altunöz | May 17 2015

Its very powerfull tool for SQLCE. Simple and easy to use. Tyvm for a great work

by Hammer510 | May 12 2015

You read my mind in regards to what SQLite in Visual Studio was missing. Thank you so much for your effort!

ErikEJ May 12 2015
| Edit |
Delete

Thanks,Hammer. Let me know if you miss anything or Things don't work as expected :-)

by Hfzusama | April 27 2015

It is extremely excellent tool for databases such as sqlite which is very difficult for me but with this tool I can easily create and use my sqlite database in my projects. I am very thankful to you for this tool

by RaymondChan95032 | April 23 2015

I have used the SqlCe35Toolbox.exe and SqlCeCmd.exe from Mr Jensen to analyze/dump Windows Mobile SDF database files. The tools are easier to use and very helpful. Mr Jensen is also very quick to respond to my questions and issues. Highly recommended !

by Vladimír Klaus | April 22 2015

I use this excelent tool several years. It helps me a lot - for example when Webmatrix had broken DB functionality.
Now I use it inside VS 2013 and it is still beter and better. Especially new function for connection renaming is fantastic since I have more the 15 databases with the same filename Data.sdf.

by Bill Drago | April 17 2015

This is an excellent tool for working with SQLite and Visual Studio. It's one of those things that you once you start using it, you don't know how you lived without it.

by AshRoller | April 16 2015

Very useful, thanks

by efhilton | April 13 2015

Beautifully written. Extremely useful. Thank you!

by Benoit P | April 09 2015

A great and necessary tool for VS2013 users, simple yet powerful. Thank you very much for all your work. Benoit

by SandroR | April 09 2015

This tool is an ESSENTIAL part of Visual Studio since Microsoft
removed from Sql management Studio the support of SqlCE.
Its value is unbelievable and we have only to thank Erik for his remarkable job.
Thank you!

by Matthias Dieter Wallnöfer | April 03 2015

by RandomlyKnighted2 | March 16 2015

This is a fantastic extension. This has helped me several times in the past with migrating databases and with the added ability to migrate SQLite databases I can now do so much more with it. This extension also has the added benefit of being created by the very dedicated ErikEJ who is willing to work with his users to figure out any problem they may be having and to extend the extensions functionality to its full potential.

ErikEJ March 31 2015
| Edit |
Delete

Thanks, and thanks for your help with SQLite => SQL Server export

by Tonazzi-M | March 10 2015

This is the best tool for working with SQLite and SQL Compact databases.
Very quick responses from the helpful developer, many thanks for you great work Erik!

ErikEJ March 10 2015
| Edit |
Delete

Thanks, and thanks for your debugging help!

by Jc1984 | March 07 2015

Hello to everyone, there is a way to change de result set as grid, I appreciate your help...

Thanks...

ErikEJ March 08 2015
| Edit |
Delete

Of course, just go into options and enable result set a grid!

by tmksoft | March 05 2015

Really nice tool.

I use it for editing the database in my Umbraco installations.

by oeduran88 | February 26 2015

Thank you very much for such useful tool. It helped me do some things I wasn't able in Webmatrix.

by Yatajga | February 20 2015

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


  • 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 6.0.0.0. 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.
      http://www.engenious.de/WpfApplication1.zip
      
      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. 
  • Table is not available [Job]
    4 Posts | Last post May 15, 2015
    • I try to develop an Windows Phone Silverlight 8.1 App with al local database. I designed a database with your tool and add the sdf file to the project. 
      The database has at the moment only the table Job. 
      
      I add Windows Phone Datacontext with your tool.
      In the Datacontext file is a Job Class.
      
      Then i created the database with CreateIfNotExists(). 
      But whe i read from the Job table i get the error "table is not avaiable" German "Die angegeben Tabelle ist nicht vorhanden. [Job]"
      
      Which step i have forgotten?
      
    • Hmm.. Without your code is is hard to guess! Suggest you share a repro on the CodePlex issue tracker. It could be your connectionstring, perhaps
    • Or the sdf file could be something else than "Content" and "Copy always" in your project
    • Hi Erik, thank you. I made a small demo project and this works. So i made two changes in my app, first i uninstall it from the mobile dev and i used a smaller name for the db. And this works also.
      
      The sdf file was in the project embeddedResc and copy always.
  • Diff data from 2 DB files (SQL CE)
    4 Posts | Last post April 30, 2015
    • I want to create SQL file with the changes between the two DBs. When run the Diff tool it seems to compare only the Schema.
      Is there a way to compare data in both databases and get Insert statements with the differences?
      Thank you.
    • Yes, you can do that on table level (Compare Data)
    • Yes I missed that option on the Table level. This was exactly what I was looking for. Thank you.
    • The feature is still in beta, let me know if it Works for you!
  • Stored Procedures
    2 Posts | Last post April 23, 2015
    • Hi, is it possible to create Stored Procedures? I'm using VS 2012.
      If possible, where can i find information about it?
      Thank you.
    • Neither SQL Compact not SQLite supports stored procedures, as they are both embedded databases - use code instead
  • Unable to load DLL 'sqlceme35.dll'
    2 Posts | Last post April 21, 2015
    • Error of loading sqlceme35.dll raises on toolbox start. VS2013 Ultimate crashes too.
    • Re-install/repair the SQL Server Compact 3.5 SP2 runtime
  • SQL CE 3.0 and 3.5 support?
    8 Posts | Last post April 13, 2015
    • Hi 
      I am receving 2 apps developed in  vs2005->sqlCE3.0 for WinCE and VS2008->sqlCE3.5 for WinMovile6.5 and I wondoer if, with this tool I can give support to those apps from my VS2013? or I must stand still in VS2005 and VS2008?
      I never use Windows CE or windows Movile 6.5,  but here in my job we have a lot of hardware that uses WinCE and WinMovile,... and they are not  going to throw away the HW, just because MS throw away WinCE and WinMovile.
      
      Thanks in advance
    • For Windows ce and Windows mobile dev, you must continue to use vs 2005 & 2008. The Toolbox is available in a standalone version that supports version 3,5. 
    • I have a similar problem, where the client's app is sqlCE3.5, though it is on a desktop not on mobile environment.  Is my only option to downgrade to VS200{5,8}?  We are not allowed to upgrade the client's sqlce db to 4.0.  
    • Efhilton: that problem is not "similar", with a 3.5 desktop app you can use VS 2013/2015 and the Toolbox!
    • Hmm...  then maybe I'm doing something very wrong or am missing something.  I'm unable to open my client's sdf file.  I'm able to open it as a SQL CE 4.0 data source (forcing me to upgrade my client's database, which is not acceptable).  If I try to open it as a SQL CE 3.5 data source ("Server Explorer" -> "Add Conenction"), I get "Unable to find the requested .Net data provider. It may not be installed.
      
      On the other hand, if I go to Tools -> "SQL Server Compact/Lite Toolbox" -> "Add Connection", the "Add SQL Server Compact 3.5 Connection" is grayed out.  
      
      Any thoughts?
    • Efhilton: you need to install it (the sqlce 3,5 runtime msi) as the error message clearly states! https://sqlcetoolbox.codeplex.com/wikipage?title=Known%20Issues&referringTitle=Documentation 
      
    • I must sheepishly admit I did not see this page before I submitted my question.  My apologies.  I can now safely say that that error is gone.  I'm now struggling with an error in the "ConnectionString" but at least I've advanced much more than I had before. Thank you!
    • If you encounter any issues with the Toolbox, pls report issues here: https://sqlcetoolbox.codeplex.com/workitem/list/basic 
  • Istallation on Vis Studio Express
    3 Posts | Last post April 09, 2015
    • Hi Erik,
      
      Just wondering why your product won't install on Visual Studio 2013 Express?
      
      Thanks
      
      David
    • It is a built in limitation in Express, I guess to force users to buy Pro. But you can use VS 2013 Comunity in many scenarios now, and that edotion supports all extensions.
    • Okay, thanks for that I am installing Community and I'll see how I go.
      
      Thanks
  • Execute Sqlite PRAGMA statements in SQL Editor
    2 Posts | Last post March 05, 2015
    • Is the Toolbox meant to execute PRAGMA Statements in SQL Editor?
      
      If I execute a PRAGMA Statement there is no exception but neither a result.
      
      E.g. pragma table_info(Test);
    • No, that is not supported currently, I have created an issue to fix this: https://sqlcetoolbox.codeplex.com/workitem/12033 (Plan to include in next preview of 4.2)
  • Add-In Crashes in VS2013 when starting SQLEditor
    2 Posts | Last post March 05, 2015
    • Hi Erik, you did a great job, many thanks! But since a while, when I open the SQL Editor in Visual Studio 2013 Visual Studio crashes. It happens with 4.2beta but also with 4.1. (It works in VS 2010).
      
      An unhandled exception of type 'System.NullReferenceException' occurred in SqlCeToolbox.dll
      
      Additional information: Object reference not set to an instance of an object.
    • Pls create an issue here:https://sqlcetoolbox.codeplex.com/WorkItem/Create and provide as much info/screnshots / VS version/update info as possible, then I will investigate
1 - 10 of 75 Items