title: Live sync between SQL Server 2008 R2 and MongoDB with Express
body: <p>I have created custom script in Express that actually migrates SQL Server database to MongoDB.</p>
  
  <p>But I am facing problems in live syncing between the two databases.</p>
  
  <p>Currently I have added a column <code>updated_by</code> in both the databases.</p>
  
  <p>Then I fetch the latest <code>updated_by</code> row from MongoDb and SQL Server database.</p>
  
  <p>Then I check the date difference and based on it I update my MongoDB database.</p>
  
  <p>There are lots of db tables and I am finding it difficult to identify that, which table is being updated.</p>
  
  <p>Is there any log in SQL Server 2008 R2 that states which table is updated and at what time?</p>
  
  <p>I need a mechanism like, any data update in the db table should immediately sync that rows into my MongoDB.</p>
  
  <p>Any more suggestions on live data syncing is also welcome.</p>
  
  <p>Thanks in advance. :)</p>