Easy Sql question

Hi experts!

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.

Thanks!
OptionsMMAsked:
Who is Participating?
 
msdixonCommented:
you could add a LastUpdated column to the table with a trigger that updates the field every time it's updated, and in your msde copy create a lookup table (TableUpdates for instance) that includes the table name and last successfull update time. only get the records that were updated after the last update in the TableUpdates table.
0
 
Éric MoreauSenior .Net ConsultantCommented:
See BOL for Replication
0
 
TheAvengerCommented:
Just make a replication between the servers. The problem is that you have to configure every local MSDE separaterly...
0
 
KelmenCommented:
Can the replication be setup through a installation setup? like a .msi?
0
 
TheAvengerCommented:
I don't think so....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.