SQL Server Compact Toolbox

Free

SQL Server Compact 3.5 and 4.0 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.

(74) Review
Visual Studio
2013, 2012, 2010
Download (300,931)
6/19/2014
3.7.3.0
View
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Description
Reviews (74)
Q and A (51)
Sign in to write a review
Sort by:

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.

by Javad alan | April 01 2014

A musthave for every programmer !! Thank u Erik. ;-)

by romagny | March 21 2014

Excellent ! Thanks

by Paul Rohorzka | March 13 2014

Feature rich and nicely integrated.

Besy feature: "Add SQL Server Compact connections from Solution" - very useful.

Thank you!

ErikEJ March 13 2014
| Edit |
Delete

Thanks, Paul, glad you like this new feature

by Cristian0 | February 28 2014

Must Have!

by VDohnal | February 11 2014

This tool is a must for SQL CE developer.

by ziic | January 13 2014

great!thanks

by Mojtaba.kaviani | January 10 2014

many features on this tools exist in ssce tools with better GUI

ErikEJ January 10 2014
| Edit |
Delete

What is "ssce tools"?

by Tom Childers, N5GE | September 27 2013

This Extension is a great tool, but appears to be broken in VS 2012 Pro.
The install goes just fine, but when clicking the icon in VS there is no action (Menu not displayed)

Tom C / N5GE

ErikEJ September 27 2013
| Edit |
Delete

Go to Tools/Extensions, and check if the extension is enabled (sometimes see that it is disabled)

by Daneshmandi1 | September 07 2013

A must have tool for SQL Compact related projects specially for Windows Phone projects.

The auto generate DataContext class feature of it is my favorite one :)

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


  • Visual Studio 14 - Won't install sql server compact toolbox
    2 Posts | Last post July 13, 2014
    • Any chance this will be updated for Visual Studio 2014?  Won't install on 2014.
    • Of course, it already is, but the VS Gallery web service is broken. Until it gets fixed, you can download a build for VS 14 from here: https://sqlcetoolbox.codeplex.com/releases/view/123666 - pls let me know if that Works for you!
  • DB created on Server 2012 won't work on Win7
    4 Posts | Last post May 26, 2014
    • Thanks for an awesome toolset! 
      We've automated the DB creation and script generation for our SQL CE database using the SQL Server Compact Toolbox and it works like a charm on the developer machines!
      
      However, when creating a DB from scratch on the build server running Windows Server 2012 the generated DB doesn't work on the desktop. 
      Even running SqlCeCmd40.exe to verify the DB on the build server (-e repairdelete) reports back that everything looks good ("Database successfully repaired") and still the DB doesn't work on the desktop Win7 machines so effectively we cannot automate the creation of the DB in the build process as of yet, which is a pity..
      
      Manually running SqlCeCmd40.exe on the Win7 machines against the DB created on the build server fixes the problem - though we can't really tell what is wrong with the DBs created on the build server.
      
      Any help much appreciated!!!
    • Suggest you contact me directly (email on my blog) or via the MSDN forum - I have some ideas, but need more detail from you, for example, what does "run sq
    • cecmd4.0.exe mean, and what do "not work" mean. And a forum or mail thread is a better forum for that discussion.
    • Many thanks, Erik! - As discussed via mail the problem appears to be related to the different platforms (build server vs. desktop) and using the database in read-only mode at runtime in our app preventing SQL CE to perform its internal db index updates:
      
      http://blogs.msdn.com/b/sqlservercompact/archive/2009/04/01/after-moving-the-database-from-one-platform-to-other-the-first-sqlceconnection-open-takes-more-time.aspx
  • Future of SQLServerCE
    2 Posts | Last post May 12, 2014
    • Hi,
      I have just posted a review of the toolbox and read a comment in another review about no further support for SQL Server CE, is that true? If it is does that mean I should be looking for another solution?
    • Thanks for the review - SQL CE 4.0 is supported at least until July 2016 http://support.microsoft.com/lifecycle/?LN=en-ie&x=15&y=6&c2=1044 
  • problems with generated datacontext
    2 Posts | Last post May 11, 2014
    • i used your standalone tool (thank you!) to create a linq to sql datacontext for windows phone. ok.
      
      then, i added the .cs file to a test project in visual studio express 2013 for windows update 2 rc. the project is windows phone 8.1 project.
      
      i get an error because several namespaces are missing. lines with errors.
      
      using System.Data;
      using System.Data.Linq;
      using System.Data.Linq.Mapping;
      using System.IO.IsolatedStorage;
      using Microsoft.Phone.Data.Linq.Mapping;
      using Microsoft.Phone.Data.Linq;
      
      i couldn't find anything about that except "Data" namespaces can't be used.
      is i a problem of the visual studio version?!
      
      thanks
    • No, there is a problem with the project type, you must use Windows Phone Silverlight project for SQLCE/LINQ to SQL support
  • where do I change the DB schema
    3 Posts | Last post May 07, 2014
    • I must miss something obvious!
      
      I'm using Sql Compact Toolbox 4.0 Standalone and CANNOT find where I would change e.g. the field length of an existing table.
      
      ... otherwise I can do everything!
      thanks for your help
      ed
      
      
    • You can only do that vai DROP/CREATE TABLE statement currently, or writing your own ALTER TABLE ALTER COLUMN statement. Next release of add-in and standalone will allow you to generate ALTER COLUMN statements as starting point.
    • when i deploy i found this message on wp8
      An attempt was made to load a program with an incorrect format
  • 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!
1 - 10 of 51 Items