Hi All,
What is the best approach to push new data that got inserted/updated in server side (Server DB: SQL Server 2005/2008, Client DB: SQL CE 3.5)?
- Microsoft Sync Framework
- RDA
- Merge Replication
- Any other approach???
I need to consider the following points
- If the client device is in n/w, push the data to client.
- If client not in n/w, the data should wait in server until it establishes a connection b/w server and client device application.
- Notify the user of client application that the data/message reached.
Can anyone suggest the best approach possible for implementing this?
Regards,
Praveen K