Sybase SQL Remote DC38133-01-0902-01 User Manual
than the Interactive SQL OUTPUT and INPUT statements to unload and
load data, respectively.
load data, respectively.
This combination of operations is the default behavior.
External operations takes the path of the data files relative to the current
working directory of
working directory of
dbxtract, while internal statements take the path
relative to the server.
Internal unload, external load (–ix)
Using this option forces the reload
script to use the internal UNLOAD statement to unload data, and the
Interactive SQL INPUT statement to load the data into the new database.
Interactive SQL INPUT statement to load the data into the new database.
External operations takes the path of the data files relative to the current
working directory of
working directory of
dbxtract, while internal statements take the path
relative to the server.
Iteration count for views (–j)
If there are nested views in the consolidated
database, this option specifies the maximum number of iterations to use
when extracting the views.
when extracting the views.
Perform extraction at a specified isolation level (–l)
The default setting
is an isolation level of zero. If you are extracting a database from an active
server, you should run it at isolation level 3 (see
server, you should run it at isolation level 3 (see
) to ensure that data in the extracted database is consistent with
data on the server. Increasing the isolation level may result in large numbers
of locks being used by the extraction utility, and may restrict database use by
other users.
of locks being used by the extraction utility, and may restrict database use by
other users.
Unload the schema definition only (–n)
With this definition, none of the
data is unloaded. The reload file contains SQL statements to build the
database structure only. You can use the SYNCHRONIZE SUBSCRIPTION
statement to load the data over the messaging system. Publications,
subscriptions, PUBLISH and SUBSCRIBE permissions are part of the
schema.
database structure only. You can use the SYNCHRONIZE SUBSCRIPTION
statement to load the data over the messaging system. Publications,
subscriptions, PUBLISH and SUBSCRIBE permissions are part of the
schema.
Output messages to file (–o)
Outputs the messages from the extraction
process to a file for later review.
Escape character (–p)
The default escape character (\) can be replaced by
another character using this option.
Operate quietly (–q)
Display no messages except errors. This option is not
available from other environments. This is available only from the
command-line utility.
command-line utility.
Reload filename (–r)
The default name for the reload command file is
reload.sql in the current directory You can specify a different file name with
this option.
this option.
310