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…

453 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: www.rajaqq1.club
  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
  58. Pingback: rxtrustpharm.com
  59. Pingback: ceftin 500 mg otc
  60. Pingback: buy celebrex 200mg
  61. Pingback: cheap cipro 250 mg
  62. Pingback: claritin coupon
  63. Pingback: online casino usa
  64. Pingback: gambling games
  65. Pingback: slot games
  66. Pingback: au cialis
  67. Pingback: 5mg cialis
  68. Pingback: au cialis
  69. Pingback: payday loans pa
  70. Pingback: installment loans
  71. Pingback: generic cialis
  72. Pingback: viagra stock price
  73. Pingback: 5mg viagra
  74. Pingback: cbd oil sale
  75. Pingback: how to buy clomid
  76. Pingback: coreg 25 mg pills
  77. Pingback: compazine 5 mg nz
  78. Pingback: order cialis uk
  79. Pingback: coumadin 1 mg cost
  80. Pingback: sildenafil rxlist
  81. Pingback: cozaar medication
  82. Pingback: essay help
  83. Pingback: cymbalta 60 mg otc
  84. Pingback: cheapest ddavp
  85. Pingback: depakote otc
  86. Pingback: order diamox 250mg
  87. Pingback: order diltiazem
  88. Pingback: doxycycline uk
  89. Pingback: elavil price
  90. Pingback: etodolac pills
  91. Pingback: order flomax
  92. Pingback: cost of imdur
  93. Pingback: tadalafil pills
  94. Pingback: cheap imodium
  95. Pingback: helpful resources
  96. Pingback: how to buy imuran
  97. Pingback: lamisil prices
  98. Pingback: levaquin australia
  99. Pingback: luvox for sale
  100. Pingback: macrobid uk
  101. Pingback: periactin generic
  102. Pingback: phenergan cheap
  103. Pingback: plaquenil tablet
  104. Pingback: procardia for sale
  105. Pingback: proscar tablets
  106. Pingback: protonix coupon
  107. Pingback: cheap pulmicort
  108. Pingback: remeron tablet
  109. Pingback: how to buy revatio
  110. Pingback: robaxin 500 mg nz
  111. Pingback: cheap tenormin
  112. Pingback: valtrex purchase
  113. Pingback: voltaren pharmacy
  114. Pingback: zanaflex tablet
  115. Pingback: YOURURL.com
  116. Pingback: find more info
  117. Pingback: zocor 40mg tablet
  118. Pingback: zyloprim tablet
  119. Pingback: zyprexa australia
  120. Pingback: tadalafil otc
  121. Pingback: furosemide tablet
  122. Pingback: aripiprazole usa
  123. Pingback: fexofenadine usa
  124. Pingback: tadalafil 5mg
  125. Pingback: donepezil price
  126. Pingback: irbesartan prices
  127. Pingback: citalopram pills
  128. Pingback: clindamycin tablet
  129. Pingback: cost of clozapine
  130. Pingback: cost of oxybutynin
  131. Pingback: bisacodyl generic
  132. Pingback: venlafaxine coupon
  133. Pingback: 141genericExare
  134. Pingback: erythromycin usa
  135. Pingback: 141generic2Exare
  136. Pingback: nchlsfcu
  137. Pingback: buy cialis 36 hour
  138. Pingback: estradiol 1mg nz
  139. Pingback: etodolac canada
  140. Pingback: dfqcclvk
  141. Pingback: alendronate cheap
  142. Pingback: buy isosorbide
  143. Pingback: comprar cialis
  144. Pingback: buy cialis
  145. Pingback: viagra
  146. Pingback: my essay writer
  147. Pingback: indomethacin cost
  148. Pingback: terbinafine cost
  149. Pingback: lasix to buy
  150. Pingback: priligy reviews
  151. Pingback: diflucan prices
  152. Pingback: 300mg neurontin
  153. Pingback: paxil fatigue
  154. Pingback: paxil viagra
  155. Pingback: buy cialis drug
  156. Pingback: buy insurance
  157. Pingback: viagra retinopathy
  158. Pingback: cialis generique
  159. Pingback: herbal viagra
  160. Pingback: tadalafil generic
  161. Pingback: canadian viagra
  162. Pingback: cialis europe
  163. Pingback: viagra overnight
  164. Pingback: tadalafil natural
  165. Pingback: viagra patent
  166. Pingback: diclofenac
  167. Pingback: viagra 25mg cost
  168. Pingback: Gyne-Lotrimin
  169. Pingback: priligy for copd
  170. Pingback: order viagra
  171. Pingback: canada viagra
  172. Pingback: zoloft hot flashes
  173. Pingback: sildenafil online

Leave a Reply

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