Opening SQL Server Compact Files

Today I am taking a look at some code someone else developed.  They used SQL Server Compact database files (.sdf), which I have read about but never personally used.  I went on a little journey to simply open the file and see what is inside.

Of course, my first assumption was, “Use SQL Server Management Studio.”  Alas, the file would not open in neither SSMS 2008R2 nor SSMS 2010.  After Googling for a little bit, I realized Visual Studio was the place to go.  All I needed to do was install the SQL Server Compact Toolbox:

  • Open Visual Studio 2010
  • Click Tools >> Extension Manager
  • Click Online Gallery and search for “SQL Server Compact”
  • Click “SQL Server Compact Toolbox” and Download
Then, to open the .sdf file, I had to
  • Go to the Server Explorer section
  • Add a new connection
  • Change the data source to Microsoft SQL Server Compact X.X (in my case 3.5 worked)
  • Find the database using “Browse” and test the connection
And there it was!  Now I can explore the data tables as I expected to.  Now to see how this program works…

66 thoughts on “Opening SQL Server Compact Files

  1. Pingback: mejaqq
  2. Pingback: agen qiuqiu99
  3. Pingback: Mature Webcams
  4. Pingback: mix master
  5. Pingback: dadupoker
  6. Pingback: pasar poker
  7. Pingback: musim qq
  8. Pingback: rajawaliqq
  9. Pingback: wire qwest
  10. Pingback: sales skills
  11. Pingback: navigate here
  12. Pingback: Amazon New World
  13. Pingback: klikdokter dot com
  14. Pingback: Andrea
  15. Pingback: Amina
  16. Pingback: Emily
  17. Pingback:
  18. Pingback: link w88
  19. Pingback: rajaqq
  20. Pingback: boyaqq
  21. Pingback: Buy CBD Products
  22. Pingback: pop over here
  23. Pingback: natural viagra
  24. Pingback: viagra otc
  25. Pingback: viagra
  26. Pingback: sildenafil citrate
  27. Pingback: cialis generic
  28. Pingback: generic cialis
  29. Pingback: buy viagra
  30. Pingback: chloroquine aralen
  31. Pingback: viagra online
  32. Pingback: levitra generic
  33. Pingback: pure cbd
  34. Pingback: viagra
  35. Pingback: viagra pills
  36. Pingback: cialis 10mg
  37. Pingback: cialis otc
  38. Pingback: viagra generic
  39. Pingback: viagra substitute
  40. Pingback: viagra vs cialis
  41. Pingback: accidental viagra

Leave a Reply

Your email address will not be published. Required fields are marked *