I’ve been working extensively on enterprise mobility projects lately. These applications integrate into large SAP based systems and when testing the system it can get very tedious to set up some temporary data from the backend. I’m also working with some not-so-technical testers that get intimidated by the Visual Studio or the SQL Server Management Studio. This led me to writing an open source project called SQL Compact Query Analyzer

Here’s some details I pulled directly off the CodePlex site

Project Description
SQL Server Compact Edition Database Query Analyzer

Features:
- Execute SQL Queries against a SQL Server Compact Edition database
- Table Data Editor to 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
- Generate Schema and Data Scripts
- Display database and schema information
- Support for password protected databases

Coming Soon:
- Purge database content
- Create new database
- Create, edit, and drop tables
- Create, edit, and delete table references and indexes
- Support for SQL Server Compact Edition 2.0


Screenshots


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


- Edit the table data directly


- Display the contents of IMAGE fields


- Performance numbers for queries


- Query errors


- Output result set as XML

Prerequisites:

- .NET Framework 4.0 

Check it out! You might find it useful!