Table Synchronization

• Subhash-63067

  SSCarpal Tunnel

  Points: 4171

  More actions

  January 21, 2004 at 10:06 pm

  #162956

  Hai all

  I need to synchronize a table in my local machine to a table in my production server through intranet, can anybody suggest a good method for doing this ?i need to transfer only changes to the local table  after the last synchrnizationsubhash

  
  subban

• chrisyxu

  SSC Rookie

  Points: 42

  More actions

  January 23, 2004 at 7:13 am

  #491345

  How about Replication?     ---chris

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737892

  More actions

  January 23, 2004 at 10:07 am

  #491415

  Do you have a datetime stamp of some sort?

  Or you could use triggers to capture info in another table and process that table to update production.

   

• Subhash-63067

  SSCarpal Tunnel

  Points: 4171

  More actions

  January 23, 2004 at 9:20 pm

  #491491

  Steve,

  i don't have any timestamp...

  But if i use triggers, the thing is that these two table are in two different serverers physically located in different palce over an intranet

  I am trying with replication....

   

   

  
  subban