Search the Community

Friends, This may be useful to someone. This is a GUI tool that allows me to quickly access data from SQL Compact (SQL CE) (*.sdf) database files. My testing automation generates many such database files, and it's been handy. SQL CE is a very lightweight database system that was originally written for phones etc. To register the tool to open .sdf files, from the command line, type SQLCETool /i to unregister it, from the command line, type SQLCETool /u Once registered, there are several ways to run the tool. if the tool is up, you can drag a .sdf file from explorer to the "SDF File" edit box, click on the open button. The tables in the database will then be listed. Select a table, and its contents will be displayed. Or paste the fully qualified name of the database and click open, etc. If the focus is on another application, the tool rolls up. If the mouse is hovering on the rolled up tool, it will return to its normal size. Enjoy! And for this to properly read databases, you will need to have SQL CE installed. This is hard coded to use version 4.0, though just changing the database connection string to use another version should work fine. 1/12/2012 (2nd link below): added commandline input of queries so that the tool can be called and directly display the query; fixed a bug that caused flickering; changed handling of Escape or F5 key press so that it's only used if the tool has the focus; updated handling of database errors. SQLCETool.au3 SQLCETool.au3