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.
SQL Server Compact Edition Database Query Analyzer
- Execute SQL Queries against a SQL Server Compact Edition database
- Shrink or Compact a database
- Easily edit the contents of the database
- Supports multiple versions of SQL Server Compact Edition (Currently 3.1, 3.5 and 4.0)
- Database maintenance
- Support for multiple versions of SQL Server Compact Edition (2.0, 3.0, 3.5 SPxx)
DownloadAnalisis Files SDF dengan Database Query Analyzer SQL Compact
Writer: Jasa SEO Location: Newyork, United States
You have just read an article category Utilities by title "Analisis Files SDF dengan Database Query Analyzer SQL Compact" http://update-seputar-software.blogspot.com/2011/06/analisis-files-sdf-dengan-database.html.