Rating:        Based on 7 ratings
Reviewed:  5 reviews
Downloads: 28911
Change Set: ab9275f0d311
Released: Jul 31, 2013
Updated: Sep 7, 2016 by christianhelle
Dev status: Stable Help Icon

Recommended Download

Application SQL Compact Query Analyzer (Installer)
application, 3428K, uploaded Jul 31, 2013 - 26555 downloads

Other Available Downloads

Application SQL Compact Query Analyzer (Portable)
application, 3110K, uploaded Jul 31, 2013 - 2356 downloads

Release Notes

Bug fixes:
- Resolved issue where the application crashes when loading a database that contains tables without a primary key
- Resolved issue where password protected database with a large max database size won't open

- Displays database information (database version, filename, size, creation date)
- Displays schema summary (number of tables, columns, primary keys, identity fields, nullable fields)
- Displays the information schema views
- Displays column information (database type, clr type, max length, allows null, etc)
- Support for SQL Server Mobile Edition 2005
- Support for password protected databases
- Execute SQL Queries against a SQL Server Compact Edition database
- Easily edit the contents of the database
- Supports SQLCE 3.0, 3.1, 3.5 and 4.0
- Execute multiple SQL queries (delimited by a semi colon ;)
- Display query result as XML
- Shrink and Compact Databases
- SDF file association with SQL Compact Query Analyzer for launching directly by opening the SDF in Windows Explorer
- Displays thumbnails for IMAGE fields
- Generates Schema and Data Scripts
- Create new database
- Automatically refresh database upon executing create/alter/drop table queries
- Optimized performance for loading large databases (Loads a database with up to 200 tables in under 1 second)

- .NET Framework 4.0

Reviews for this release

This is an excellent tool for working with SQL Server compact databases. It is especially useful in technical support scenarios, were customers have corrupted database data that needs to be edited. Editing database data with this tool is first class. Very easy to install and use. Thank you for such a great tool.
by JasonAlls on Jan 3, 2017 at 12:43 PM
Perfectly simple, usable and lightweight.
by Cem_Karaer on Oct 4, 2016 at 9:44 AM
Thanks for this useful, beautyful and great quality application
by Bakelita on Sep 18, 2016 at 10:45 PM
There don't seem to be many tools available for examining .sdf database files, this is very useful. I have only been using for a short time but very good so far.
by ChangedDaily on Jan 18, 2014 at 10:19 PM
Very useful tool, glad that I found it
by chrisdotwood on Sep 16, 2013 at 9:13 AM