Jump to content
Sign in to follow this  

.sdf file

Recommended Posts

Hi friends...


How to open .sdf file of database..


I have tried using sqlserver compact 4 , there was no success..


can anyone plz describe me...



Share this post

Link to post
Share on other sites

there are many format related to SDF, like autodesk sdf or sdf  for sql server compact edition


so which one your SDF?


if those are Autodesk' sdf then you can open with FDO tools or autodesk product like autocad map or Mapguide, but if those file is sql server compact edition then you can use sql server management studio , download here :


so can you explain in detail?

Share this post

Link to post
Share on other sites

Sql server compact database file


Can you plz mention the steps....


I have tried to open using sqlserver compact but there was no success :(

Edited by adnan0001

Share this post

Link to post
Share on other sites



Try LINQPad, it works for SQL Server, MySQL, SQLite and also SDF (SQL CE 4.0). Best of all it's free!

Steps with version 4.35.1:


  1. click 'Add Connection'

  2. Click Next with 'Build data context automatically' and 'Default(LINQ to SQL)' selected.

  3. Under 'Provider' choose 'SQL CE 4.0'.

  4. Under 'Database' with 'Attach database file' selected, choose 'Browse' to select your .sdf file.

  5. Click 'OK'.

  6. Voila! It should show the tables in .sdf and be able to query it via right clicking the table or writing LINQ code in your favorite .NET language or even SQL. How cool is that?


  • Like 1

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.