locked
Regarding Sync Framework 2.1 RRS feed

  • Question

  • Hi,
    I have used Microsoft Sync Framework 2.1 in my application for sync data
    with SQL server, one main Server and multiple client.

    In my application having two buttons 1. Upload 2. Download,
    Clients can download all data from Download button and upload from Upload button.
    Requirement:
    1)
    how to give permissions to client with filtered data to upload.
    ex.
    We have 100 SQL tables,
    Customer table have 1000 records,
    A)I gave permission to "special customer"  to upload (Every table has different condition to upload data).
    Customers which having Type "special customer" with data of 100 record
    will be uploaded,
    now new 20 "special customer" are added, so this new data will also upload.
    B)suppose I gave permission of new type of customer "VVIP Customer".
    Customers which having Type "VVIP Customer" with data of 200 record
    will be uploaded,
    now new 40 "VVIP Customer" are added, so this new data will also upload.
    2)If new column added in Customer table or column removed from Customer table.
    so this changes will also added in Sync Framework
    3)If new table added in database,
    so this changes will also added in Sync Framework
    4)It takes lot of time to download and upload from
    Sync Framework in my application, so how to reduce time for performance.
    please give suggestion for above scenario.
    Thanks,
    Akshat
    Thursday, April 18, 2019 11:46 AM