SQLServerCentral / Discuss Content Posted by Gregory Jackson / Article Discussions / Article Discussions by Author / Keep each reporting instance updated / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 07:02:20 GMT20Keep each reporting instance updatedhttp://www.sqlservercentral.com/Forums/Topic445795-143-1.aspxHi,First, I loved your article.There is one thing that is not clear to me. Do you update each new/updated record twice (once for each Reporting DB)? If so, does this mean you have two reads for each change in the OLTP? How do you manage it? Regards,Ishai.Tue, 22 Jan 2008 03:05:33 GMTishai.green