Name: ExportSqlCe(updated)Link: https://github.com/ErikEJ/SqlCeToolbox/ SQL CE Versions: 3.0, 3.5, 4.0 Last updated: Current Platforms: Win32, Win64 ”This command line utility helps you better manage your SQL Compact development efforts. If allows you to script schema and data from any SQL Compact database file to a .sql file, which can be used in any context. The utility is developed in C# with Visual Studio 2008. You can use the resulting script for documentation, programmatic scripting of SQL Compact database files, or migration of schema and data to SQL Server (Express) 2005 or later.

Name: Export2SqlCe (updated)Link: https://github.com/ErikEJ/SqlCeToolbox SQL Server Versions: 2005, 2008, 2012, 2014 Last updated: Current Platforms: Win32 Added to list: 4th March 2010 ”A command line utility to script an entire SQL Server 2005 or later database with or without data to a SQL Compact T-SQL script.”

Name: SQL Server CE Query ToolLink: http://cequery.codeplex.comSQL CE Versions: 3.5, 4.0 Last updated: 2011 Platforms: Win32, Win64 (?) ”CEQuery is written in C# with the help of Visual Studio 2008 platform. Some of the features of this tool are described below: User is able to create CE database. If the schema is provided, the tool is able to create the tables and columns. User is able to overview an existing CE database with its table and column structure in tree format. User can design a query by dragging and dropping tables and columns from the database tree. User can manipulate [Insert/Update/Delete] records in a selected table. User is able to generate scripts from a single table or of whole databases. [Both for SQL CE or SQL Server]. User is able to open multiple SQL Server CE files simultaneously. User is able to convert a SQL Server database to a SDF file with schema and data. User is able to change password of a SQL CE DB. The tool is now capable of handling the database with no password.“

Name: RemoteSqlCeLink: http://www.gui-innovations.com/html/remotesqlce.htmlSQL CE Versions: 2.0, 3.0 Last updated: 2007 Platforms: Windows CE, Win32 ”SqlServerCE is a great database for Pocket PC’s, but designing, maintaining and querying databases on the PPC, especially whilst developing, can be wearing. We developed this tool to help us when developing for SqlServerCE. With RemoteSQLCe you can completely manage your SqlServerCE database from the desktop. RemoteSQLCE works in the cradle, and over ethernet/bluetooth.”

Tried all tools from here, no one was able to do what i needed, so i wrote small tool that can copy result of query from one DB to another, works with ADO .NET, ODBC, OLEDB.http://brokenpipe.wordpress.com/2010/01/02/ado-net-data-transfer-tool/

Owner: You could script the SQL Compact databases, create SQL Server databases for each, and do the compare using any SQL Server compare tool - I do not know any schema compare tool that supports SQL Compact.

I'm working with a database .SDF using a VisualCE program, but this development software doesn't have any instruction or tool to sync between SDF and SQL server. Do you know any application which can do this synchronization?

I didn't develop my application in Visual Basic because I haven't experience in program language and VisualCE was a easy one.

Is there a way to connect to a SQL Server CE 4.0 from Excel to use is as a data source for Pivot Table ?I cannot see any Oledb provider corresponding toWindows CE in the Excel Data Source connection dialog after installing it, and the associated tools...

Hello Sir. I love your blog. Keep up the good work.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. It will be very much appreciated by the way. :)

Do you know of any repair tools for sqlce. I have a sdf file that will not open and gives the error message The database file is corrupted, possibly due to a file system issue. Ive tried your sqlcecmd40 repairdatabase with no joy aswell as other editors.