SdfBrowser

Handling databases and performing tasks involving the data included in those containers requires solid knowledge in that area and also a set of dedicated tools to get the job done without too much efforts.
When having to deal with a particular type of files of this kind, like Microsoft SqlServer Compact databases for example, you would need a utility like SdfBrowser to create and execute queries, analyze the structure of the database and migrate the data onto your PC.
Through a very clean interface, this program will make it possible for you to open the supported files (SDF databases), make and run the queries you want. A great thing about this application is that it will allow you to run several concurrent instances by opening several windows and loading the necessary files inside each of them.
For every database you open, SdfBrowser enables you to view its detailed properties inside a dedicated window which organizes the information in the corresponding columns and rows. When it comes to generating queries, the software has in store four different types, more precisely 'Select', 'Insert', 'Update' and 'Delete'.
Generating data definition language (DDL) statements is a couple of clicks away because SdfBrowser is equipped with a tool for this job. Other actions that are supported by this utility include database dump, exporting selected data or compacting the database that is currently loaded.
Insofar as creating SDF databases is concerned, this program supports two types, namely 3.5 and 4.0 compatible files. In case the loaded item originates from an earlier version, there is a function to help you upgrade it on the spot.
Since it is a highly specialized software solution, SdfBrowser is mainly addressed at professionals, but regular users who have some experience in working with such databases should have no problems in getting to terms with this application.