Need help
I would like to use Sync Framework only for Uploads to the central server database .
Steps
1.I have provisioned the master database with one scope and one table(TableA)
2.Created a copy of the master database using SMO methods.
3.Populated records in the Sync table(TableA) using sqlbulk insets with complex query for the filtering .
4.Provision the local database with the scope that created in step 1.
Problem:
When I sync the local DB with the master using Upload option it's show that is uploaded x records, but when I query the central database the records not there.
However when I use the filtered scope option and download the records via sysnc process, and then create a new records in the provisioning table(TableA) and uploading back to the server works fine.
I would like to using the sync Framework for Uploads only .
Populating the client table with data using my custom method because the schema very complicated and I need to write a complex query in order to get a filtered subset of data for the scope table(TableA).
I have to repeat this steps many time for all client databases (300).
Could you please advice how to achieve this using Sync Framework and why when I am uploading the records looks like they are uploaded but in fact they are not.
Thank you in advance
sqladmin
