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.

(114) Review
Visual Studio
2015, 2013, 2012, 2010
Download (390,855)
4/15/2015
4.2.0.0
View
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Description
Reviews (114)
Q and A (73)
Sign in to write a review
Sort by:

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

by Rick Strahl | January 28 2015

Microsoft has all but abandoned support for Sql Server Compact especially when it comes to the tooling, but this add-in makes up for that in spades. This tooling for SQL CE is miles above what Microsoft ever provided. I especially like the ability to import and export schema and data from a full SQL Server which is a huge time saver especially for testing components that support multiple providers.

Excellent.

by Hervé ANCHER | January 16 2015

From France, Very useful !

by SubramanyamRaju.B | January 09 2015

Thanks you so much.

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


  • DDEX provider still not working
    4 Posts | Last post February 07, 2015
    • Hi Erik,
      you did a great job with this plugin. I have SQL CE 4.0 db and using EF 5. I need to add a new entity to the model but when I run "Generate Database from model" I get the error DDEX provider not installed for SQL CE 4.0...
      I am using Visual Studio 2013.
      
      Thanks in advance
      Armando
    • Did you connect to the database file via the Toolbox? Does it appear in Server Explorer? Try to re-install the ddex provider in the about dialog, restart vs, and check status in about dialog.
    • Thanks Erik,
      it works fine now.
    • Dear Mr.ErikEJ
      thanks for your replay,
      after searching I find that the issue is that my SQLite database not having primary Key"Only FK"
      that is why the sql server will not accepting tho run the script.
      with best regard
  • Cannot choose Server Compact 3.5
    5 Posts | Last post February 07, 2015
    • I have a problem with creating a Server Compact 3.5 connection, which I need for a database for Windows Phone 8.1 . Is this a general problem, or is it me who is missing something ?
    • You are missing the 3.5 runtime, see this: http://sqlcetoolbox.codeplex.com/wikipage?title=Known%20Issues&referringTitle=Documentation
    • Thanks. Now I can make a 3.5 connection.. But it gives me an error when I try to "Add Windows Phone DataContext To Current Project". It says:
      
      - SQL Server Compact/SQLite Toolbox
      - The selected project type does not support Windows Phone 7.1/8.0 - wrong TargetFrameworkMoniker: .NETCore, Version=v4.5.1
      
      And it says this right after I click that button - I dont even get to enter the namespace, or anything.
    • You are crating a Windows Phone 8.1 project, and that project type does not support SQL CE, you must create a Windows Phone 68 Silverlight project for SQL CE support, or use SQLite
    • Dear Mr.ErikEJ
      thanks for your replay,
      after searching I find that the issue is that my SQLite database not having primary Key"Only FK"
      that is why the sql server will not accepting tho run the script.
      with best regard
       
  • Can I export the SQLite Schema to SQL Server
    3 Posts | Last post February 06, 2015
    • I can script as but the file generated is not working "due to FK" in Sql server
      
    • I have a database in Sqlite ...
      But I want to migrate to Sql server..
      I migrate the tables,data but I need to migrate the Key because I have 100 table.. So it is hard to reconnect and script again..
      
      regards 
    • Suggest you create an issue on the codeplex issue tracker, and attach the database and script, then I can have a look at it.
  • Basic Usage in windows phone 8.1 using vs2013
    2 Posts | Last post January 14, 2015
    • I was wondering how this works for windows phone 8.1? I need SQL application code to be called from a dll file in my windows phone 8.1 application. I have not used linq to sql before but have used SQLCE directly in a windows 7 application. How difficult would it be to extract data from it using linq? 
    • No entirely sure what you are asking, but yes: http://erikej.blogspot.dk/2013/04/generate-windows-phone-8-local-database.html (Must be SilverLight app) - WinRT (8.1) apps only support SQLite, not SQLCE
  • This extension is not installable on any currently installed products.
    2 Posts | Last post January 11, 2015
    • Downloaded the SqlCeToolbox.vsix which is marked with a Type of Microsoft Visual Studio Extension in Windows Explorer. When I doubleclick the file I get an error, shown above in the title, from the VSIX installer. Tried to search for the Add-In using the Extensions and Updates manager (Online) in Visual Studio but I was unable to find it.
      
      I'm wondering if it's because I'm using Microsoft Visual Studio Express 2013 for Windows Desktop. Any thoughts?
      
      Thank you!
    • You are right, VS Express does not allow any extensions to be installed. But the good news are, that a full featured free edition is now available, VS 2013 Community Edition http://www.visualstudio.com/products/visual-studio-community-vs 
  • Saving script
    7 Posts | Last post November 30, 2014
    • It is already version 4, and when I want to save changes in my script, the Toolbox still opens Save File dialog, where I point to the same file and confirm overwriting. Very annoying...
    • Yes, I know this already - one 1 vote though https://sqlcetoolbox.codeplex.com/workitem/10521 - do you feel like contributing a fix?
    • Shouldn't it be the "obvious thing" from the start?
      - "Hey, you don't have a "Open Project" menu item in File menu!"
      - "Oh, guys, never mind! It will appear after 10 years, and for now you have to do all your work without saving!"
    • As you can see from the single vote for this, and from the feedback I have heard, not many users consider it an issue, but please vote and feel free to contribute to this free Tool. I think many users simply use the editor as a "scratch pad", then include  queries in their source code.
    • If you see this editor as "scratch pad", then why would I use it? I'd then us Notepad or VS Editor. But because editor is connected to the database in context and operates with the database in context, then I expect it to behave as SQL Server Management Studio - edit and save, but not as edit, save as, overwrite over and over again. I like your tool but this "behavior" just irritates me. Well, I guess it ain't that hard to realize that? I'd appreciate it. Thanks.
    • I will consider it for a future release, feel free to contribute a fix.
    • Initial implementation available for preview here: https://sqlcetoolbox.codeplex.com/releases/view/151574 - pls provide feedback
  • Getting started with Sql Server Compact 4.0 in VS 2013
    2 Posts | Last post November 03, 2014
    • Is there a step by step tutorial for getting all of the pieces in place to create a complete Sql Server Compact4.0 database in VS 2013? I have installed your toolbox in my VS 2013 Professional and copied the MyDB.sdf file from the toolbox to the Solution Explorer but the table I created with the toolbox is not recognized by Solution Explored or any thing else. 
      
      I have successfully created a nice contacts DB with SqlCe 4.0 using VS 2012 so I understand that process but of course using VS 2013 is different I think. Is it necessary to use scripts to get the table created and moved to the Solution Explorer? If so how is this done?
      
      I apologize for my inexperience but I hope you can help me. Thanks in advance.
    • Hi, no changes in VS 2013 expect less support built in for 4.0 in Server Explorer. But have you looked in the bin/debug folder for at copy of your database with data/tables in it?
  • Duplicate Records
    4 Posts | Last post September 29, 2014
    • Hi, I'm using LinQ to SQL, I have this simple BD:
      Tables
      Facturas
      Depositos
      Pagos
      
      Relations are like this:
      Depositos One to Many Pagos
      Facturas One to Many Pagos
      
      This is for Initialize DataContext
      <code>
      Private Function dbConnection() As SqlServerCe.SqlCeConnection
              Dim Path As String = Application.StartupPath
              Dim ConnStr As String = "Data Source=" + IO.Path.Combine(Path, "FacturasDB.sdf") + ";Max Database Size=4091;"
      
              Dim conn As New SqlServerCe.SqlCeConnection(ConnStr)
      
              Return conn
      End Function
      
      Private Function InicializaDataContext() As FacturasDBContext
      	Return New FacturasDBContext(dbConnection)
      End Function
      </code>
      
      This is the "Insert Deposito" function
      <code>
      Public Function DepositoGuarda(ByVal _d As Deposito, ByVal _PagosList As List(Of Pago)) As Boolean
      	db = InicializaDataContext()
      	Dim _result As Boolean = False
      
      	db.Depositos.InsertOnSubmit(_d)
      	db.SubmitChanges()
      	
      	PagosGuarda(_d.IdDeposito, _PagosList)
      
      	Return  _result
      End Function
      </code>
      
      And this for Insert Pagos
      <code>
      Private Sub PagosGuarda(ByVal _IdDepo As Integer, ByVal _PagosList As List(Of Pago))
              Try
                  Dim _currDep As Deposito = db.Depositos.FirstOrDefault(Function(x) x.IdDeposito.Equals(_IdDepo))
                  For Each p As Pago In _PagosList
                      p.Deposito = _currDep
                  Next
      
                  db.Pagos.InsertAllOnSubmit(_PagosList)
                  db.SubmitChanges()
      
              Catch ex As Exception
                  MsgBox(ex.Message)
              End Try
      End Sub
      </code>
      
      And Every time I Insert a deposito with it's Pagos, it inserts as many Facturas as Pagos, I don't know why, there is no code for insert Facturas, any help?
    • Oops! This is the Inser Deposito Function, I missed the _result = True
      
      Public Function DepositoGuarda(ByVal _d As Deposito, ByVal _PagosList As List(Of Pago)) As Boolean
      
      	Try
              db = InicializaDataContext()
      
      	Dim _result As Boolean = False
      
      
      
      	db.Depositos.InsertOnSubmit(_d)
      
      	db.SubmitChanges()
      
      	
      
      	PagosGuarda(_d.IdDeposito, _PagosList)
              _result = True
      
              Catch (ex as Exception)
                  Msgbox(ex.Message)
              End Try
      
      	Return  _result
      End Function
      
    • Hi, this format is not good for code based issues, that do not really relate to the Toolbox. Suggest you ask in the msdn forum instead
    • Ok, I'll ask in the msdn forum but I think it's a bug because I have to do this in "Old Style" using ADO Net, with SqlCeConnection, SqlCeCommand, etc, and doesn't presented this issue.
  • Large text display
    2 Posts | Last post September 29, 2014
    • Hello, I'm using VS 2013 and latest version of this extension. Have a problem with some of my tables. One of them contains NTEXT column with aprox 30kb of raw data in xml format. When I click 'Edit top 200 rows', addon hangs/works too slow, and I forced to kill devenv process to continue. This happens if table contains only few rows, so I'm confused. Any suggestions?
    • No sure there is a fix, bu suggest you report an issue https://sqlcetoolbox.codeplex.com/WorkItem/Create and attach a database file the has this issue
  • Linq2Sql and Sql Server Compact 4.0
    7 Posts | Last post August 21, 2014
    • Hi,
      
      I've just intalled the last update of your plugin to my VS2012 ultimate edition and tried to create a datacontext for my .sdf file (Sql Server Compact 4.0) using your toolbox, but the menu item is greyed out saying "needs 3.5"
      What am I missing?
      
      Thanks
      
      Fulvio
    • You must install the SQL Server Compact 3.5 SP2 runtime: https://sqlcetoolbox.codeplex.com/documentation and construct the DataContext object as described here: http://erikej.blogspot.dk/2013/10/sql-server-compact-4-desktop-app-with.html
    • When i try to install i receive this:
       
      "WARNING - On a 64-bit Comuter, install both 32-bit and 64-bit versions of the SQL Server Compact 3.5 SP2 MSI files. Existing SQL Server Compact 3.5 applications will fail if only the 32-bit version is installed on the 64-bit computer. Developers should chain both the 32-bit and the 64-bit MSI files with their applications and install both of them on the 64-bit computer. See install.txt file for more information. Click "Yes" to continue."
      
      Anyway Sql server compact 4.0 sp1 runtime is already installed on my system. Do I have to install SQL Server Compact 3.5 SP2 runtime as well? Why?
      
      Thanks
      
    • Yes, it is required in order to generate the LINQ to SQL code for you...
    • I succesfully succeeded in creating the proxy class by your tool.
      Now when I try to invoke  dc.SubmitChanges() where dc is my DataContext an Exception raises up saying that the DataBase Version is not the expected one. 
      
      "Incompatible Database Version. If this was a compatible file, run repair. For other cases refer to documentation. [ Db version = 4000000,Requested version = 3505053, filename=..."
      
      What's wrong?
      
      Thanks
      
      Fulvio
      
    • Read my blog post! http://erikej.blogspot.dk/2013/10/sql-server-compact-4-desktop-app-with.html (you MUST initialize the datacontext with a SqlCeConnection, not a connectionstring!)
    • Ok.. I Will thanks!
11 - 20 of 73 Items