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.
I've used Erik's standalone toolbox for SqlCE 3.5 previously and just started using this for working with some Sqlite dbs. I've only used a small number of the features so far but it's already made my life much easier. Thanks Erik.
Hi, sorry to her that, I have logged an issue here: https://github.com/ErikEJ/SqlCeToolbox/issues/113 - would be very helpful if you could provide more details (database engine and engine version in use, for example)
I just tried Export SQL Server to SQLite and get an error. -- Error Code = 1 Message = SQL Logic Error or missing Database near "'-'" = Syntax error Result = Error -- Looks like there was an error export Field Default Value.
Would it be possible to add a Close connection option to the pop-up menu of a database? I have to restart VS to be able to delete the DB I previously opened by SQL Server SQLite Toolbox. Otherwise it's a great tool!
2016-08-15 11:58:59 - Searching for applicable products...
2016-08-15 11:58:59 - Found installed product - Microsoft Visual Studio Express 2012 for Web
2016-08-15 11:58:59 - Found installed product - Microsoft Visual Studio 2015 Shell (Integrated)
2016-08-15 11:58:59 - Found installed product - Microsoft Visual Studio Express 2015 for Windows Desktop
2016-08-15 11:58:59 - Found installed product - Global Location
2016-08-15 11:58:59 - Found installed product - ssms
2016-08-15 11:58:59 - Found installed product - ssms
2016-08-15 11:58:59 - VSIXInstaller.NoApplicableSKUsException: This extension is not installable on any currently installed products.
I have a Compact Server 4.0 database. I need to look at one of the tables. When I right click on a table, the context menu only has refresh and properties. What are the steps to fix this?
I have VS 2015. When I try to reinstall the toolbox, only VS2013 appears.
Please let me know if you are aware of any online tutorial for creating a brand new SQLite database intended for the Windows 10 IOT Core and the Raspberry Pi 3?
I'm interested in creating a Food Recipe database with four tables.The part that I need help with is only with the creation of the database using the scripts generated by your tool.
I will appreciate if you guys can share some links on how to do this using SQLite Toolbox inside Visual Studio 2015.(C#)
I was able to create my tables with the link you provided. For one of the tables I created all the needed fields and inserted all the data including images. Now I find myself in a situation where I need to add another field to that table?
Question: Will I loose all the data? Is there a way to add a field without loosing the data already entered?
When I moved to Windows 10 and tried to export SQL server database to SQLite I
got error DataReader.GetFieldType(3) returned null on my table with sys.geography type column. This operation worked for me on Windows 8.1 earlier. Also this error is well known in net and related with versions of SQL Server and .NET types and has solution.
Is there suggestions?
By default, SQLite does not enforce foreign key constraints (sadly) - you can enable this when you add a connection to a SQLite db by selecting the "Foreign Keys" option - this will make your connection string look like this: data source=C:\Code\sq.db;Foreign Keys=True
Documentation here: https://www.sqlite.org/foreignkeys.html - and if you like the Tool, I would be very grateful for a rating or review here:
Hi Erik - Firstly, this is a great tool and is helpful in my work!
I have few questions on data diff feature and others.
1. I'm trying to convert server db(.mdf) to .sdf file.I had about 1100000 records. On choosing to do this for both schema and data, it generated multiple .sqlce (102)files with 18528KB size. Is there a way to restrict the script to a single file?
2. Once the files were generated, I added an extra record. Since the last run of the script, is there a way to find out the differential updates and generate only the delta script other than doing the .sdf file compare?
3. I wanted to compare the .sdf files and see the difference. I used this 'script database diff' option and saw the schema changes captured for the .sdf file, I am unable to capture the delta data changes between source and target. Is there an option for that?
Hello, I download the extension and watched the videos on https://sqlcetoolbox.codeplex.com/documentation and https://github.com/ErikEJ/SqlCeToolbox and erikej.blogspot.com but I can´t find any simple tutorial of how to start from zero.
I just need to solve the creation of a SQLite dabatabase AND the ClickOncePublish thing to start searching for more.
1) I create a New proyect - Visual Basic - Windows - WFA
2) With the Toolbook I create or connect to the SQLite Database
3) I install NuGet - Install-Package System.Data.SQLite
4) I can show the data base info on a DataGridView
All OK.. but when I publish the proyect and try to run I have the error "Unable to load DLL 'SQLite.Interop.dll'"
I read a lot of boards and I even have the DLL but something still don´t work.
This is something related to the Toolboox or to Visual Studio - SQlite integration?
"If you use my tools, I would be very grateful for a rating or review here:
No problem, I need to learn more and then I will post a feedback
When I activate the "Show results as grid" option in the settings then execute a "SELECT * FROM table" (for example), the grid displays but once I do anything that would scroll the grid or once I use the group by thing by clicking at the "+", Visual Studio stops working and restarts.
I'm using Visual Studio 2015 Community on Windows 10 x64.
I'm attempting to use the CE 3.5 Stand Alone Runtime to modify a single table in a legacy application that has fallen into my lap.
The Problem I am having is, when I open the database, and "Edit Top 200 Rows" The DataGrid shows up, but has Tablename-ReadOnly as its title, and I cannot edit any of the rows. I dont see any messages, just will not let me edit.
There is only a single line on the table, so I'm confused as to why It shows Read-Only.
Do you have any suggestions?
Thanks for this wonderful tool!
Hi Paul - most likely because the table that you are trying to edit does not have a primary key defined. You may be able to use a SQL UPDATE statement if you can find an usable WHERE clause.
If you use my tools, I would be very grateful for a rating or review here: