To export a table to an XML file:

  1. Open the Data Transfer Tool.

  2. Select Export to XML from the main console or the Transfer menu. The Welcome to Export to XML File Wizard window will appear.

  3. Click Next. The Choose a Data Source window will open.

  4. Select a database from the Database menu. Enter a user name and password into the appropriate fields.

  5. Click Next. The Table or Query Export window will appear.

  6. If you selected Table from the Table or Query Export window, the Table Export window will open. If you selected SQL query, then proceed to step 13.

  7. Click Next, the Table Export window will open.

  8. Select a table to export from the Table name menu. A list of columns in the table will appear in the Select columns to export field.

  9. Select columns by clicking on the column name and clicking Add, or select all columns by clicking Add All.

  10. Click Next. The Name The XML File window will appear (proceed to step 16).

  11. If you selected SQL query from the Table or Query Export window, the Query Export window will open.

  12. Enter a valid SQL select statement into the SQL query field.

  13. Click Next. The Name The XML File window will appear.

  14. Enter the full path of an XML file to export to, or select one by using the browse button.

  15. Click Next. The XML File Format Setting window will open.

  16. Select the appropriate settings for the format of the XML file you will create.

  17. Click Next. The Customized XML Header window will open.

  18. Enter appropriate information, such as namespace and style sheet definitions, if relevant.

  19. Click Next. The Customized Element Name window will appear.

  20. It is possible to modify the tag definitions. Enter new tag definitions into the Replace Tag Name column. The name of the corresponding column will be changed in the resulting XML file.

  21. Click Execute to export the table to the XML file. A confirmation window will appear.

  22. Click OK.


Related topic:

Exporting Data to XML