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:
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
Just thanks for sharing it.
I'm searching for a thing like this. :)
You could also use SDF Viewer to quickly browse your sdf file, edit the data and structure.
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.
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.
Nice post very helpful
dbakings
Post a Comment