The Log Translation utility
120
Include rows for specified destinations (–id) Isolate operations on
rows that are being sent to one or more of the following destinations,
specified as a comma-separated list:
♦
All All rows. This is the default setting.
♦
SQLRemote Include only rows that are to be replicated using
SQL Remote. You can also use the short form SR.
♦
RepServer Include only rows that are to be replicated using the
Replication Agent (LTM) and Replication Server. You can also use the
short form RS.
♦
Local Include only rows that are not replicated.
Include rows from specified sources (–is) Isolate operations on rows
that have been modified by operations from one or more of the following
sources, specified as a comma-separated list:
♦
All All rows. This is the default setting.
♦
SQLRemote Include only rows that were modified using
SQL Remote. You can also use the short form SR.
♦
RepServer Include only rows that were modified using the
Replication Agent (LTM) and Replication Server. You can also use the
short form RS.
♦
Local Include only rows that are not replicated.
Include offset range (–ir) Isolate a portion of the transaction log between
two specified offsets.
Include specified tables (–it) Isolate those operations on the specified,
comma-separated list of tables. Each table should be specified as
owner.table.
Output from the last checkpoint prior to a given date (–j) Only
transactions from the most recent checkpoint prior to the given date and/or
time are translated. The user-provided argument can be a date, time or date
and time enclosed in quotes. If the time is omitted, the time is assumed to be
the beginning of the day. If the date is omitted, the current day is assumed.
The following is an acceptable format for the date and time: "YY/MMM/DD
HH:NN".
Output file (–n) When you run the
dbtran
command-line utility against a
database server, use this option to specify the output file that holds the SQL
statements.
Log output messages to file (–o) Write output messages to the named
file.
To Next Page
Loading...