locked
Email Sync RRS feed

  • Question

  • Hello all

    Completely new to SQl compact and sync services.

    1. Is it possible to sync (say 5 updates/inserts) over a very low bandwidth(9-32k)/high cost line - (mainly one way)?

    2. Is it possible to use sync services to sync though an email attachment, client to server ?

    Look forward to your response,

    Thanks

    Kce

     

    • Moved by Max Wang_1983 Friday, April 22, 2011 10:57 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Tuesday, April 17, 2007 4:17 AM

Answers

  • Thanks Rafik,

    1. Any statisics anywhere on 'compact' replication time/size/bandwith, is it much leaner than standard SQL?

    2. Thanks thats a great idea

    Kce

    Thursday, April 19, 2007 2:41 AM
  • May I jump in ? :-)

    Sorry Kce we don't have the perf numbers for sync with slow link yet at this moment. but this is on our task list.

     

    but you are roughly estimate it, by adding time_to_create_the_dataset_set on client, + time_on_transpost_layer ( in this case via the slow link) + time_to_apply_the_dataset on server.

     

    thanks

    Yunwen

    Thursday, April 19, 2007 2:38 PM
    Moderator

All replies

  • Hi there,

     

    1- It is possible.

    2- Sync Services uses dataset to store content. Putting attachment into dataset is overkill and will explode the data size over the wire. Still, you can use sync services to sync the file path (ftp, or http download location) then your application on the server side can then grab the file; just a thought.

     

    Thanks

    Tuesday, April 17, 2007 3:56 PM
  • Thanks Rafik,

    1. Any statisics anywhere on 'compact' replication time/size/bandwith, is it much leaner than standard SQL?

    2. Thanks thats a great idea

    Kce

    Thursday, April 19, 2007 2:41 AM
  • May I jump in ? :-)

    Sorry Kce we don't have the perf numbers for sync with slow link yet at this moment. but this is on our task list.

     

    but you are roughly estimate it, by adding time_to_create_the_dataset_set on client, + time_on_transpost_layer ( in this case via the slow link) + time_to_apply_the_dataset on server.

     

    thanks

    Yunwen

    Thursday, April 19, 2007 2:38 PM
    Moderator
  • Thanks Yunwen...
    Monday, April 23, 2007 6:14 AM