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…

126 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
  42. Pingback: viagra pills
  43. Pingback: viagra buy
  44. Pingback: female viagra buy
  45. Pingback: buy Viagra 25 mg
  46. Pingback: Viagra 100 mg uk
  47. Pingback: viagra for sale
  48. Pingback: Viagra 50 mg nz
  49. Pingback: Cialis 10mg online
  50. Pingback: Cialis 10mg cheap
  51. Pingback: RxTrustPharm
  52. Pingback: lasix 100mg pills
  53. Pingback: buy abilify 20 mg
  54. Pingback: allegra 120mg nz
  55. Pingback: antabuse 250 mg nz
  56. Pingback: rxtrust pharm
  57. Pingback: benicar 10 mg otc

Leave a Reply

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