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.

(143) Review
Visual Studio
2015, 2013, 2012, 2010
Download (477,683)
2/2/2016
4.5.0.0
View
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Description
Reviews (143)
Q and A (95)
Sign in to write a review
Sort by:

by Rudolf Heijink | Sat 1:32 PM

Just found this. Thank you very much for sharing, I wish I had found it before!

Rudolf

by ajphall | January 25 2016

This is excellent. Thank you for all of your efforts Erik.

by Marcio Maciel | January 17 2016

This is amazing! Tks ErikEJ! 5 stars easy! =D

by James Green | January 06 2016

Really helped me out, saved a bunch of effort using this plugin.

by Ghalib Masood | December 26 2015

An amazing tool that made developing local database for my windows phone 8.0 project a lot easier. Currently, using it for all of my WP projects. Outstanding Tool.

by David L3 | December 14 2015

A brilliant tool! I use compact databases a lot both in desktop and web applications and I find this toolbox totally indispensable.

by SkyHigh42 | December 12 2015

Great tool, great support.

by ClevelandClete | November 25 2015

Having to Check the "Results to Grid" EVERY TIME I run a query is quite distracting.

ErikEJ November 27 2015
| Edit |
Delete

You dont have to, just use Tools/Options to set the default value for all new windows

by jecs.pt | November 24 2015

Outstanding tool!!

Thank you.

by cemremengu | November 23 2015

Great, great work thanks so much.

by Sapan Ghafuri | November 05 2015

I just come here to tell you thanks. Your tool helped us too much.

by pehu71 | November 04 2015

Very nice update!

by bobthecoder1 | November 03 2015

You can't scroll with mouse wheel when the mouse is positioned over table names. However scroll works when ur mouse is positioned near the scrollbar! Otherwise pretty nifty little tool.

ErikEJ November 04 2015
| Edit |
Delete

Hi, thanks for your feedback. could you post an issue here: https://sqlcetoolbox.codeplex.com/WorkItem/Create with a screenshot, thenI will look into it

by Ruud Borst | November 03 2015

.

by ryan.gillies | October 20 2015

Considering SQLCE is a product of Microsoft, its increasingly frustrating how they continue to remove support for this format bit by bit.

Thankfully ErikEJ's set of tools do just about everything - all of his tools are must have for anyone working with SQLCE databases.

by The Doron Team | October 13 2015

Awesome!!!

by Codinator12 | October 07 2015

Crazy good. Should be part of VS.

by Eumar Assis - Microsoft | October 05 2015

Awesome!!!

by lorax11 | September 30 2015

Can't live without it. Essential part of my workflow!

by JohnyL | September 25 2015

Invaluable tool for SQL Server Compact databases. The editor has now more capabilities which is important. Welcome fix for Save button which now does not open Save File dialog! SQL Server Compact Toolbox is just "must have"! Thanks, Erik! :)

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


  • Data Source VS2015
    2 Posts | Last post Tue 7:12 AM
    • ErikEJ,
      after making the connection , I'll create the data source , and give an error that is not supported, it can be. It is to do a tutorial on how to connect and preecher data grid .
      
      thank you for tool
    • The Data Source support in my DDEX provider is limited to saving connections on server explorer for use with the EF Tools. Not for creating DataSets, which I do not recommend for using with SQL CE anyway. If you want a quick data access layer, just use the LINQ to SQL code generation  
  • Unable to load DLL 'sqlceme35.dll'
    6 Posts | Last post February 03, 2016
    • Error of loading sqlceme35.dll raises on toolbox start. VS2013 Ultimate crashes too.
    • Re-install/repair the SQL Server Compact 3.5 SP2 runtime
    • Same problem. Crash Visual Studio. I dont need SQL Server Compact, only SQLite. Does it mean SQLite is not really supported?
    • Yes, you can use only sqlite, but your sql ce install is broken. Repair/uninstall. Did you try the latest daily? I made some fixes for this...
    • I had repaired SQL Server CE 4.0 SP1 and still face the same error. I am using vs 2015 community edition.
    • Kalpesh: repair/reinstall 3,5 sp2, not 4,0
  • Can I use SQL statements with SQL Server Compact/SQLite Toolbox add-in?
    2 Posts | Last post January 22, 2016
    • Can SQL Server Compact/SQLite Toolbox add-in help me use SQL statements to do operations on SQLite on UWP/Windows 10 environment (desktop, mobile etc.)?
      
      I am not able to find that detail in the description of the package...
    • You can run SQL statements against a SQLite database on your desktop, not against a database on a Phone or Tablet directly
  • Script out Database from LocalDB build in VS 2015
    2 Posts | Last post January 13, 2016
    • Hi Erik,
      I have used your plug in in Visual Studio  2015 Community and it works fine. I have manged to script out LocalDB Schema and Data and created .sql file. Only DB tables were scripted out. How to script out Stored Procedures from the same LocalDB. All this will be uploaded to the SqlServer 2012 Developer.Thank you for your time. 
      
      Cheers!
      
    • Thanks! For SQL Server to SQL Server scripting, use the tools built into SQL Server Management Studio.
  • Local Database
    2 Posts | Last post November 16, 2015
    • Is this the download that lets you adds data bases in Visual studio 2015? Someone told me to install a local database and create since the 2015 version doesn't have it. 
    • It depends what you mean by "local database" - why not give it a try?
  • API
    12 Posts | Last post November 12, 2015
    • Great job! Thanks for this tool. It is just amazing. Quick question. Is there an API (DLL) so that the Script generation of SQL Server Database Schema and Data to SQLite can be called inside a C# code? 
      
    • Hi Erik,
      
      Please help me. Is it possible to generate by code the Import data script inside a C# project? Thanks for you quick reply.
    • Hi Erik,
      
      FYI, I see many objects class. Which one should I use to generate the script for importing data from MS SQL Server to SQLite?
    • Glad you like it, feel free to post a review here! You can use my API, yes: http://erikej.blogspot.dk/2013/03/sql-server-compact-code-snippet-of-week.html (Just replace DB4Repository with ServerRepository)
    • Hi Erik,
      
      Thank you very much. I got the DLLs. Probably the last question :-) What is the method I can use to specify the tables for which the generator will output the scripts? Thanks again!
    • You can use the generator.ExcludeTables method
    • Awesome! Thanks Erik!
    • Hi Erik,
      
      I have another issue when calling the assembly:
      
      using ErikEJ.SqlCeScripting.
      
      The error meaasage is the following:
      
      The type or namespace name 'ErikEJ' could not be found (are you missing a using directive or an assembly reference?).
      
      Any idea about what's missing? Thanks in advance for your reply knowing your busy schedule.
    • I am happy to help, but could we please take this discussion here: http://exportsqlce.codeplex.com/workitem/list/basic and pls provide details about the sql ce version used and the project type etc.
    • FYI, I referenced the DDLs.
    • As I said, pls log an issue, and provide exact and clear information
    • Sorry about that. Alright. I am doing that right now. Thanks!
  • Instalation Issue VS2015 Community
    6 Posts | Last post November 12, 2015
    • Hi Erik,
      
      Is this Toolbox compatible with VS2015 Community?
      I tried to install it with VS2013 Express and get informed that it´s not compatible with that version. So, i installed VS2015 Community and tried to install the toolbox, but nothing happens, no errors, no messages...
      
      Thanks
    • Of course it is, I currently use VS 2015 Community to develop it! How did you install? Is it not installed already? Check the Extensions and Updates dialog
    • I have just downloaded and executed the file to do the install.
      Now, with your suggestion, i checked the Extensions and Updates dialog, added the extension and it´s working fine.
      Thanks a lot!
    • how did you add the extension?  I don't see anything, only form for servers
    • i tried to add folder with extension to this list. now i get message that access  to the path is denied
    • Amalgamsky: I do not understand your issues, pls log an issue here with clear description and screenshots, thanks: https://sqlcetoolbox.codeplex.com/workitem/list/basic 
  • Scroll problem!
    14 Posts | Last post November 11, 2015
    • Hi
      When I have many tables, The toolbox will show vertical scroll bar, but I can't scroll with middle mouse button!
      Please, check and fix it...
      Thanks
    • Hi, could you try the latest build here, and let me knwo if that fixes the issue: https://sqlcetoolbox.codeplex.com/releases/view/618303 (Uninstall first, then download and run)
    • Hi again,
      Yes! that's OK, I've installed version 4.4.0.5
      Thanks a lot...
      I have a suggestion too! May you create a standalone (portable) version of this toolbox, please? Some times we need it without visual studio...
      Thanks
    • Great, and thanks for reporting. Standalone version are already available: https://sqlcetoolbox.codeplex.com/releases/view/104096 
    • Thank you...
      May you update this standalone to the latest version, please?
      This is not 4.4.0.5 ! So, we have scroll problem and there is no design edit tools like VS-version (such as Add column, Edit column, ...)
      Thank you very much
    • Since VS Community is now free for all, I have decided to spend my (limited) resources with the VS extension. But the software is open source, and I do accept pull requests!
    • OK! Thanks...
      And sorry, but I found another bug!
      When we open an edit window for a table (Edit Top 200 Rows) and main toolbox anchored window will be minimize (hide), then the tables list will close! We must open tree node and search table again!
      Thanks again...
    • I would be grateful if you could report any bugs here: https://sqlcetoolbox.codeplex.com/WorkItem/Create and describe the steps to reproduce, and possibly with screenshots (I am not sure I understand the issue)
    • OK...
      1: Set your SQL toolbox window to auto hide
      2: Open tables tree node
      3: Select a table (now, the tables tree is open and a table is selected)
      4: Click every where of VS-window (out of toolbox window) to close toolbox (autoHide)
      5: Back agian to toolbox (open it), Now, tables tree is closed and nothing is selected
      Thanks
    • Thnaks, I have logged an issue here: https://sqlcetoolbox.codeplex.com/workitem/12260 
    • Hi, could you try the latest build here, and let me knwo if that fixes the autohide issue: https://sqlcetoolbox.codeplex.com/releases/view/618303 (Uninstall first, then download and run)
    • Hello Erik,
      
      Great job! Thanks for this tool. It is just amazing. Quick question. Is there an API (DLL) so that the Script generation of SQL Server Database Schema and Data to SQLite can be called inside a C# code? 
      
      Patrick M.
    • Yes! That's OK...
      Thank you very much...
      I hope that you find enough time to update standalone version....
      Thanks again
    • Hi, you are welcome - re the standalone edition: Would be helpful if you could list what you are missing in the standalone edition by submitting a list on the CodePlex issue tracker 
  • Windows 10 universal app and SQL server compact database
    5 Posts | Last post October 27, 2015
    • Is it possible to access to a SQL server compact 4.0 database from VB or C++ in an universal app ? Previously, I used the reference System.Data.SqlServerCe and made SQL queries in the code by means of SqlCeResultSet.
      Now, how to do ? And why Microsoft doesn't propose the tool you have created ?
    • You cannot, but you can use SQLite
    • I can open my SQLite db in VS2015 with the toolbox 'SQL Server Compact/SQLite toolbox' and see the tables and fields. I'm trying to open the db in VB with:
      Dim db As SQLiteConnection = New SQLiteConnection(dbpathstring)
      I get an error 'could not open database file'.
      How to open a SQLite db then make queries in the Universal app environment ?
    • See my blog post here: http://erikej.blogspot.dk/2014/10/database-first-with-sqlite-in-universal.html
    • I followed these instructions since I was able to open the db from the toolbox.
      
      But I have found at the moment the cause of the problem: it is due to the db path which must be equal to this one:
      Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "MyDb.db")
      
      Because of Windows Store app, the database cannot be put elsewhere.
      
      In addition, the db has to be included in the project in order to be copied in this special folder. So, its settings in the project must be: 'content' (build action) and 'copy always'.
      I also tried the folder "ms-appdata:///local/" as recommended somewhere but that didn't work.
      
      I got this information here:
      https://msdn.microsoft.com/en-us/library/windows/apps/hh967755.aspx?cs-save-lang=1&cs-lang=csharp#code-snippet-1
  • Could not find SqlMetal location in registry
    7 Posts | Last post October 10, 2015
    • Hi, Erik, 
      
      I'm trying to create a Linq2Sql DataContext on a SqlCe 4.0 database, but I'm getting an error stating 'Could not find SqlMetal location in registry'. I have verified that SqlMetal exists in the following location:
      
      C:\Program Files (x86)\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools
      
      so I'm guessing I must be missing a key entry, but I have no idea what I would need to enter into the registry to resolve this issue. Any thoughts?
      
      thanks!
    • Update: 
      So I've been digging through the registry looking for the keys that I think the toolkit is looking for and I've verified the existence of the following keys:
      
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MicrosoftSDKs\Windows\v7.0a
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MicrosoftSDKs\Windows\v7.1a
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MicrosoftSDKs\Windows\v8.0a
      
      each of which has an InstallationFolder value that points to a folder in which I have verified taht there is a copy of SqlMetal.exe appears.
      
      So I'm guessing there is a key that the toolkit 
      
      I'm using VS2012 pro if that's important. 
    • I fixed some issues relating to sqlmetal detection in the latest refresh, could you try to remove the extension, and reinstalle from the gallery, so you get version 4,3,0,2
    • I did an uninstall and updated to 4.3.0.2, but to no avail - still unable to locate the SQLMetal in the registry. 
      
      I checked my path variable and made sure that all three of the folders I listed above were specified, just in case that was the issue, but with no success. 
    • Hi JW, it was a bug - fixed in the latest daily here: https://sqlcetoolbox.codeplex.com/releases/view/616898
    • Success. Thanks so much for all your quick help on this!
    • Great worked for me as well - good work
      
1 - 10 of 95 Items