I have a SQL database on a server machine. I have some clients using MSDE that need a local copy of a big table. Every day there are small changes to the big table. What is the fastest way using c# to get the user's local copy in sync with the server copy?
The table is about 200MB. So I need to optimize the internet traffic as well.