6. Loading and Unloading Databases : Generate XML and Import XML Operations
 
Share this page                  
Generate XML and Import XML Operations
The genxml and xmlimport utilities let you transfer data in XML format.
XML is a cross-platform, software and hardware independent format for transmitting information across the Internet. The XML data files produced can also be processed by other XML-enabled databases and applications.
The genxml utility converts the table data, including metadata information, into XML and places it in an XML file. You can export the whole database or specific tables into XML files. The generated XML file conforms to the generic Ingres DTD.
The xmlimport utility imports the data from an XML file into an existing Ingres database. This utility parses an XML document and prints the data and scripts into files. The script can be run to upload and store the data from the XML file into the Ingres table. The XML file for upload is validated against the Ingres DTD. Only XML files that conform to the Ingres DTD can be imported into an Ingres database.
The genxml and xmlimport database operations are run as system commands. For more information, see the Command Reference Guide.
Related visual tools are the Import Assistant and Export Assistant, which are used for importing and exporting data in various formats, including XML.