Working with Table Data - Extract Data as XML

Go Up to Session 7: Data Management

DBArtisan lets you generate an XML representation of table data.

To extract data as XML

1. On the Datasource Explorer, expand any Oracle datasource.
2. On the Oracle datasource, expand the Tables node.
3. In the right pane of the Explorer window, right-click any table listed, and then select Extract Data as XML.
4. Select the columns to include in the SELECT statement.
5. You can also filter what rows are included by adding a WHERE clause in the Select Statement box.
6. Click OK.

   The resulting XML document is created and presented in an active XML Editor. At this point the document can be saved in XML format.

   

7. Close the editor pane.

Proceed to Advanced Data Management - Schema and Data Migration.