Sqlcequery Versions Save

A fast and lightweight tool for querying and manipulating SQLCE databases. This tool supports SQLCE versions 3.0, 3.1, 3.5 and 4.0

1.3.4

7 months ago

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

New Contributors

Full Changelog: https://github.com/christianhelle/sqlcequery/compare/1.3.3...1.3.4

1.3.3

1 year ago

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

New Contributors

Full Changelog: https://github.com/christianhelle/sqlcequery/compare/1.2.6626...1.3.3

1.2.6626

3 years ago

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

4 years ago

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:

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

This list of changes was auto generated.

1.0.4.530

5 years ago

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:

  • bc3a8d250c6099bfa526ac1fa9b836e37d9a8a14 Merge pull request #8 from christianhelle/clean-up-build-output
  • 73fd7d06fa1492c61a3b5ed013da84756567f5d0 Update Cake.FileHelpers addin version 3.2.0
  • 5f3bd85d44469fda21af13e2ab4808363937185d Remove Debug configuration from Cake build
  • 3d159cb1490694fcbf242f32328b0d29a9a65cda Manually delete localization folders
  • b4a760fdeb482370ff4ab2febf95d89fe7c37bfc Add CleanUp-Release task
  • fab9a9efc30b33c480587ebddd39bfaa66b7f05f Add link directly to latest release in README
  • 315299c1ccf7bb03fba724be8e3f42fc09f6b930 Remove git semantic version from artifact filenames
  • 509b21e161dd3f248b282e4fdbedd620ff4e79ff Add Azure Pipelines status badge to README
  • 04cf3e731e0edcd50a08c6e7c25a8822ce64c115 Merge pull request #7 from christianhelle/inno-setup
  • 0a02355460247d355658efb50b05e3f46ab7c135 Register .sdf file association
See more
  • 123f3ef4c8b535168d390a8975d2984140477487 Remove legacy setup project from solution
  • d973ce6e96855b5a5f9134676d5d9df372b5bca3 Merge pull request #6 from christianhelle/cake-build
  • 8c5fc672da5409833dab04f80fd64a59ae2aa6e8 Remove legacy solution files
  • 16919de546edf8a09abded0c70173b5f5291778f Create Cake build script
  • 6c3ec0c2d413cd4654c24da7c85a631c616060da Create Inno Setup file
  • a02ed307226f6e3eeeb2dc2edb199eda6b5371fb Add Source/tools folder to .gitignore
  • 96ca4d044548c89d17324817674c17d9e0cc1ad2 Merge pull request #5 from christianhelle/migrate-to-vs2019
  • 9894d1854303d734990a32bd154f47bc910e7a77 Add Inno Setup binaries to Dependencies folder
  • 6aaae9363769c1b374f64c67bbc8569bbdf67913 Update solution file to use Visual Studio 2019
  • da6293e728e783e8c1697fcdb1e14c002ff8f79d Update MessageBox static using nameespace
  • 751206879674b369c23398282cd4932a3db41f9c Update extToolkit xmlns in MainWindow.xaml
  • 10526278066123152c27fa58a0f1afc56f4240ab Update XCeed.Wpf.Toolkit nuget package
  • f77afafbe98147c22f6dfdaab5c2ea06d1e7a692 Merge pull request #4 from christianhelle/feature/update-packages
  • 7726040e5988cdab9780def07896768863f02ef0 Auto resize table data grid
  • 82a3730b4430d1745e769a02fe1c1892f1072029 Bump up setup project version and update manufacturer and support url
  • cfc138b7c1a4253baab2282c4392c7d1b7985903 Bump up build number
  • d29235b430cdcda1a0ae0000f931be8cebd4e901 Update nuget packages
  • b827afa7f7c716bafa1558bb88fc0c3e4aff61ff Fix header scaling issue on High DPI devices by resizing the column header height
  • e5b3469d9bd8b0804f34f7c696f5d585ae83e11e Create .gitignore
  • ae0fb79e14fa2cebdd656f400bb5b06edd21706f Remove packages folder
  • a2743f52f698bf7fabd51e50b53a4f75245ad10b Add missing SQLCE 4.0 libraries
  • ccaa90240128f0072a90fd07b0482781bf70d880 Add missing SQLCE 3.5 libraries
  • 890df1a708bec798e34b1ab50441c8cd406c5a81 Add missing SQLCE 3.0 libraries
  • 922672d6e00dbb86e788815762e12fcd9f0e80ab Fix dead links in README
  • addf9be2fccec0e217a59594d9b83e3f183b733e Merge pull request #2 from christianhelle/bugfix/sqlce40-fileloadexception
  • ee348823f1ff263d99c6ab08a46e1564e9a048d3 Enable <loadFromRemoteSources> to avoid FileLoadException when running using the portable binaries
  • 869e4ef888a5a72196fe1c8d3ea65080c668f6f2 Rename source code folder to Source
  • 07c260579054277159b55167594b9214cf29a1fa Remove legacy .hgignore file from Mercurial
  • 6ab1685eea86de4f26859ac56cc125872ff952b4 Add latest release download links to README
  • 054d39c942ee9a1d7fd463f49cf925d0365be450 Fix README file
  • 1fb9810b6236ed55e2c9fbd70821e8574d29930d Create README.md
  • 66c7fe160336fe7eae07dab8361d08a6bd5f44ea Add Windows Explorer file drag and drop support to load SQL query files or any text files into the Query text editor
  • 90f316308467cd60a27e96a907fea5438def9b5d Fix missing files during debugging
  • 12f9b3e0d99fce9ab1feec9ef709c4f1d832af1e Display the resulting row count and execution time when executing SQL statements
  • fd10a342c38d3b099e99a27a8f46dbe20fd92ac3 Create Visual Studio 2012 solution
  • 328940234886c9a39de6626677487327f66d4b55 Resolve dependency issues
  • a44278f1bc3bee101882b6d6f7c5aec63d808a58 Update SQLCE 3.5 dependencies to SP2 build 8109

This list of changes was auto generated.

1.0.2

7 years ago

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