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: [email protected]<mailto:[email protected]> 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:[email protected]] 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]
