Search code examples
sql-server-ce

Can't see table contents, etc. for SQL Server Compact Edition tables

I received an application that has a .sdf associated with it. I can connect to the .sdf with Management Studio - and I can see the tables along with the column headers for the table I'm interested in viewing.

However, there's no option to display the table data. Is there a way for me to export the table to Excel or to otherwise view it?

Solution

  • You could open the .sdf file using LINQPad or you could use this nice command line tool for SQL CE.

    There are also other useful add-ons and standalone tools on CodePlex. Check out exportsqlce.codeplex.com and sqlcetoolbox.codeplex.com