InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 16:45:40 GMT20http://www.sqlservercentral.com/Forums/Topic1048369-2795-1.aspxI read the article about Incremental Data Loading using CDC - but can you create an article and demo step by step on how to capture changes from a bulk load and incremental load from a source that [b]does not [/b] have CDC (like SQL Server 2005). most of my tables don't have datetime column so I don't know if the record is new or updated by using datetime alone. Can you help me?I need to do a bulk load initially from 3 servers merged into one server database and perform incremental updates realtime or each night.Mon, 05 Mar 2012 13:42:09 GMTJOHNSON4INFOhttp://www.sqlservercentral.com/Forums/Topic1048369-2795-1.aspxthanks, Mark!Mon, 17 Jan 2011 11:52:04 GMTcasinc815http://www.sqlservercentral.com/Forums/Topic1048369-2795-1.aspxcasinc815,The links are at the beginning. They are: [url=http://www.sqlservercentral.com/articles/FULL+JOIN/71136/]Article 1[/url] and [url=http://www.sqlservercentral.com/articles/Replication/71570/]Article 2[/url].-MarkMon, 17 Jan 2011 10:56:09 GMTmarkoos1http://www.sqlservercentral.com/Forums/Topic1048369-2795-1.aspxMark:Great article. Nice clarification and demonstration of CDC.It has often been a problem explaining to programmers theintent of CDC and to execute the project correctly.One note, there are no footnotes to your previsous two article.For completeness in discussing CDC, can you either post or sendthem to me.Thanks!Mon, 17 Jan 2011 07:29:14 GMTcasinc815http://www.sqlservercentral.com/Forums/Topic1048369-2795-1.aspxgot knowledge of incremental data loading thanks for the postMon, 17 Jan 2011 05:54:37 GMTSree Arjun Divhttp://www.sqlservercentral.com/Forums/Topic1048369-2795-1.aspxNice article, thanks for sharing.Mon, 17 Jan 2011 05:49:47 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1048369-2795-1.aspxHi Mark,Thanks for writing this article it was interesting to see a different way of implementing CDC incremental loading. I have also implemented an incremental load using CDC and I found that the really important part is ensuring synchronisation between the data warehouse tables and the tracked tables. You mention a couple of methods for resynchronisation in your article and I have an additional method which works quite reliably for me which I thought you might be interested in.In my solution I have a SQL replication step between the production OLTP and the data warehouse. This gives me control over the data flow into the monitored tables and allows me to pause replication apply changes to the data warehouse. Once finished I can then restart the data flow and CDC monitoring without losing any of the change data. This of course requires the replication subscriptions to be setup not to expire during the stoppage.CheersMartinMon, 17 Jan 2011 03:40:42 GMTsqlserver-1064800http://www.sqlservercentral.com/Forums/Topic1048369-2795-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/CDC/72020/">Incremental Data Loading Using CDC</A>[/B]Sat, 15 Jan 2011 13:23:27 GMTmarkoos1