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.
This toolbox is great! When I got tasked with creating an embedded database for a tablet app using SQL Compact, I had never done it before. This toolbox and Erik's blog made it simple. I recommend it to everyone. I have used it on several applications since then.
Great and professional tool! Looks and works like native VS toolboxes. That was like life saving when i found it because at the moment i was nervously thinking of what to do in order to develop and maintain SQLite database under Windows Runtime platform on Windows Phone 8.1. Other tools i tried are not comparable. I might not try them that many but as soon as you find this one you don't want to be searching for a tool further. Thank you very much!
It is extremely excellent tool for databases such as sqlite which is very difficult for me but with this tool I can easily create and use my sqlite database in my projects. I am very thankful to you for this tool
I have used the SqlCe35Toolbox.exe and SqlCeCmd.exe from Mr Jensen to analyze/dump Windows Mobile SDF database files. The tools are easier to use and very helpful. Mr Jensen is also very quick to respond to my questions and issues. Highly recommended !
I use this excelent tool several years. It helps me a lot - for example when Webmatrix had broken DB functionality. Now I use it inside VS 2013 and it is still beter and better. Especially new function for connection renaming is fantastic since I have more the 15 databases with the same filename Data.sdf.
This tool is an ESSENTIAL part of Visual Studio since Microsoft removed from Sql management Studio the support of SqlCE. Its value is unbelievable and we have only to thank Erik for his remarkable job. Thank you!
This is a fantastic extension. This has helped me several times in the past with migrating databases and with the added ability to migrate SQLite databases I can now do so much more with it. This extension also has the added benefit of being created by the very dedicated ErikEJ who is willing to work with his users to figure out any problem they may be having and to extend the extensions functionality to its full potential.
Anytime I want to add a LINQ to SQL for my SQL compact 3.5, I get this error message:
SQL Server Compact - Couldn't find SqlMetal in the expected location: bin\NETFX 4.0 Tools\sqlmetal.exe;
Can you help me?
Thank you in advance
Apologies if this has been answered elsewhere, but I wasn't able to find out after doing some web searching. I'm trying to insert into a .sdf database from an external CSV file. When I try the BULK INSERT command, it appears to not be supported.
SQL Server Compact gives me:
Error Code: 80040E14
Message : There was an error parsing the query. [ Token line number = 1,Token line offset = 1,Token in error = BULK ]
Minor Err.: 25501
Source : SQL Server Compact ADO.NET Data Provider
Num. Par. : 1
Num. Par. : 1
Err. Par. : BULK
What's the recommended way to do a bulk insert? I'm runnign version 4.3.0 on VS2015 Thanks!
Installed SQL Server Compact/SQLite Toolbox but in my version of VS, the option SQL Server Compact/SQLite Toolbox in the menu Tools shows that SQLCE 4.0 & 3.5 is missing. My question is why? In menu Tools\Extension and Updates it shows that version 4.2 is installed.
Some more information in order to understand my problem is when I right click "Data Connections" it is not possible to add SQL Compact 3.5.... as well as 4.0 option. Only possibility is to Add SQLite Connection...
Many thanks in advance for your reply.
I have a project with an entity framework model first pattern. I will generate a database from this model, but first it must be a sql server compact (sdf) database. For that I installed the sql server compact/sqlite toolbox. The dialog to choose the datasource appears, but if I press next, than the dialog will be closed and I don't know why. I think before updating to EF 6 it worked with EF 5. Does anybody have a solution? Thanks Andreas
Hi Erik. Sorry but I need a solution for that. I'm hanging with my project. Here is the link to a demo sample.
In this small sample I have the effect I described. Just open the edmx file and try to generate the database from model based on an existing sdf file.
I've got a table (using compact 4.0 connection) with 2 columns (id and name)
Id is a uniqueidentifier and name is nvarchar(25)
the Id column is not filling in automatically though as I believe it should be and result in me getting an error when i try to enter new rows.
Thanks for reply ErikEj
To be honest i'm not a big fan of signing up for various site for 1 app. which is why i posted here since this is where I got the extension at.
As for my guid problem. I've been using CE tables in the past that did autofil Guid's. In fact I can connect to a previous existing CE database that was created using VS2012 and then add rows to it with your extension with no problem and it auto fills not problem. But if I Create any new tables (which are successful) and then go to add new rows that is when the autofill doesn't happen. Also, I am now using 2013 community.
urg.... I hit the other site once I find it again. but honestly trully agittated by it..
What more information will you need. You were asking the create table script, but as I said in the previous post, creating the table is not the issue.
I try to develop an Windows Phone Silverlight 8.1 App with al local database. I designed a database with your tool and add the sdf file to the project.
The database has at the moment only the table Job.
I add Windows Phone Datacontext with your tool.
In the Datacontext file is a Job Class.
Then i created the database with CreateIfNotExists().
But whe i read from the Job table i get the error "table is not avaiable" German "Die angegeben Tabelle ist nicht vorhanden. [Job]"
Which step i have forgotten?
Hi Erik, thank you. I made a small demo project and this works. So i made two changes in my app, first i uninstall it from the mobile dev and i used a smaller name for the db. And this works also.
The sdf file was in the project embeddedResc and copy always.
I want to create SQL file with the changes between the two DBs. When run the Diff tool it seems to compare only the Schema.
Is there a way to compare data in both databases and get Insert statements with the differences?