Importing XML data into an XML column with the table data editor

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.

To import XML data into an XML column:

  1. In the Data Source Explorer, right-click a table that contains an XML column, and select Data > Edit.
  2. In the editor grid, click the ellipsis [...] button in an editor row that contains an XML column. The XML Cell editor window opens.
  3. Click Import.
  4. 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.
  5. Click Finish in the XML Cell editor window.
  6. Save the changes and close the table data editor.
The SQL Results View displays messages that indicate whether the database actions ran successfully.

Feedback