Bulk Copying Data Into or Out of Tables

Use bulk copy to insert data into an existing database table or to copy table data to an external file.

  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables, then choose one of the following:
    • User Tables
    • Proxy Tables
  2. Click the Name field of one or more tables, then click the drop-down arrow and select either Bulk Copy In or Bulk Copy Out.
    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.
  3. On the Specify Data File screen, enter the location for partitions.
  4. On the Specify File Format, select the format for copying data.
  5. On the Specify Copy Format screen, choose the field and row parameters for the file to be copied into the table.
  6. Click Finish.