Inserting XML data into XML columns with a wizard

The workbench can populate an XML column with data that is contained in XML files. The XML files can be stored in the file system , or in a data development project.

The Insert into XML Column wizard simplifies this process so that you can insert XML data from multiple files at the same time. You can also specify an XML schema to validate the insertion.

The wizard creates an INSERT statement and runs a batch insert using the selected XML documents. If any of the documents fails the insert, the corresponding error message is displayed in the Data Output view in the Messages tab, and subsequent inserts on the remaining documents are attempted.

Restriction: The Insert into XML Column wizard performs an insert into the selected XML column, and only that column. If any restriction in the database schema prevents the insert from occurring, for example, if there is another non-nullable column in the table that does not have a generated value, then all of the inserts fail.

Feedback