Enhancement Request - Translate a log file

[t1950]

When translating a log file using SC, it would be nice if you could specify the type of transaction you are looking for. As an example, I was looking for DELETE statements after a certain date and on a single table. The After Checkpoint option narrowed down what I had to search, but the log.sql file that was generated was still 200 meg. It would be nice if I could have specified DELETE * end_of_period_inventory, or DELETE statements only. I think my file to look at would have been reduce to 20 meg.

[Former Member]

Thank you for your suggestion. There are a number of possible enhancements to this wizard.

Not all of the switches for dbtran make sense to be included in this wizard but you are correct about the

-it table,...

switch being be a reasonable enhancement. As might these:

 "-g" include audit records
 "-c ..."  connect to and translate the active transaction log 
          (possibly a completely different mode for this wizard)
 "-m <dir>"


also, and there may be others.
These (and maybe some others) only require enhancements made to just the SQL Central Wizard
and I will submit that shortly.
For the DML type of operators, that usually makes less sense (in the more general usage) and can be done post translation by grepping or FINDing those from the produced SQL output.  The basic gear of the dbtran utility would need to be changed for that and I would like to see a larger business case for that.  For example, in addition to looking for DELETEs you probably should be looking for UPDATEs that change the primary key columns as well; so filtering on just the deletes may miss something important.
In the meantime, the wizard produces the dbtran cmdline you just painted with it and you can copy that (via the clipboard) to a cmd prompt and make any additions you want there.
HTH

[VolkerBarth]

One might add that a restriction to filter out particularly statements might need to distinguish the executed statements themselves and their "textual appearance" within the scope of other statements, say a DELETE or UPDATE as part of a CREATE PROCEDURE definition or the like...

(Apparently, I can't tell whether both kinds of "appearance" are stored differently within the original transaction log, however, when doing full-text search within a translated log, both will show up...)

[t1950]

Thank you for submitting the enhancement request and pointing out dbTran utility. I never thought of using it. Hopefully, dbTran and the -it switch will narrow down what I'm looking for.

[Former Member]

An enhancement request (#764394) was submitted to product development for consideration.