Where can I find the FileSyncProvider's "metdataFSP.Harmonica" file? RRS feed


  • The following applies to version 2.0 of the Sync Framework:

    I've worked it out - the filename "metdataFSP.Harmonica" is a bit of a red herring. The filename will be whatever you pass in as the metadataFileName parameter of the Microsoft.Synchronization.Files.FileSyncProvider constructor. I'm not sure what the default name and location is as I've only ever used the overloaded constructor that requires you to provide a metadataFileName. I assume it's "metdataFSP.Harmonica" but that seems an unusual name to me?

    It's a SQL Server Compact database and I managed to open mine using SQL Server Management Studio 2008 as well as Visual Studio 2010 Ultimate. I recommend the latter as it lets you query the file more easily.

    Steps I followed to open it in Visual Studio 2010:


    1. Make a copy of the file
    2. Remove the read-only attribute
    3. Change the file extension to .sdf (otherwise Visual Studio 2010 doesn't let you open it)
    4. Open Visual Studio 2010 as an administrator
    5. In Server Explorer, right-click on Data Connections and choose Add Connection
    6. Change the Data Source type to be Microsoft SQL Server Compact 3.5
    7. Browse to the file
    8. Leave the password field blank
    9. Press OK, you will be told it needs upgrading
    10. Leave the password field blank and click OK
    11. You can now view the data in the file though remember that this is just an upgraded copy of the original file


    • Marked as answer by tjrobinson Wednesday, June 9, 2010 2:20 PM
    • Edited by tjrobinson Wednesday, June 9, 2010 2:43 PM Missed a step
    Wednesday, June 9, 2010 2:17 PM