title: Using C# to Sync two tables in different databases
body: <p>I have a remote Postgresql DB with a table (which I can not alter) that contains information (just a few columns not the entire table) I want to sync to a local SQL Server 2008 Express database with a table (which I can alter).</p>
  
  <p>Now I'm looking for an efficient way to do this. Since the sync will run every ~5 minutes reloading the entire table every time would produce alot of unnecessary traffic I'm trying to avoid.</p>
  
  <p>I thought about saving the most recent ID and just grabing everything that's newer, but it is possible (not likely but still possible) that the older data gets altered. Just going this way  I would miss out on the altered data.</p>
  
  <p>The sync will be done by a C# program running on the same machine as the local SQL Server.</p>