Excelent article. One of the best that I have ever read in SQL Server Magazine.

Anonymous User 9/1/2005 7:08:51 PM

Nice article, but... In real life, the OLTP system is a 'given', which means that your are never allowed to create triggers and extra logtables on the production server. In real life, the OLTP system is often running on a different platform than Win/SQL. In real life, dimension tables tend to be quite large (+1 Mln records for a customer dimension is not exceptional). So in this situation, you cannot determine whether a source record is an insert, delete or update from a log table but first you have to match it against the target table. It would be interesting to see how you think DTS can help here. For instance, recently I had to develop a solution using DTS to keep Navision C/Side transaction tables (GL postings) in sync with a 'replica' on SQL Server. The only (?) way to accomplish this was using an ActiveX Script task.

Jos van Dongen 9/11/2002 2:12:31 PM