i'm searching for a method to decoce the data saved in sybase databse transaction log file (all querys released towards the databse)
can someone help with this particular?
Ok i acquired the solution the following.
first you have to install SQL anywhere which i'll assume you need to do.
"SQL anywhere install folder\Bin32\dbtran.exe" logName.log logName.log.txt
the finish result would seem like this:
--CONNECT-1045-0016035758-DBA-2011-11-04 01:50 --BEGIN TRANSACTION-1045-0016035769 BEGIN TRANSACTION go --UPDATE-1045-0016036065 UPDATE DBA.FAULT SET COUNT=21407, LAST_OCCURRENCE='2011-11-04 01:50:07.078' WHERE FAULT_ID=735 go --COMMIT-1045-0016036092 COMMIT WORK ...