I am using Sync framework 2.1 for synchronization between sql server express 2008r2 and sql server express2008r2.
When I am testing I found following positive and negative results
Positive results
I am able to sync
1.newly inserted data from the server to client.
2.Updated data from the server to client.
3.deleted data from the server to client.
Negative results
1.If I add new field to the server, the new field will not add automatically to the destination.
2.Even if I add manually to the client, that particular field not synchronize automatically.
3.If I deleted a row from the client manually and sync again, server supposed to insert a deleted record. But it's not inserting
Question
1. What would be solution for the above negative results.
2. Will Synchronization framework support SQL express to express or we need to use SQL server to SQL server express.
3.How many client we can use maximum. Is there any official documents available for sync framework 2.1
regarding limitations
Your Help will be appreciated.
Thanks
Devaraj Diraviyam