What's new in Portable SQL Compact Query Analyzer 1.3.4.0
Sep 29, 2023
- What's new:
- 64-bit support
- CLI argument for database password
- Features:
- 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 (SQLCE 3.0 and 3.1 are not supported in the 64-bit version)
- 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)
- What's Changed:
- Add support for command line DB password option 1
New in Portable SQL Compact Query Analyzer 1.3.3.0 (Apr 14, 2023)
- What's new:
- 64-bit support
- Features:
- 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 (SQLCE 3.0 and 3.1 are not supported in the 64-bit version)
- 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)
- Bug fixes:
- #28: Crash on large DB
- #36 More Info link in About dialog opens old CodePlex project
- What's Changed:
- Upgrade to GitHub-native Dependabot by @dependabot-preview in #19
- Update Cake Build dependencies by @christianhelle in #34
- Update AvalonEdit to v6.3 and Xceed.Wpf.Toolkit to v4.5 by @christianhelle in #35
- Add 64-bit support by @christianhelle in #37
New in Portable SQL Compact Query Analyzer 1.0.2.25483 Beta (Nov 30, 2013)
- 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
- Features:
- 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
New in Portable SQL Compact Query Analyzer 0.7.1.19644 Beta (Jul 1, 2011)
- New Features:
- Displays database information (database version, filename, size, creation date)
- Displays schema summary (number of tables, columns, primary keys, identity fields, nullable fields)
- Displays column information (database type, clr type, max length, allows null, etc)
- Support for SQL Server Mobile Edition 2005
- Support for password protected databases
- Features:
- 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
New in Portable SQL Compact Query Analyzer 0.6.0.0 Beta (Jun 24, 2011)
- New Features:
- Optimized performance for display large data sets
- Implemented displaying a thumbnail for IMAGE fields
- Generate Schema and Data Scripts
New in Portable SQL Compact Query Analyzer 0.4.0.0 Beta (Jun 17, 2011)
- New Features:
- Execute multiple SQL queries (delimited by a semi colon)
- Display query result as XML
- Displays a progress bar when performing heavy operations
- Features:
- Execute SQL Queries against a SQL Server Compact Edition database
- Easily edit the contents of the database
- Supports SQLCE 3.1, 3.5 and 4.0