none
Problems with Zune database (zunestore.sdf)

    Question

  • Hi, 
    I've been playing around with the Zune mp3 player and the Zune PC software (the iTunes analog, if you will) saves the metadata in a file named ZuneStore.sdf.

    It seems to be a SQL Server Compact file and I can see the various table names when I look at it through an text viewer.

    I'd like to be able to read it, but no tools, neither Microsoft nor third-party apps, have been able to read it. 

    Is there anybody out there with a sufficient knowledge in matter arcane such as this?


    Friday, August 07, 2009 8:51 PM

Answers

  • I can open the Zune database in SSMS 2008, but it is not in a standard SQL Compact format, so cannot run any queries against it. Consider it to be in a proprietary, undocumented, protected format.
    Erik Ejlskov Jensen, MCTS: WM App, MCITP: SQL 2008 Dev - http://erikej.blogspot.com Please mark as answer, if this was it.
    Saturday, August 08, 2009 5:22 PM
    Moderator

All replies

  • If it is a no pwd protected SQL Compact file, SQL Server Management Studio 2005 SP2 or SSMS 2008 should be able to open it.
    Erik Ejlskov Jensen, MCTS: WM App, MCITP: SQL 2008 Dev - http://erikej.blogspot.com Please mark as answer, if this was it.
    Friday, August 07, 2009 9:06 PM
    Moderator
  • I've tried those tools and they didn't recognize the tables inside the file. 

    It doesn't seem to be password-protected or encrypted, since I can see the content quite clearly. 

    But it doesn't seem to recognize this file, even though I've been told that the Zune uses SQL Server Compact, which makes sense. 

    I'd be more than grateful if you could take a look at the file and see why this particular file doesn't want to play nice.

    I'll even send you a new Zune as thanks if you can figure out how to read this .SDF file. 
    Friday, August 07, 2009 9:40 PM
  • You can send me the file, and I will look at it. It resides on your dektop PC, is that correct? Send to ejlskov_at_hotmail_dot_com.


    Erik Ejlskov Jensen, MCTS: WM App, MCITP: SQL 2008 Dev - http://erikej.blogspot.com Please mark as answer, if this was it.
    Saturday, August 08, 2009 9:46 AM
    Moderator
  • For your Information

    I believe (need to confirm) Zune contains SQL Compact 3.1 build (5300). So Zune will only get opened with VS05 or SSMS05 and not VS08 or SSMS08.

    Thanks & regards,
    Devesh Anand


    Please click Yes, if my post was helpful.
    Saturday, August 08, 2009 11:46 AM
    Answerer
  • Thanks! 
    Yes, that is correct. 
    The SDF file is on the desktop PC and the Zune has an EDB file. 
    Saturday, August 08, 2009 4:18 PM
  • I can open the Zune database in SSMS 2008, but it is not in a standard SQL Compact format, so cannot run any queries against it. Consider it to be in a proprietary, undocumented, protected format.
    Erik Ejlskov Jensen, MCTS: WM App, MCITP: SQL 2008 Dev - http://erikej.blogspot.com Please mark as answer, if this was it.
    Saturday, August 08, 2009 5:22 PM
    Moderator
  • Interesting. 
    Well, thanks for the help. 
    Sometimes file extensions aren't what they seem.
    Saturday, August 08, 2009 8:43 PM
  • Dave,

    Were you ever successful in running a query against the zunestore.sdf file?

    Pete

    Sunday, September 27, 2009 10:41 PM
  • Considering the database gets corrupted about once every six months for me and begins crashing when you click the Podcast tab, it would be nice to be able to extract all my podcast feed addresses from the database.
    Thursday, November 10, 2016 3:03 AM