|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server 2K transaction logHi here,
I am a developer, not DBA, and we need to develop an in-house tool to update database records at remote site. I understand we can use replication. However, it does not work as we like and does not suit our need. Therefore, I believe transaction log is our answer. My Q is that does any third party library (control or dll) to "decode" the transaction log? Any idea?? -- cheers, RL ApexSQL has a Log product that would be perfect for what you need. Lumigent
has an outdated one as well, and I think Red Gate is playing in that space too. Apex is the only one that I know of that is SQL 2005 capable however. -- Show quoteTheSQLGuru President Indicium Resources, Inc. "Egghead" <robertlo@NO_SHAW.CA> wrote in message news:OipSAx9kHHA.3512@TK2MSFTNGP06.phx.gbl... > Hi here, > > I am a developer, not DBA, and we need to develop an in-house tool to > update database records at remote site. I understand we can use > replication. However, it does not work as we like and does not suit our > need. Therefore, I believe transaction log is our answer. My Q is that > does any third party library (control or dll) to "decode" the transaction > log? > > Any idea?? > > -- > cheers, > RL > Hi here,
Thanks. We are using SQL 2K. The problem is that those products are application, not library. I need a control or dll to embedding in my application. -- Show quotecheers, RL "TheSQLGuru" <kgbo***@earthlink.net> wrote in message news:unVsCE$kHHA.2272@TK2MSFTNGP02.phx.gbl... > ApexSQL has a Log product that would be perfect for what you need. > Lumigent has an outdated one as well, and I think Red Gate is playing in > that space too. Apex is the only one that I know of that is SQL 2005 > capable however. > > -- > TheSQLGuru > President > Indicium Resources, Inc. > > "Egghead" <robertlo@NO_SHAW.CA> wrote in message > news:OipSAx9kHHA.3512@TK2MSFTNGP06.phx.gbl... >> Hi here, >> >> I am a developer, not DBA, and we need to develop an in-house tool to >> update database records at remote site. I understand we can use >> replication. However, it does not work as we like and does not suit our >> need. Therefore, I believe transaction log is our answer. My Q is that >> does any third party library (control or dll) to "decode" the transaction >> log? >> >> Any idea?? >> >> -- >> cheers, >> RL >> > > ApexSQL Log has a fairly robust command line capability. Send them an email
and see if that will do for you. Also ask if they have or plan to provide an API you can program against. Tell Ivan TheSQLGuru sent you. :-) -- Show quoteTheSQLGuru President Indicium Resources, Inc. "Egghead" <robertlo@NO_SHAW.CA> wrote in message news:O2FYvL$kHHA.4768@TK2MSFTNGP05.phx.gbl... > Hi here, > > Thanks. > We are using SQL 2K. > > The problem is that those products are application, not library. I need a > control or dll to embedding in my application. > > -- > cheers, > RL > "TheSQLGuru" <kgbo***@earthlink.net> wrote in message > news:unVsCE$kHHA.2272@TK2MSFTNGP02.phx.gbl... >> ApexSQL has a Log product that would be perfect for what you need. >> Lumigent has an outdated one as well, and I think Red Gate is playing in >> that space too. Apex is the only one that I know of that is SQL 2005 >> capable however. >> >> -- >> TheSQLGuru >> President >> Indicium Resources, Inc. >> >> "Egghead" <robertlo@NO_SHAW.CA> wrote in message >> news:OipSAx9kHHA.3512@TK2MSFTNGP06.phx.gbl... >>> Hi here, >>> >>> I am a developer, not DBA, and we need to develop an in-house tool to >>> update database records at remote site. I understand we can use >>> replication. However, it does not work as we like and does not suit our >>> need. Therefore, I believe transaction log is our answer. My Q is that >>> does any third party library (control or dll) to "decode" the >>> transaction log? >>> >>> Any idea?? >>> >>> -- >>> cheers, >>> RL >>> >> >> > > Egghead (robertlo@NO_SHAW.CA) writes:
> I am a developer, not DBA, and we need to develop an in-house tool to I am skeptic to that is the right path to go. After replication is dependent> update database records at remote site. I understand we can use > replication. However, it does not work as we like and does not suit our > need. Therefore, I believe transaction log is our answer. My Q is that > does any third party library (control or dll) to "decode" the > transaction log? on the transaction log, so if that does not cut it... I would suggest that you ask the friendly people in microsoft.public.sqlserver.replication for suggestions on how to approach your problem. Obviously, you would have to give more details that what you have given here. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx  |
|||||||||||||||||||||||
Other interesting topics