SQL Server Compact/SQLite Toolbox

Free

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

(82) Review
Visual Studio
2013, 2012, 2010, 14
Download (321,766)
9/5/2014
4.0.0.0
View
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Description
Reviews (82)
Q and A (56)
Sign in to write a review
Sort by:

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!

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.

by Ed (DareDevil57) | August 14 2014

Thank you.

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!!

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.

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.

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.

by VisualDragon | 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.

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

by gepetkov | July 14 2014

Wonderful!

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.

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!

by Jay Mc Bee | May 26 2014

Awesome toolset! We've used it to script our SQL CE database creation and restore, works like a breeze!!

by edikaufmann | May 13 2014

great tool. It made my SqlCe life much easier!
Just wonder: I'm using the 3.1.6 standalone version! How is this version
compared to the VS add-in 3.7.2.0 ?
How do I know which standalone version is current (newest!)
again thanks for all your effort
ed

by petevick | May 12 2014

Great tool - gets you out of the hole when MS abandoned SQL Server CE.
Not only that, the tools that Erik also provide really take the pain out SQL
Server CE development.

I have just been testing performance of large record sets, and using SqlCeCmd
I was able to export my SQL Server Database to a CE database with no problems.
Build a database, build a table, and then import 3 million rows from a SQL database.

Impressive software and just gets better.

Thanks!

ErikEJ May 12 2014
| Edit |
Delete

Thanks for the kind Words, Pete

by ChangedDaily | May 12 2014

Very useful toolbox, integration with Visual Studio is also good.
The toolbox does what I need - examine the structure of sdf files,
view and edit data. The scripting feature is also very useful.

by signitin | May 04 2014

The Best tool to integrate SQL Compact in Windows Phone, saves a lot of time and effort. Well maintained.
Thanks

by M_Over | April 28 2014

Thanks for all the hard work! This is very valuable. By the way, what are you plans now that Microsoft is no longer supporting SQL Server CE?

ErikEJ April 28 2014
| Edit |
Delete

Well, I still support it - I am also considering adding more support for SQLite

by leenetuse | April 27 2014

by Sebastian Grollmus | April 09 2014

Great Tool! We use it for every day - it's a great help working with SQL Server Compact Toolbox.

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


  • Removing 3.5 Connections
    4 Posts | Last post May 02, 2014
    • Love this tool but.. Running VS 2010 Win 7 64 bit. When I right click on a 3.5 database connection and select 'Remove Connection' nothing happens. 4.0 connections are properly removed when I do this. Is there a way to remove 3.5 connections from the tree?
      
      Thanks,
      PWE 
    • Suggest you post an issue here https://sqlcetoolbox.codeplex.com/WorkItem/Create and provide the text of or a screenshot of the Toolbox about dialog. Are you running the latest version?
    • Well whatever was done in 3.7.2 has fixed the issue (was on 3.6).
      Thanks,
      PWE
    • It was fixed in this release https://sqlcetoolbox.codeplex.com/releases/view/114453 
  • SQL Ce 4.0 in wp8
    6 Posts | Last post April 10, 2014
    • Hi
      I have a SQL CE 4.0 and it seems that the program doesn't support the SQL Ce 4.0 ( for windows phone 8 ).
      
      so the question is there any way for me to downgrade my database version ?
      or migrating my data's to a 3.5 ? or any other solution ?   
    • Use the Toolbox to: 1) Script the entire 4.0 file 2) Create a new 3.5 database file 3) Open and run the script from step 1 against the file created in step 2
    • Hi again 
      thanks for your response .
      
      Another Question : I created a Windowsphone datacontex using your App but when I wanna bind a part of my database  to a list box it won't work (for being more clear these are the details : i have three row of words(wordsA,wordsB,wordsC)and i wanna bind them to a listbox and I tried this for binding ... text={Binding wordsA} ... )(I searched everywhere for a guide or solution but ... Nothing)  
    • Javad: This is not a good forum for tech support, suggest you ask in the MSDN forum or use the CodePlex issue tracker
    • 1- Thanks for your recommendation .
      2- Report = The app doesn't support the win/wp8.1 SDK .(waiting 4 update ;-)
      Best Regards.
    • By the way I found the solution in one of your articles* So Thanks again (you are awesome !!! )
      *
      http://mobile.dzone.com/articles/windows-phone-8-local-database
  • SQL CE 4.0 and Windows Phone 8
    8 Posts | Last post February 08, 2014
    • Hello,
      i'm create a database SQL CE 4.0 and the menu "Add Windows phone datacontext" is disabled.
      why?
      Thanks
    • You need to use a 3.5 database with Windows Phone, and in addition this feature requires the SQL Compact 3.5 SP2 Desktop runtime to be installed.
    • Thank you for response. SQL Compact 4.0 is not compatibile with Windows phone 8?
    • No, SQL Server Compact 4.0 is not compatible with Windows Phone 8, the file format used on Phone most closely resembles 3.5, but see my blog for the gritty details.
    • ok thanks. I would like to use SQL CE and EF6 with your tools. Can I use the MVVM pattern
    • Yes, you can, but EF6 does not work on Windows Phone, only LINQ to SQL
    •  who can tell me how to add sql server compact in  vs 2013?
    • What do you mean by "add SQL Server Compact" ? Suggest you try the latest beta here: https://sqlcetoolbox.codeplex.com/releases/view/117615
  • Deprecated
    2 Posts | Last post January 26, 2014
    • I'm having a hard time making sense of all the conflicting information..
      I'm think of using SqlCE with EntityFramework on my next project, but it seems MS has deprecated SqlCe? Is this true?
    • I am still awaiting official statement, but it seems likely, yes. You can see the support lifecycle here http://support.microsoft.com/lifecycle/search/default.aspx?sort=PN&alpha=SQL+Server+Compact&Filter=FilterNO
  • Great tool
    2 Posts | Last post January 15, 2014
    • Works perfectly for VS 2013. Liked it. 
    • Thanks!
  • Does SQL Server Toolbox replace sqlmetal.exe?
    2 Posts | Last post January 12, 2014
    • Hi Erik,  
      
      I'm currently using SQL Server Toolbox in the following environment:
      
      Toolbox - Version 3.0.0.6
      VS 2010 SP1 / .Net 4.0 
      SQL Server Compact 3.5 SP2
      
      I am trying to modify an legacy database schema for a Windows Forms VB project which uses Linq to SQL.  The DBML file for the original database schema was developed from the database using sqlmetal.exe, with data associations added manually in the designer.
      
      Will SQL Server Toolbox automatically build the DBML file for my project or do I still need to use sqlmetal.exe?  Also, what about the table associations?
      
      Thanks.
    • You should probably upgrade to Toolbox 3.7... but the Toolbox does not generate dbml, it generates code - DataContext and Table classes. If you require a dbml file, you must use sqlmetal, which Works fine with SqlCe 3.5
  • VS2013 Solution with multiple SDF files
    4 Posts | Last post January 10, 2014
    • I installed the SQL Server Compact Toolbox and can view SDF files in VS2013, but only if I open them individually. 
      In the past (VS2010) I would just open my VS2010 Solution (has about 20 projects and 30 .sdf files) and then over in the Server Explorer / Toolbox window all the .sdf files would load up for me. 
      How can I have all the .sdf files of a project open in SQL Server Compact Toolbox automatically when I open the solution in VS2013 ?
      Thanks for feedback
      Phil
    • I have never seen that happen. The toolbox displays any connections defined in Server Explorer, but in VS 2013 Server Explorer does not support sqlce. Maybe a feature suggestion to Scan active solution for SQL CE files, and connect them all??
    • Thanks for the feedback. You are right, I think it was Server Explorer pulling in all the SDF's in VS2010 and then the toolkit just picked them up. But yeah, now that we are using VS2013 Server Explorer won't do that.
      So adding a feature to the toolkit that scans the active solution for SQL CE files and connects all of them would be great.
      
      Again, thanks for the quick response.
      Phil
    • Phil: Suggestion logged here: https://sqlcetoolbox.codeplex.com/workitem/11508 - feel free to Vote!
  • Access to the database file is not allowed
    2 Posts | Last post December 28, 2013
    • Created a .sdf in VS2013 using migration and update database.   when I try to open with Toolbox (installed  3.5 32&64 and 4.0 64) I'm told access to the file is not allowed 80040E09 minor Err 25039.  The database file is not in use.
    • Is the file located on a local drive? Is it in use by another app?
  • create table based on Select *
    2 Posts | Last post December 26, 2013
    • How can I create a new table based on a select like follows Case1 + 2?
      PS: the select works fine.
      Is this Create .... and INTO ... supported (yet)?
      I use Toolbox 4.0
      - what would you suggest?
      thanks for your time and help
      ed
      
      case 1:
      CREATE TABLE Common_BodyPartRecord1 AS
      select *  from Common_BodyPartRecord i
      where not exists(select ii.Id 
      			from Common_BodyPartRecord ii
      			where ii.ContentItemRecord_id=i.ContentItemRecord_id and
      				ii.Id >i.Id 
      		)  and text not like ''
      
      Case 2:
      select * INTO Common_BodyPartRecordNEW   from Common_BodyPartRecord i
      where not exists(select ii.Id 
      			from Common_BodyPartRecord ii
      			where ii.ContentItemRecord_id=i.ContentItemRecord_id and
      				ii.Id >i.Id 
      		)  and text not like ''
      
    • ooops ... found it following works .. of course 
      
      hope nobody spent time!
      ed
      
      Insert into Common_BodyPartRecord1
      select * from Common_BodyPartRecord i
      where not exists(select ii.Id 
      			from Common_BodyPartRecord ii
      			where ii.ContentItemRecord_id=i.ContentItemRecord_id and
      				ii.Id >i.Id 
      		)  and text not like ''
  • VS 2013 and SQL Compact 4.0 help
    4 Posts | Last post December 22, 2013
    • I installed the "SQL Server Compact Toolbox" and still when I add the Northwind SDF file to a new project I do not see the "Data Source Configuration Wizard" pop-up, plus when I manually try to add the SDF file as a new data connection the list of available data providers does not include "SQL Compact" anywhere.
      
      Meanwhile, in VS 2013 "Extensions and Updates" I see the SQL Server Compact Toolbox is installed.  
      
      What can I do to resolve?
    • The toolbox does not enable those features. DataSet is not recommended to use with Sql Ce, use Linq 2 sql or Entity Framewok instead
    • Thanks Erik, do I have to add the connection via code instead...can you point me to some examples online that are specific to what the toolbox does and what it helps with? I found the toolbox by googling VS 2013 and SQL Compact tutorials and it took me here (http://msdn.microsoft.com/en-us/library/aa983340(v=vs.110).aspx), but then when that wasn't working according to the documented steps I then found this site and your toolbox, thinking that was the missing link (no pun intended!)
      
      
      
    • Yes, or add the connection to the Toolbox, and then generate code. For features read the description here, or view the doementation on sqlcetoolbox.codeplex.com 
11 - 20 of 56 Items