• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

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!
0
OptionsMM
Asked:
OptionsMM
2 Solutions
 
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now