SQL 2000/2005 Transaction Log Reader Library

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Feris T
    #1

    SQL 2000/2005 Transaction Log Reader Library

    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
    Tags: None
    • Hugo Kornelis
      #2
      Re: SQL 2000/2005 Transaction Log Reader Library

      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

        Comment

        • Erland Sommarskog
          #3
          Re: SQL 2000/2005 Transaction Log Reader Library

          Feris T (feris@phi-integration.com ) writes:
          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. Is there
          any other workaround with SQL Server 2000/2005 ?
          It's difficult to say that something is accurte, when it is not supported.

          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.


          --
          Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

          Links for SQL Server Books Online:
          SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
          SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
          SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

            Comment

            • Feris T
              #4
              Re: SQL 2000/2005 Transaction Log Reader Library

              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

                Comment

                • Feris T
                  #5
                  Re: SQL 2000/2005 Transaction Log Reader Library

                  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

                    Comment

                    Previous template Next
                    Working...