Need to analyze and execute database queries that are designed in SQL Server Compact edition? Preparing SQL Compact on a new system exhausting, as it takes much time and effort to deploy the database. If you bring the SDF database file, SQL Query Analyzer Compact eliminates the need to install the SQL Compact on your system to view and analyze the database file. This is a portable SQL query executor, analysis, and table viewer data to SQL Compact database. What is needed to analyze database files exported SDF database to analyze the list of tables, execute queries, view error logs, DB table view. In addition, you can Shrink or Compact database and edit the content DBs as well.

First, you need to specify the SDF database file you want to analyze. Once defined, it will display a list of all database tables with each column on the left sidebar. The main window lets you view the contents of the table and execute the query. By default, for each table listed in the main navigation bar, it shows executing query with query results, messages and errors tab in the main window. If you want to run a SQL query, select Execute Query from the Query menu.

To view Table content, switch to Table Data tab. Just double click the data value which you wish to edit.