Chapter 4 Database Administration Utilities
121
Operate quietly (–q) Do not display output messages. This option is
available only from the command-line utility.
Do not include uncommitted transactions (–r) Remove any
transactions that were not committed. This is the default behavior.
Override Replication Server user names (–rsu) By default, the -id
and -is switches assume the default Replication Server user names of
dbmaint
and
sa
. You can override this assumption using the -rsu option
with a comma-separated list of user names.
Generate ANSI standard SQL UPDATE (–s) If the switch is not used,
and there is no primary key or unique index on a table, the Translation utility
generates UPDATE statements with a non-standard FIRST keyword in case
of duplicate rows. If the switch is used, the FIRST keyword is omitted for
compatibility with the SQL standard.
Generate SQL Remote comments (–sr) Place generated comments in
the output file describing how SQL Remote distributes operations to remote
sites.
Include transactions generated by triggers (–t) By default, actions
carried out by triggers are not included in the command file. If the matching
trigger is in place in the database, when the command file is run against the
database, the trigger will carry out the actions automatically. Trigger actions
should be included if the matching trigger does not exist in the database
against which the command file is to be run.
Output transactions for listed users only (–u) This switch allows you
to limit the output from the transaction log to include only specified users.
Output transactions except for listed users (–x) This switch allows
you to limit the output from the transaction log to exclude specified users.
Operate without confirming actions (–y) Choosing this option
automatically replaces existing command file(s) without prompting you for
confirmation.
Include transactions generated by triggers as comments only (–z)
Transactions that were generated by triggers will be included only as
comments in the output file.
To Next Page
Loading...