Posted: Fri Mar 03, 2006 3:48 am
Kumar_s,
I'm not doubting the use of change capture, BUT:
easy setup using change capture would be: extract target(before), extract source(after), go trouch change capture, apply changes.
From my oracle experience(so again not sure if relevant on sql-server) even if you have exactly the changes it is faster to truncate and reload then to apply more then 10% inserts/updates(mainly the updates offcource).
So if you add the extract to this(before image) it only gets worse(maybe not much, but worse none the less).
I'm not doubting the use of change capture, BUT:
easy setup using change capture would be: extract target(before), extract source(after), go trouch change capture, apply changes.
From my oracle experience(so again not sure if relevant on sql-server) even if you have exactly the changes it is faster to truncate and reload then to apply more then 10% inserts/updates(mainly the updates offcource).
So if you add the extract to this(before image) it only gets worse(maybe not much, but worse none the less).