Monitor Transaction log

  • Thread starter Thread starter Chris Wagner
  • Start date Start date
C

Chris Wagner

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
 
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
 
You can set up a messagequeue and then via trigger for instance, write to
the queue when anything happens. On the client end you can poll to queue
which is much less intensive than querying the db. The new
querynotifications in ADO.NET 2.0 work similarly.

Instead of the queue you could use SQL Servers notification services to send
out a notification that data has changed. This probably won't be practical
for most scenarios unless you are really doing it in a limited scenario.

I know Casey had an example of doing this with Notification services at
www.brains-n-brawn.com .
HTH,

Bill

--
W.G. Ryan MVP Windows - Embedded

http://forums.devbuzz.com
http://www.knowdotnet.com/dataaccess.html
http://www.msmvps.com/williamryan/
 
Back
Top