Sybase DC38133-01-0902-01 manual Input

Chapter 14. Utilities and Options Reference

Output the data unordered (–u)By default the data in each table is ordered by primary key. Unloads are quicker with the -uoption, but loading the data into the remote database is slower.

Verbose mode (–v)The name of the table being unloaded and the number of rows unloaded are displayed. The SELECT statement used is also displayed.

Exclude foreign key definitions (–xf) You can use this if the remote

database contains a subset of the consolidated database schema, and some foreign key references are not present in the remote database.

External unload, internal load (–xi) The default behavior for unloading the database is to use the UNLOAD statement, which is executed by the database server. If you choose an external unload, dbxtract uses the OUTPUT statement instead. The OUTPUT statement is executed at the client.

External operations takes the path of the data files relative to the current working directory of dbxtract, while internal statements take the path relative to the server.

Exclude stored procedure (–xp)Do not extract stored procedures from the database.

Exclude triggers (–xt)Do not extract triggers from the database.

Exclude views (–xv)Do not extract views from the database.

External unload, external load (–xx) Use the OUTPUT statement to unload the data, and the INPUT statement to load the data into the new database.

The default unload behavior is to use the UNLOAD statement, and the default loading behavior is to use the LOAD TABLE statement. The internal UNLOAD and LOAD TABLE statements are faster than OUTPUT and

INPUT.

External operations takes the path of the data files relative to the current working directory of dbxtract, while internal statements take the path relative to the server.

Operate without confirming actions (–y) Without this option, you are

prompted to confirm the replacement of an existing command file.

311