Wednesday, December 19, 2007

Browsing a .SDF file (SQL Server CE database file)

If you are using SQL Server Compact Editition (SQL Server CE) and are producing .sdf files for use with your applicatoins, it is sometimes desireable to browse through a .sdf file's schema and data. Microsoft provides a nice tool for doing this, the SQL Server Management Studio Express. You must get Service Pack 2 or higher to have the SQL Server CE support.

It will let you select "SQL Server Compact Edition" for your Server Type and you can specify a .sdf file:










You can then browse the database's schema:






And you can perform queries on the data:







You can download the tool from Microsoft:

http://www.microsoft.com/downloads/details.aspx?FamilyID=6053c6f8-82c8-479c-b25b-9aca13141c9e&DisplayLang=en

6 comments:

Anonymous said...

Thanks for providing this information. I am wondering with my old SQL studio Console manager for a long time and spend few hours on SQL server documentaion. After seeing u r post I got to know that issue was mine with older version of MSMS.

Thanaks Dude

MLPY-KER

Mohammad said...

Just thanks for sharing it.
I'm searching for a thing like this. :)

howard said...

You could also use SDF Viewer to quickly browse your sdf file, edit the data and structure.

Knox Dale said...

This file will work as you are working with access file.Only one connection should be available with this file, if you try to connect with another connection simultaneously then it won't work.

Knox Dale said...

This file will work as you are working with access file.Only one connection should be available with this file, if you try to connect with another connection simultaneously then it won't work.

Sudhir DBAKings said...

Nice post very helpful

dbakings