CompactView

CompactView is a very lightweight application especially designed to help you open and view Microsoft SQL Server Compact Edition database files.
It’s easy to install and requires no configuration of whatsoever as you are simply taken through a step by step wizard. No hassle and no time spent in a useless manner.
CompactView displays a more than comprehensive interface. You get a main window that consists of two sections, a tree viewer for the database and a larger ‘Data’ and ‘SQL Schema’ window. From them you are able to view all the information you need in a straightforward way.
The first allows you to view the distribution structure of the database, while the second provides you with a detailed view of the content. You can view for example properties and values for the locale identifier, encryption mode, tables, indexes, table and foreign containers.
You can also view a database schema, which describes to you the structure of the file and shows you how data is organized. CompactView allows you to import and export the content you want in a few simple steps. It’s possible to choose whether you want to export all the information, only schema or just data in SQL or TXT format.
CompactView offers you the possibility to upgrade the database to a different version, as well as compact, shrink, repair and verify it. All of these are one click processes which make the application not only practical but also time efficient.
In closing, if you’re looking for a simple and efficient way to view SDF files, then you should try CompactView.