SQL Server Compact Toolbox


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.

(64) Review
Visual Studio
2013, 2012, 2010
Download (277,012)
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Reviews (64)
Q and A (46)
Sign in to write a review
Sort by:

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 |

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


by Mojtaba.kaviani | January 10 2014

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

ErikEJ January 10 2014
| Edit |

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 |

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 :)

by Sócrates Lopes | August 19 2013

Simple and functional!

by Christian Resma Helle | August 14 2013

Awesome tool!

by Priscila Mayumi Sato | August 12 2013

by LarryDavidJr | August 02 2013

Saved me some time, worth getting.

by gmorris59 | July 27 2013

Simple, useful and powerful with good support from Erik

by SteveBowman | June 17 2013

This is a great tool and adds a load of features that are very handy when working with SQL CE databases. I would highly recommend this to anyone working with SQL Server CE.

by llwydsj | June 14 2013

Very useful tool. Great for someone who is not particularly experienced with SQL DB management / editing. Clean and familiar (VS2010 icons) browsing with a no frills SQL editor with auto-generated queries. The only thing I use the standard Server Explorer for now is Table creation.

by Henry Desouza | May 24 2013

Thanks a lot, it works great while importing CSV data.

You know what is the best thing about it??? It Works!!!!

by D. Chatterjee | May 20 2013

Very Good

by Adrian Faciu | April 29 2013

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

  • How to uninstall from VS 2013
    2 Posts | Last post December 04, 2013
    • Hello, I installed it and realized that i dont need it. Now, I want to uninstall but I dont find any way to do that. It is not showing up in Add/Remove programs. Please let me know how to uninstall. 
    • Sorry to hear you do not need it, may I ask why? To uninstall, go to Tools, Extensions in VS, locate it, and click the uninstall button.
  • In code: Need Project Name preceeding DataContextFileName?
    3 Posts | Last post December 01, 2013
    • Hi Erik,
      After creating a DataContext for Linq to SQL (sqlce 3.5, VS 2010, W7, toolbox, I find that I need to use the project name preceeding the datacontext name to instantiate the local datacontext like this:
      Dim DCLocal As New PSILibrary.PSLocalDataContext(SV.ConnectionStringLocal)
      ... where PSILibrary is a project that is subordinate to the main project in this solution.  The .sdf file and the PSLocalDataContext file are contained in the PSILibrary project.
      The first time I created the datacontext file I didn't need to do this.  But subsequent changes now require it.
      All seems to work well, but it doesn't seem correct to require that the project name has to preceed the PSLocalDataContext name.
      I did try 'Imports PSILibrary' but that made no difference.
      Is something wrong or is this correct?
    • Hi Dan, not being a VB Expert, but not sure why you are encountering this. Could you maybe share a bit more info at the Codeplex issue tracker here: http://sqlcetoolbox.codeplex.com ?
    • Hi Erik,
      Thanks for your reply.
      After a night's sleep I figured this out.  When the Toolbox creates the DataContext, a Namespace is automatically created for the entire DataContext - which is the same name as the Project!
      I removed that Namespace from the DataContext, and that solves the problem.
  • No 2008 support?
    6 Posts | Last post November 15, 2013
    • I was going to download, but it only offered to install into VS2010 and VS2013; I really need it only for VS2008.
    • Hi, there is standalone editions available here: http://sqletoolbox.codeplex.com - you can use those.
    • Thanks; for a minute there, I was afraid there was something rotten in Denmark.
    • That link becomes http://www.codeplex.com/site/pagenotfound
    • Typo - it is sqlcetoolbox.codeplex.com 
    • Eaux - should have noticed that.
  • Using Source Code
    2 Posts | Last post August 29, 2013
    • Please am quite new but how do I add and use the source code in a simple winform app am building cos I want to be able to script the SQLCE DB for backup and restore purposes...thanks
    • You can use my API as described here: http://erikej.blogspot.dk/2013/03/sql-server-compact-code-snippet-of-week.html
  • Using Source Code
    1 Posts | Last post August 29, 2013
    • Please am quite new but how do I add and use the source code in a simple winform app am building cos I want to be able to script the SQLCE DB for backup and restore purposes...thanks
  • Migration not Working
    2 Posts | Last post August 22, 2013
    • I have installed this tool and tried to export database to localdb/Express and i m receiving msg that "Database Exported" but when i check localDB, i m not getting single table over there and that localDB will be blank just like when you create new one. What should i do?
    • Please provide more info via the info tracke on sqlcetoolbox.codeplex.com
  • LINQ to SQL not working for SQL Compact V4.0
    2 Posts | Last post August 08, 2013
    • Hi,
      I have your toolbox and SQL Compact 4.0 Installed but when I try to "Create LINQ to SQL Data Classes" from the SQL Server Compact for runtime 4.0, I get this error box:
      "System.IO.FileNotFoundException: Could not load file or assembly 'System.Data.SqlServerCE, Version= ...
      ErikEJ.sqlCeScripting.SqlCe.Helper.CreateDatabase ...
      If I install SQL Compact 3.5 I can generate the classes but then when I use the Data Context it crashes since it is using a 4.0 database with LINQ classes for 3.5.  HELP !
    • You must initialize the DbContext class with a 4,0 SqlCeConnection object, a connection string wont work
  • Broken link?
    2 Posts | Last post June 09, 2013
    • Hi,
      Thanks for this tool, I already know it wil help me tramendously! Allthough... The download is not starting. Is there a broken link?
    • Nevermind, I had an install window open in the background. Strange that kept it from downloading :)
  • Converting Database
    2 Posts | Last post June 07, 2013
    • Hello,
      This tool is great, I love the Visual Studio add-in.
      Is there a way to programatically convert a v3.5 database into a v4, and back again? Windows Devices only support CE 3.5, but I can only use v4 to create the database.
    • Not directly, but you could use my API to script the 4.0 database file, create a 3.5 file and run the script against it. Not sure I understand why you cannot create the database with 3.5 ??
  • NotSupportedException
    2 Posts | Last post May 29, 2013
    • Hello ErikEJ,
      Your tool was cool, and was able to import my images to a table.
      Now I am in the need of reading these images and display it to a set of controls. Upto this point I am not sure how to convert the SQl.Data.Linq.Binary (which the DB gives me in the LINQ query) to a System.Windows.Controls.Media.Image type. But before that I need to get my DB connection successful.
      I have seen many of your tutorials and specially this one:
      and followed the steps in creating the datacontext class, for my DB.
      But just when I wanted to use this class, I was getting a NotSupportedException when I try to use the generated connection string. This is how I instantiate the generated datacontext class:
      EasyFoodMobDBContext dbcontext = new EasyFoodMobDBContext(EasyFoodMobDBContext.ConnectionString);
      and the static string variable "ConnectionString" in the generated datacontext looks like:
      public static string ConnectionString = "Data Source=isostore:/EasyFoodMobDB#1.sdf";
      and when run it throws an exception at the constructor 1st line:
      public EasyFoodMobDBContext(string connectionString) : base(connectionString)
      The excpetion details:
      NotSupportedException was unhandled. Data Source=\Applications\Data\D9B6B61C-7FDF-4354-8B72-1638291A52EF\Data\IsolatedStore\EasyFoodMobDB
      What could I be missing or doing wrong?
      Kind Regards,
    • Mafaz: This area is for discussing issues with the Toolbox, not Windows Phone Development. But I would try t get rid of the "#" sign in the file name first.
11 - 20 of 46 Items