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.

(165) Review
Visual Studio
2015, 2013, 2012, 2010, 15
Download (512,486)
4/19/2016
4.5.0.2
View
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Description
Reviews (165)
Q and A (99)
Sign in to write a review
Sort by:

by Ed Kaufmann | Thu 6:44 AM

As a retired hobby developer this is the tool I would miss most.
I use the offline tool since years - the most amazing thing: it does everything it promises!
The integration in VS is flawless as well.

And, last but not least, I've never experienced a better support.
Erik thanks a lot!
ed

by Rdogmartin | Mon 9:37 PM

Fantastic little tool for quickly editing a SQL CE database. We recommend the stand-alone version to our customers any time they need to edit their Gallery Server database.

Roger Martin
Founder and Lead Developer
Gallery Server
Digital Asset Management and Web Gallery
galleryserverpro.com

by SirWernich | Mon 12:24 PM

it doesn't quite fit in with the "dark" theme, but it works pretty darn well, which is brilliant because sql server management studio doesn't do
sql CE anymore.
(i'm using this in vs2013)

by Peter Vrenken | April 19 2016

Great tool!

A must-have for everyone that uses SQL Server Compact and/or SQLite.

by Giarko | April 13 2016

It's a fantastic tool, it does exactly what it promises! Thank you very much.

by JJPuua | April 07 2016

ErikEJ April 07 2016
| Edit |
Delete

How can I make it better?

by clarewang | April 01 2016

ErikEJ April 01 2016
| Edit |
Delete

What could I do to make it 5 stars?

by rkamarowski | March 25 2016

First class package.

by Respiro | March 16 2016

perfect and intuitive tool with lot of usefull features

by Maxumus | March 15 2016

Excellent! Use it all the time, very well done.

by tj881024 | March 13 2016

很好用,赞一个,中国网友发来贺

ErikEJ March 14 2016
| Edit |
Delete

謝謝 :-)

by Francois Rossello | March 10 2016

Merci !

by Win_sky | March 07 2016

Great tool, only error I receive is when trying to create a report using the report wizard. When creating a data source you would get "error occurred while retrieving the information from the database" or won't even attempt to connect. Any help with that?

ErikEJ March 07 2016
| Edit |
Delete

I will be happy to provide support, but please provide more details about your issue here: https://github.com/ErikEJ/SqlCeToolbox/issues/new

by Gianluca Maria Marcilli | March 06 2016

Very good tool. Hope for updates concerning integration of DB in asp.net applications.

ErikEJ March 07 2016
| Edit |
Delete

Hi, could you please explain what "updates concerning integration of DB in asp.net applications" means here: https://github.com/ErikEJ/SqlCeToolbox/issues/new then I will look into it

by bkboggy | March 02 2016

Absolutely incredible. A lot of fantastic options, works without any hick-ups (thus far) and just makes my work that much easier. My only complaint would be that it does not display data types for SQLite, but rather generic db types. I would much rather choose from types listed on https://www.sqlite.org/datatype3.html .

ErikEJ March 02 2016
| Edit |
Delete

Thanks for the review, pls log an issue on github with details about where you see these data types... (screenshot, maybe)

by infoset | March 01 2016

I really appreciate your commitment to the file-databases commmunity and keeping things alive despite Visual Studio team politics. Please keep up your fantastic work.

by Karthick snkl | February 24 2016

thank you

ErikEJ February 24 2016
| Edit |
Delete

How can I make it 5 stars?

by GeroZinkDev | February 21 2016

Excellent Toolbox! Thanks!

by Busta4Sure | February 19 2016

This tool is perfect for what I need. Glad to see some SQL Compact support in VS again! Thanks Erik.

by Murti_x | February 17 2016

İt's really good tool.But deleting or editing rows is not working sometimes.

Thanks.

ErikEJ February 17 2016
| Edit |
Delete

Thanks for the kind Words. If you have issues, could you please post detailed steps to reproduce on Github

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


  • Planned SQLite Enhancements
    3 Posts | Last post April 19, 2016
    • Erik - Love the Toolbox so far.  So I know what I might expect in the future and at the risk of seeming pushy, do you plan for SQLite to:
      
      1.  Enhance the Build Table (beta) designer to start with a previously entered table so that I can add/delete/rename columns and then execute a Drop/Create instead of starting over when I need such changes or having to edit the previously saved script?
      
      2.  Add the equivalent of "Add SQLite-net DataAccess.net" to instead generate a Linq DataContext class together with the fully attributed entity classes corresponding to each table?
      
      3. If so on #2, will you include relationship code, which means adding a foreign key attribute to Build Table?
      
      For those that you intend to implement, do you have a guess as to timing?
      
    • Hi, this project is open source and free, and accepts any contributions from you and others. Regarding your suggestions:
      1: I propose that you just use the "Script as DROP and CREATE" feature. Remember that SQLite does not support "ALTER TABLE"
      2: LINQ to SQL is not supported by SQLite as far as I know, so no plans there.
      3: See reply to 2
      If you like the Tool, feel free to post a review here...
    • Erik - Thanks for the response.  
      
      1.  I thought it would make sense to just edit the DROP and CREATE script.  That's certainly easy enough.
      
      2.  Seems ignorance on my part re Linq working with SQLite is bliss.  I just got it to work.  In particular, I did several regular Linq queries, a DataContext.GetTable(), and several approaches to changing data, each followed by DataContext.SubmitChanges().  All the changes were made in the database.  
      The key is to instantiate the Linq DataContext by passing in a SQLiteConnection instead of the connection string.  After that, I used the Toolbox’s generated DataAccess code as a starting point for the Linq entity classes.  The key hurdle there was that I made NULL attribute database script changes after I started without corresponding changes in the entity classes.  That produced a cryptic error message that took some time to eventually rundown with help from Stack Overflow.  
      
      3.  I may respond to your suggestion to contribute to the Toolbox, though certainly not until I'm on a more solid footing understanding this stuff.  I'm only making step-by-step progress, having just started to learn about both SQLite and Linq a couple weeks ago at your suggestion.  And a great suggestion it has proven itself to be!
      
      Thanks again.  I'll post a review of the Toolbox in the next week or so.
      Steve
      
  • Toolbox activates "Properties" window when activating anyting in Toolbox window
    2 Posts | Last post April 16, 2016
    • Hi, Erik! Thanks for new version! But I got bad news.
      When the project first launched, trying to activate Toolbox makes active "Properties" window, so that I have to activate Toolbox again. It was also in early versions.
    • Hi.. could you post an issue at github, and provide more details about which version you mean by "new", and steps required to reproduce the issue...
  • PrimaryKey attribute not recognized?
    4 Posts | Last post April 12, 2016
    • I have installed the Sqlite Toolbox, successfully connected to an existing sqlite database, and added DataAccess.cs to my project. However, the table and column attributes are not recognized:
      What is the namespace for attributes in the DataAccess.cs?
      What references are needed?
    • Hi Gary, I beleive there is a link to this blog post at the top of the DataAccess.cd file: See the blog post here for help on using the generated code: http://erikej.blogspot.dk/2014/10/database-first-with-sqlite-in-universal.html 
    • Erik - I am having the same problem as Gary (though with a database I created using the Toolbox), plus these additional problems:
      -- The generated DataAccess code had "using SQLite" instead of "using System.Data.SQLite", which made the SQLiteConnection class unrecognizable.
      -- After fixing the using, SQLiteConnection was ok, but the CreateTable methods were not recognized.  There are several CreateXxx methods in the SQLiteConection class, just not CreateTable.
      
      I followed the blog you suggested, including installing the 2 additional Windows Phone and Windows RT extensions, all using the VS Extensions Manager.  The problems are still there.
      
      I can see how the Toolbox will be a big help once I'm past the startup challenges.  Thanks for your help.  Steve
      
    • Cincy Steve: As noted above, the generated code is for use with the sqlite-net class code, not with System.Data.Sqlite - please read the blogpost linked above. The same link should be at the top of the generated code. 
  • Data Query error if SQLite databases uses DateTimeFormat=Ticks
    2 Posts | Last post March 11, 2016
    • I have a database that uses DateTimeFormat=Ticks in the connection string.  When a DateTimes is written to the database, the value of the Ticks property is written. When I use your tool to query the database, I get an error from DateTime.ParseExact with a very long stack trace.
      
      Can you fix your tool so it checks that property in the connection & interprets the value properly? There's also a property in the connection that tells you what value to use for the DateTimeKind property of the DateTime struct.
    • Hi Tony, I have made some fixes for that recently, can you describe the issue in more detal here, and tell me the exact extension version you use (from the about dialog in the add-in): https://github.com/ErikEJ/SqlCeToolbox/issues/new 
  • Data Source VS2015
    5 Posts | Last post March 04, 2016
    • 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  
    • Like using your tool, but I private install SQL CE with my app.  Any thoughts on how to get your tool to work with private install?  Also, I find this error occasionally https://support.microsoft.com/en-us/kb/974247  Any thoughs?
    • Sorry Erik, thought I was responding to SQLToolBox.  That is the tool we are using.
    • John: you could use binding redirects with the standalone tool. And lets discuss the other issue on Github
  • 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!
1 - 10 of 99 Items