From
the table data editor, you can import and export XML
data from an XML file that is saved in a project or on the file system.
After you perform the steps in the editor to import the XML data,
the appropriate commands run on the database to insert or update the
XML data.
- Create
a connection to an XML database in the Data Source Explorer.
The database must contain at least one table with at least one XML
column.
- Create XML files on the local file system, or in
a data development project.
To
import XML data into an XML column:
- In
the Data Source Explorer, right-click a table that contains
an XML column, and select .
- In
the editor grid, click the ellipsis [...] button in
an editor row that contains an XML column. The XML
Cell editor window opens.
- Click Import.
- In the window that opens, specify whether to import
XML
data from the file system or from a project, browse to an XML file
that contains the data that you want to import, and click OK. You can select any type of XML file, for example: an .XSD, .XML,
or .XSL file. The contents of the XML file that
you selected is displayed in the XML Cell editor window. If there
is existing data in the row, the imported data replaces the existing
data.
- Click Finish in
the XML Cell editor
window.
- Save the changes and close the table
data editor.
The SQL Results View displays
messages that indicate whether
the database actions ran successfully.