locked
Meta data Store Other Than SQL CE RRS feed

  • Question

  • Any guidelines on building Metadata Store in SQL Server 2005.

     

    We like the Meta data Storage Capabilities that are there in SQL CE. In place of using SQL CE as the Meta data Store, can we use SQL 2005.

    Can we extend ItemMetadata Replica Metadata and MetadataStore from the libraray Microsoft.Synchronization.MetadataStorage to create our own ?

    Thursday, April 17, 2008 6:49 AM

Answers

  • The sync solution can use any store (file based, db based etc) as the sync metadata store if it can support harmoinca required metadata correctly and efficiently.

     

    Currently the sync framework ships a SQL CE based metadata store component, though the idea of using other SQL Server store has been considered but it's not available at this moment.

     

    The  Microsoft.Synchronization.MetadataStorage assembly is a managed wrapper of metadata store compoment implemented in native COM, so ultimately it's still using SQLCE as the store. There is no way to work around this implementation.

     

     

    Thursday, April 17, 2008 5:53 PM
    Answerer

All replies

  • The sync solution can use any store (file based, db based etc) as the sync metadata store if it can support harmoinca required metadata correctly and efficiently.

     

    Currently the sync framework ships a SQL CE based metadata store component, though the idea of using other SQL Server store has been considered but it's not available at this moment.

     

    The  Microsoft.Synchronization.MetadataStorage assembly is a managed wrapper of metadata store compoment implemented in native COM, so ultimately it's still using SQLCE as the store. There is no way to work around this implementation.

     

     

    Thursday, April 17, 2008 5:53 PM
    Answerer
  • Thanks for the Insight.

    It would be really helpful, if any guidance could be provided as for the way to proceed if we want to, implement our meta data store using MS SQL Server 2005.

    Specically,
    The Components, we need to build, if we want to achieve the same functionality that SQL CE provides currently.


    Regards,
    Sanket



    Friday, April 18, 2008 6:05 AM