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…

41 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

Leave a Reply

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