On Wed, 3 Sep 2008 06:11:43 -0700 (PDT), Feris T wrote:
>Hi Hugo,
Thanks for the feedback. Actually I want to do incrementally update to
my data warehouse project using Java ETL tool. Since data capture
change using log is the most accurate I prefer this method.
Hi Feris,
I don't know who told you that data capture change using log is the most
accurate, but he was either not talking about SQL Server but about some
other database, or flat out wrong. (Or both). Microsoft has never
released documentation about the format of the log file, and there are
no libraries available for this.
Is there
any other workaround with SQL Server 2000/2005 ?
Probably, but since I'm unfamiliar with both data warehousing and with
ETL tools, I suggest you to post a new question. Probably best in a more
specialised newsgroup, such as microsoft.public.sqlserver.datawarehouse.
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog:
http://sqlblog.com/blogs/hugo_kornelis