This command exports XML data into other formats for exchange with databases or legacy systems.
Depending on the output data format required, you may want to use either XSLT Transformations or this Export command to export your XML data.
You first need to define the structure of the data to be exported. Since XML is structured hierarchically and most database and legacy systems use the relational model, XML Spy will help you in producing output that can be interpreted in a relational context.
Start point of export
You can choose to export the entire XML document or restrict your export to the data starting from the currently selected element (and its child items).
Export fields
Depending on your XML data, you may want to export only elements, attributes, or the textual content of your elements into the fields common to structured text files or databases.
The list of available element types, in the preview window, lets you choose which elements you want to export, and also displays you how many records and fields this will produce once the export operation is started.
Export depth
You can choose to export all sub-elements, or limit the number of sub-element levels.
Automatic fields
XML Spy will produce one output file or table for each element type selected. You can choose to automatically create primary/foreign key pairs to link your data in the relational model, or define a primary key for each element.
When you are finished defining the scope of your export operation, click one of the two "Export" buttons, to export your data to a set of text files or to a database.