SyncFramework Best Practices RRS feed

  • Question

  • Greetings,

    I've a requirement to sync between the azure database table and vendor databases. Basically our database tables are the Master copy and whenever there are CRUD operation on our database tables we need to synchronize the vendor database by putting messages on queue.

    My main worries are:

    1. Sync Framework cache database can grow significantly over time i.e. > 4 GB which is greater than max size compace sql can store.

    2. Cost involve.

    3. Does sync framework mirrors the copy of source and destination? What are the alternatives.

    4. Does Sync Framework supports caching on SQL Server 2008 Database


    Could someone please help me with whats the best way to solve this?

    Sunday, October 2, 2011 7:56 AM

All replies

  • what's your vendor database?  what are you referring to as Sync Framework cache database?

    Sync Framework is not a mirroring technology. in fact, it doesnt even sync schema changes. Sync Framework applies incremental changes from one replica to another.  the replica's are accessed via providers (SqlSyncProvider, SqlCeSyncProvider, etc...). You mentioned putting messages on a queue, afaik, there is no OOTB provider that works with queues so you will have to write your own.

    can you elaborate on what you refer to as caching support in item 4?

    Sunday, October 2, 2011 12:24 PM