CODEWITHSUNDEEP
sql-server-ce
elbillaf
elbillaf

Reputation: 1984

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?

Upvotes: 1

Views: 688

Answers (1)

Christian Hagelid
Christian Hagelid

Reputation: 8355

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

Upvotes: 1

Related Questions