- Select the menu item Tools > Export Data > Export to
XML File or the Export to XML File button from the
main tool bar
- Select the open connection to use for this data export
- Select whether to export a single table or multiple tables
- For a multiple table export:
- Select whether to generate one file that includes ALL
extracted tables or multiple files where a single file is used
for each individual table
- Select the Next button to proceed to the next step
- Select the database catalog or schema containing the table(s) to
be exported
- For a single table export:
- Select the table to be exported from the drop-down list
- Select the desired columns (or all) to be exported from the
selected table
- Reorder the columns as desired using the Move up/down
buttons
- For a multiple table export:
- Select the tables to be exported from the 'Available Tables'
list using the arrow selection buttons
- Alter the order in which each table will be extracted using
the Move up/down buttons
- Select the Next button to proceed to the next step
- Select a valid file path or paths for each individual table to be
exported - or a single file path for single file generation
- Select the Next button to proceed to the next step
- Select the XML root element style - for multiple table export with
a single file, the root element used is the schema name
- Select the action on error for the extraction process
- Select the Next button to proceed to the next step
- Review the selections made and use the Back button to make any
changes
- Select the Next button to begin the data extract process
- Monitor the output pane for any errors - use the Stop button to
halt the process at any stage during the run
- Select Finish (or Back to correct errors etc) when the process
has completed
|