Chapter 4 Database Administration Utilities
117
The Log Translation utility
With the Log Translation utility, you can translate a transaction log into a
SQL command file.
You can access the Log Translation utility in the following ways:
♦ From Sybase Central
♦ From the system command line, using the
dbtran
command-line utility.
This is useful for incorporating into batch or command files.
Translating a transaction log in Sybase Central
v To translate a transaction log into a command file:
1 Open the Utilities folder in the left panel.
2 Double-click Translate Log in the right panel. The Translate Log wizard
appears.
3 Follow the instructions in the wizard.
Tip
You can also access this wizard by clicking Tools➤Adaptive Server
Anywhere➤Translate Log.
The dbtran command-line utility
Running against a transaction log.
dbtran [
switches
]
transaction-log
[
sql-file
]
Running against a database server.
dbtran [
switches
]
Switch Description
–a
Include uncommitted transactions
–c "keyword=value; ..." Supply database connection parameters. Cannot be
used with a transaction log name.
–d
Display output in chronological order
–f
Output only since the last checkpoint
Syntax
To Next Page
Loading...