Re: Monitor Transaction log

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Chris Wagner (so_at_hotmail.com)
Date: 05/28/04 

Date: Thu, 27 May 2004 22:54:31 -0700

Not really a publication but a simple monitoring tool to update another app
if anything changes on the SQL or Oracle (depends on each app). All I need
is only a few tables (for update, insert, and delete) and monitor the change
log so I can see what changes and update other apps. Please advice. Thanks

"William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
news:%23k$$fZHREHA.628@TK2MSFTNGP11.phx.gbl...
> If I understand you correctly, ADO.NET is probably not the way to go on
> this
> one. Are you trying to build your own Publication? Yikes.
>
> If so, what's the extent to what you need it to do?
>
> --
> W.G. Ryan MVP Windows - Embedded
>
> http://forums.devbuzz.com
> http://www.knowdotnet.com/dataaccess.html
> http://www.msmvps.com/williamryan/
> "Chris Wagner" <so@hotmail.com> wrote in message
> news:e7f4cMHREHA.132@TK2MSFTNGP09.phx.gbl...
>> Is there a way to monitor transaction log in SQL server and Oracle server
>> using .NET? I'd like to write in VB.NET to mimic the SQL server
> replication
>> (transactional publication) to use against SQL and Oracle to monitor some
> of
>> the tables. Please advice. Thanks
>>
>>
>
>

Relevant Pages

  • Re: Off Topic - Access to Postgres
    ... In both Jet and Oracle back ends, I always write my SQL dynamically anyway and contrary to what I think you implied in your initial response to Hank, I don't think writing Jet SQL (for Jet BE or c/s linked table approaches) nor PTQ SQL in VBA makes an app more difficult to manage or increses development time significantly. ...
    (comp.databases.ms-access)
  • Re: Oracle jdbc perf on linux and windows
    ... Since use of SQL introduces problem, I would first try to eliminate ... Oracle as the culprit. ... If it's in your app, ... TCPDUMP will help if your app is running on the same system because ...
    (comp.lang.java.programmer)
  • Re: Monitoring and tuning database performance
    ... > used to monitor and tune database performance in Oracle. ... > experience of doing this in MS SQL Server, but not in Oracle. ... SQL is the only/best choice. ...
    (comp.databases.oracle.server)
  • ROW-00054: Cannot load the library
    ... This is an app that I haven't touched in 2 years and now they want a change. ... The specified module could not be found'. ... This is a D7 app using Oracle. ... I can issue the same SQL through PL/SQL developer as the same user and all ...
    (borland.public.delphi.database.ado)
  • Re: prevent developer writting to our SQL DB ?
    ... I deal with ORACLE, but SQL should work the same way: ... Only my app knows ... Just wondered if I could prevemt ...
    (microsoft.public.vb.general.discussion)