I did Merge Replication by using RMO. Every thing is working fine.. Progressbar, Log Files and the status message , Every thing is working kool in my app. But can we estimate the time ? (time to sync data from server to client or the whole replication process) Regards Bhuvan
If you have the process already set up, you can monitor the times. So set up a test with a known data set, measure that and then extrapolate as necessary. Same way you'd estimate any other time on the system. Do this with the knoweldge that when you have multiple users on the system and there may be resource conention, time estimates could change. If you monitor your servers regularly you should be able to make some predictions in that regard too.
That's going to be really tricky as there are so many things that can vary that will affect replication times - locking transactions, high CPU, network latency, disk I/O, index health and so on... Are you trying to deal with giving the user an estimate of remaining work during replication cycle?