Just want to find out if anyone has used or is currently using Sql Compact 4.0 for development. Basically we are looking for tools that can support the creation of change script similar to the one we have in Sql Server 2008 Management Studio. If you are not sure what that feature is, basically whenever you make schema changes, you can simply generate the change script to be run elsewhere. I haven't come across any tools that can provide that kind of feature for Sql Compact 4.0. Has anyone come across that kind of tool? If so, can you please let me know? Thanks in advance.

This is an attempt at a comprehensive list of SQL Server Compact Microsoft and 3rd party tools, both commercial and non-commercial. Please let me know if I have missed anything, and I will add it. Microsoft supplied tools Visual Studio Community 2017 free – when used with the SQL Server Compact / SQLite Toolbox: SQL CE 3.5, SQL CE 4.0 Visual Studio 2008 Professional (SQL CE 3.5) Visual Studio 2005 Standard (SQL CE 3.1) SQL Server 2008 R2 Management Studio Express (free, SQL CE 3.5 SP2) Link: SQL Server 2005 Management Studio Express SP2 (free, SQL CE 3.1) Link: New or updated entries are noted with (new) or (updated) ”Last updated” indicates when the tool was last updated by it’s author. Non-commercial (free) tools My GitHub Tools Name: SQL Server Compact Toolbox (updated) Link: SQL CE Versions: 3.5, 4.0 Last updated: Current Platforms: Win32, Win64 Added to list: 29th June 2010 ”Add-in for Visual Studio 2071/2015/2013/2012 (for 3.5 and 4.0).

Standalone app (for 4.0 and 3.5) Adds several features to help your SQL Server Compact development efforts: - Scripting of tables, including data. - Script of entire schema, optionally with data, both of SQL Server Compact and SQL Server 2005 or later databases, including SQL Azure. - Import to SQL Compact 3.5 from a server database or CSV file. - Basic, free form query execution. I love your blog. Keep up the good work.

Microsoft SQL Server Compact 3.5 SP2 Query Tools ENU is a software program developed by Microsoft. The setup package generally installs about 31 files and is usually about 2.33 MB (2,438,144 bytes).

I have found all the necessary info about what database is right in terms of their pros and cons. This site has been truly useful to me. I however want to make a humbly request. I wish you will make a tutorial about using SQLite with VB.NET, C# with SQLite. There seems to be very limited resources out there.

Even if they are many, they seem to very fragmented and the steps seems very confusing to me.Some talk of Finisar dll that needs to be downloaded etc. To me, as it seems SQLite is going to be the future db for apps, I wish there was a good site or blog dedicated to it providing solid tutorials on how to complete the basics of every DB app - CRUD. (Add, Read, Edit, Delete) with the embedding/and retrieval of images to the database as well. I have managed to make a head start but due to very limted resource materials on.net and sqlite, I have found myself wanting. For example, I have been able to load all the tables in the database to a combobox, but I am unable to display the content of a table in a listview for instance. I urge you to google: 'How to display sqlite table contents into listview in VB.net' and all you get is stuff relating to android. Please kindly help.

We need resources on the.net languages (VB.NET esp & C# and SQLite). ALso please help me with how to display the contents of the sqlite table to my listview.

Freehand software accurip. It will be very much appreciated by the way.:).