| Breck Carter [TeamSybase] 2005-09-22, 8:23 pm |
| It would be good to be able to easily recover DDL operations from a
giant log file without generating massive intermediate text files
including millions of DML operations. For example, a 500M log file can
easily generate gigabytes of translated SQL.
Currently only the -u option (select by user id) seems to affect DDL
operations, and that doesn't help when the same user id is used for
both DDL and DML.
The -it option (include these tables) excludes DDL operations...
although one is tempted to try -it SYS.SYSTRIGGER, etc. <g>
The -ir option (include offset range) reduces the size of individual
output files, but now you're dealing with dozens or hundreds of dbtran
runs.
....or maybe I am missing something?
Breck
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|