Bulk Copying Data Out of a Table

Use bulk copy to copy table data to an external file.

1. In the Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
2. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables, then choose one of the following:
   • User Tables
   • Proxy Tables
3. Select one or more tables from which to copy data.
   If you select one table, you can select a different data file for each partition. If you select multiple tables, you can only provide one data file for all partitions for the table.
4. Select Bulk Copy Out.
   You see the Bulk Copy Out wizard.
5. In the Specify Data File window, enter the location.
6. Select the format for copying data.
7. In the Specify Copy Format window, choose the field and row parameters for the file to be copied from the table.