Migrating Data to the XML Type - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ XML Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K

To migrate XML data stored in VARCHAR or CLOB columns to equivalent schemas with XML type columns, do the following:

  1. Verify that the XML data is well-formed and conforms to rules of XML formatting.
  2. Create new versions of the tables using XML type for columns that will hold the XML data.
  3. Insert the XML text into the XML columns using the NEW XML operator or the CREATEXML function.