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.
asked 20 May '14, 06:59
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
switch being be a reasonable enhancement. As might these:
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.
An enhancement request (#764394) was submitted to product development for consideration.
answered 21 May '14, 12:02
Nick Elson S...