v1.3.4

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 by @greenozon in #41

New Contributors

• @dependabot made their first contribution in #38
• @greenozon made their first contribution in #41

Full Changelog: 1.3.3...1.3.4

v1.3.3

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 Contributors

• @dependabot-preview made their first contribution in #19
• @greenozon reported and helped troubleshoot the large DB issue in #28
• @greenozon reported the issue in #36

Full Changelog: 1.2.6626...1.3.3

1.2.6626

What's new:

• Fix SQL parsing issues for multiple queries (Contributed by @diotteo)

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 second)

Bug fixes:

• #17: Parse SQL queries correctly
• #18: Restore informative message on SQL syntax error

1.1.722

What's new:

• Automatically save passwords for protected databases (Contributed by @peacefulvibes)

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 second)

Changes:

• b6705b4 Merge pull request #9 from christianhelle/save-passwords-in-recents-file
• ee159b8 Update MainViewModel to use SavedFileInfo
• 201f08b Introduce SavedFileInfo for storing passwords in the recently used list file

This list of changes was auto generated.

1.0.4.530

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 second)

Prerequisites:

• .NET Framework 4.0

Changes:

• bc3a8d2 Merge pull request #8 from christianhelle/clean-up-build-output
• 73fd7d0 Update Cake.FileHelpers addin version 3.2.0
• 5f3bd85 Remove Debug configuration from Cake build
• 3d159cb Manually delete localization folders
• b4a760f Add CleanUp-Release task
• fab9a9e Add link directly to latest release in README
• 315299c Remove git semantic version from artifact filenames
• 509b21e Add Azure Pipelines status badge to README
• 04cf3e7 Merge pull request #7 from christianhelle/inno-setup
• 0a02355 Register .sdf file association

See more

• 123f3ef Remove legacy setup project from solution
• d973ce6 Merge pull request #6 from christianhelle/cake-build
• 8c5fc67 Remove legacy solution files
• 16919de Create Cake build script
• 6c3ec0c Create Inno Setup file
• a02ed30 Add Source/tools folder to .gitignore
• 96ca4d0 Merge pull request #5 from christianhelle/migrate-to-vs2019
• 9894d18 Add Inno Setup binaries to Dependencies folder
• 6aaae93 Update solution file to use Visual Studio 2019
• da6293e Update MessageBox static using nameespace
• 7512068 Update extToolkit xmlns in MainWindow.xaml
• 1052627 Update XCeed.Wpf.Toolkit nuget package
• f77afaf Merge pull request #4 from christianhelle/feature/update-packages
• 7726040 Auto resize table data grid
• 82a3730 Bump up setup project version and update manufacturer and support url
• cfc138b Bump up build number
• d29235b Update nuget packages
• b827afa Fix header scaling issue on High DPI devices by resizing the column header height
• e5b3469 Create .gitignore
• ae0fb79 Remove packages folder
• a2743f5 Add missing SQLCE 4.0 libraries
• ccaa902 Add missing SQLCE 3.5 libraries
• 890df1a Add missing SQLCE 3.0 libraries
• 922672d Fix dead links in README
• addf9be Merge pull request #2 from christianhelle/bugfix/sqlce40-fileloadexception
• ee34882 Enable to avoid FileLoadException when running using the portable binaries
• 869e4ef Rename source code folder to Source
• 07c2605 Remove legacy .hgignore file from Mercurial
• 6ab1685 Add latest release download links to README
• 054d39c Fix README file
• 1fb9810 Create README.md
• 66c7fe1 Add Windows Explorer file drag and drop support to load SQL query files or any text files into the Query text editor
• 90f3163 Fix missing files during debugging
• 12f9b3e Display the resulting row count and execution time when executing SQL statements
• fd10a34 Create Visual Studio 2012 solution
• 3289402 Resolve dependency issues
• a44278f Update SQLCE 3.5 dependencies to SP2 build 8109

This list of changes was auto generated.

1.0.2.25483

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 second)

Prerequisites:

• .NET Framework 4.0