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.
Thanks so much for your great tool! It is really help me to write my first SQL program in C#. Also, thanks so much for your great documentations/clips and all of your comments in here and in stackoverflow.com .You are the best!
I wish you all success and happiness in your life and business. (5 stars is not enough for your helps!) Best Regards.
Really helpful tool here. It saved me a bunch of time having to take a bunch of screenshots of a SQL CE 3.5 database from VS 2008. I know, not a programming task but still saved me time, and the script it generated would come in handy if I really did need to move to SQL Server Express.
After installing the toolbox, when ever i click on it, its empty. It only shows is the SQL Server Compact Data Types. I dont see any of the menu options as shown. Any ideas? Help? Im pulling out my hair..
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