Hi fellow Firebird users,

Background:

* Current Firebird version is 2.5

* Windows OS could be anything...

* We are using C# with FirebirdClient ADO.NET Data Provider

* The software we write extracts and monitors the Firebird database of a third party application.

* We do a major extract of data from the Firebird database, then attempt to monitor for changes.

Comment:
It appears to be very difficult for us to monitor the Firebird database for changes. We have started to look into the Trace functionality introduced in Firebird 2.5 to monitor for changes. This has helped, as we can relatively easily detect what tables have changed from the Trace output. But this involves a lots of string parsing, which is really not nice.

We have just started to look into other software like FbTraceManager to help us, which appears to be a great tool for debugging issue, but I can't work out if there is a way to integrate FbTraceManager into an existing application to programmatically access the structured trace data.

I've come across some slideshows on Auditing (different from Trace?) that make it sound like there is other functionality there, but maybe not documented?

Question:
Is there any way to detect table and row level changes, that could be integrated into an existing C# application? Identifying the changed row IDs in a table that has changed would be ideal...


Cheers,
Richard (Sandy) Currie
Senior Software Developer - Topbar Team Lead
Available Monday - Friday

Direct: 03 9866 8477
Email: richard.currie@...<mailto:richard.currie@...>
Skype: Richard.currie.pencs

Pen CS Pty Ltd
smart. secure. connected.

Level 1, 35 Moore Street
LEICHHARDT NSW 2040
Phone: 1800 762 993
Fax: 02 9566 1182
www.pencs.com.au<http://www.pencs.com.au/>

HELP DESK FREECALL 1800 762 993

[cid:image001.png@01D0CAD9.6FF8E180]

Please consider the environment before printing this email

CONFIDENTIALITY this email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to another person use it for any purpose or store or copy the information in any medium. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Pen CS Pty Ltd. If you have received this email in error please notify us immediately


______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________

[Non-text portions of this message have been removed]