You can use the Insert into XML Column wizard to insert XML data
into an XML column. You can open the wizard from an XML column that is displayed
in a database connection in the Database Explorer.
Prerequisites: Before you can complete the wizard, you must
complete the following prerequisite steps:
- Create a connection to an XML database in the Database 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 insert XML data into an XML column from the Database Explorer:
- Select one XML column in the Database Explorer.
- Right-click, and select Insert into XML Column. The Insert into XML Column wizard opens.
- Complete the steps of the wizard, then click Finish. You can select XML files from the file system to insert into the XML
column, and you can optionally select an XML schema to validate
the insert. For additional help about the wizard, press F1.
The data from the XML files that you selected is inserted into the
XML column. You can view the results of the actions in the Data Output view,
including any errors or failures. Each insert is performed separately, so
if you are performing multiple inserts at the same time, the success or failure
of each insert is displayed. You can also view a sample of the data that was
inserted by right-clicking the XML column in the Database Explorer, and selecting .