locked
SQL CE Metadata Locking Control RRS feed

  • Question

  • Let's say we go with SQL CE as our metadata store,

    then what is the kind of locking that is done on meta data, we undersatnd that we specify the Transaction but can we control it be row level or Table level,  during the Sync Session, i.e. it is a complete lock down or is it row level lock on meta data. Is it controllable ? and How? 

     

    Which implies can we initiate multiple Sync Sessions, if we go for a Hub-Spoke deployment model and creating multiple Sync Sessions at the same point of time. If yes, Insights?

    Thursday, April 17, 2008 6:58 AM

Answers

  • The sync provider which uses the sync metastore component needs to define its strategy when to commit transaction. Generally, the sync provider doesn't need to worry about the detailed lock control in the database, just focus on when to commit, for example, you could commit after a change batch is applied.

     

    Currently the metastore component doesn't support concurrent use of a sync replica in the metadata store, which means, if a replica A represented in the current metastore is syncing with a second replica B, it can not sync with a third replica C. A error code or exception will be returned to you saying the replica is in use. This restriction may be relaxed in the future after more considerations.

     

    Thursday, April 17, 2008 6:04 PM
    Answerer

All replies

  • The sync provider which uses the sync metastore component needs to define its strategy when to commit transaction. Generally, the sync provider doesn't need to worry about the detailed lock control in the database, just focus on when to commit, for example, you could commit after a change batch is applied.

     

    Currently the metastore component doesn't support concurrent use of a sync replica in the metadata store, which means, if a replica A represented in the current metastore is syncing with a second replica B, it can not sync with a third replica C. A error code or exception will be returned to you saying the replica is in use. This restriction may be relaxed in the future after more considerations.

     

    Thursday, April 17, 2008 6:04 PM
    Answerer
  • Thanks for a quick and to the point prompt reply.

    Appreciated, Smile

    Regards,
    Sanket
    Friday, April 18, 2008 6:07 AM