Exporting Data to XML Files


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