What is the metadata file? RRS feed

  • Question

  • I sync 1 SQL Server 2008 to many SqlCe clients ... do I have a metadata file ... and if so, where is it ... and does this apply to me?

    According to http://social.technet.microsoft.com/wiki/contents/articles/sync-framework-tips-and-troubleshooting.aspx:

    A large metadata file can take a long time to send to each client during synchronization. The solution to this is to store the metadata file on each client, rather than just on the server. To do this, specify a local client path for the metadata file when the FileSyncProvider object is created on the client, such as in the following code example:

    FileSyncProvider myClientProvider = new FileSyncProvider("c:\\syncfolder",
    myOptions, "c:\\syncmetadata", null, null);
    Thursday, July 28, 2011 7:38 PM


  • this doesnt apply to your database sync scenario. as indicated in the docs and in the link, it applies to the file sync providers. the metadata in sqlsyncprovider/sqlcesyncprovider is stored in the tables created during provisioning.
    • Proposed as answer by JuneT Thursday, August 11, 2011 2:47 PM
    • Marked as answer by P H T Thursday, August 11, 2011 3:16 PM
    Thursday, July 28, 2011 10:43 PM