The Log Translation utility
118
Switch Description
–g
Include audit records in output
–id destination,... Include only rows intended for the specified
destinations
–ir offset1,offset2 Include only the portion of the log between the two
specified offsets
–is source,... Include only rows originating from the specified
sources
–it user.table,... Include only operations on specified tables by
specifying a comma-delimited list of user.table
–j date/time Output from the last checkpoint prior to the given time
–n filename Output SQL file, when used against a database server
–o filename Log output messages to a file
–q
Run quietly, do not print messages
–r
Remove uncommitted transactions (default)
–rsu username,... Override default Replication Server user names
–s
Produce ANSI standard SQL UPDATE transactions
–sr
Generate SQL Remote comments
–t
Include trigger-generated transactions in output
–u userid,... Translate transactions for listed users only
–x userid,... Exclude transactions for listed users
–y
Replace file without confirmation
–z
Include trigger-generated transactions as comments
only
transaction-log Log file to be translated. Cannot be used together with
–c or -n
sql-file Output file containing the translated information. For
use with transaction-log only
The
dbtran
utility takes the information in a transaction log and places it as a
set of SQL statements and comments into an output file. The utility can be
run in the following ways:
♦
Against a database server Run in this way, the utility is a standard
client application. It connects to the database server using the connection
string specified following the
-c option, and places output in a file
specified with the
-n option. DBA authority is required to run in this
way.
Description
To Next Page
Loading...