Skip to content

A fast and lightweight tool for querying and manipulating SQLCE databases. This tool supports SQLCE versions 3.0, 3.1, 3.5 and 4.0

License

Notifications You must be signed in to change notification settings

christianhelle/sqlcequery

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Build GitHub All Releases buymeacoffee

SQL Compact Query Analyzer

A SQL Server Compact Edition Database Query Analyzer

Download latest release here

Features:

  • Create new database
  • Automatically refresh database upon executing create/alter/drop table queries
  • 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)
  • Displays index information (column name, is unique, is clustered)
  • Execute SQL Queries against a SQL Server Compact Edition database
  • Execute multiple SQL queries (delimited by a semi colon ;)
  • Easily edit the contents of the database
  • 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
  • Supports password protected databases
  • Supports SQLCE 3.0, 3.1, 3.5 and 4.0

Coming at some point:

  • Purge database content
  • Create, edit, and drop tables UI
  • Create, edit, and delete table references and indexes UI
  • Support for SQL Server Compact Edition 2.0

Screenshots

alt text

  • Displays database and schema information and executes multiple SQL queries directly

alt text

  • Edit the table data directly

alt text

  • Display the contents of IMAGE fields

alt text

  • Performance numbers for queries

alt text

  • Query errors

alt text

  • Output result set as XML

alt text

  • Create new database

alt text

  • Shrink, compact, script database

Prerequisites:

  • .NET Framework 4.0

For tips and tricks on mobile development, check out my blog

If you find this useful and feel a bit generous then feel free to buy me a coffee ☕