Hi,
Is there any development library exist in the market for SQL Server
2000/2005 transaction log reader ? I need to use it for Capture Data
Change (CDC). Preferably Java.
Regards,
Feris
4  4126 
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.publi c.sqlserver.dat awarehouse.
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Hi Hugo,
On Sep 4, 4:57*am, Hugo Kornelis
<h...@perFact.R EMOVETHIS.info. INVALIDwrote:
>
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.
Isn't it ? As the most accurate change for sophisticated database
system is resided in it's log.
>
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.publi c.sqlserver.dat awarehouse.
Yes, I've joined the newsgroup. Thank you for the info.
Regards,
Feris
Our Pentaho wiki : http://pentaho.phi-integration.com
Hi Erland,
On Sep 4, 4:52*am, Erland Sommarskog <esq...@sommars kog.sewrote:
>
It's difficult to say that something is accurte, when it is not supported..
Got your point. Thanks :)
>
There are third-party products out there that read the looks, but I
don't think they come with an API.
If you want to use CDC, I think your best option is to move to SQL 2008
which has such a feature.
It is based on this product that I come to a thinking of the same
workaround solution for previous version. Anyway, thanks Erland for
the update.
>
--
Erland Sommarskog, SQL Server MVP, esq...@sommarsk og.se
Regards,
Feris
Our Pentaho wiki : http://pentaho.phi-integration.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Ringumol |
last post by:
Hi,
We have some console application which runs in background with the
following logical flow :
Main()
{
loop (1..n)
{
CreateThread(Function1)
}
|
by: Neil Rutherford |
last post by:
During testing of an application, i noticed a difference between
SQL 2000 and SQL 7, both with identical config.
In a nutshell:
A table has a trigger for UPDATE and DELETE.
When a column in the table is UPDATED the following happens:
In autocommit mode, when entering a trigger the trancount equals
1 for both SQL 7 and 2000.
|
by: wreed |
last post by:
Our SQL Server 200 box is getting perflib errors when we get a decent
amount of people using an application that I wrote, call queue system,
web based. To accomplish a queue type system on a button push I wrote
a query like this...
BEGIN TRANSACTION;
Select top 1...fields here...
FROM table with (xlock,readpast)
(2 joins)
WHERE numerous where clauses
|
by: Saray |
last post by:
Hi
I deployed my ASP web application with the backend sql server 2000.Now i would like to change from sql serer 2000 to 2005 64 bit machine.
its giving some error like
New transaction cannot enlist in the specified transaction coordinator.
Please advice me.
|
by: bill |
last post by:
Can someone please show me an example of passing a string value into an sql
statement in vb 2005? Something like this is what I'm after:
Dim sqlButton1 As String = "Select * from tblAssets where Asset_Tag =
Me.cboAsset.Text"
Thank you,
Bill
| | |
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
