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

Teradata Vantageā„¢ XML Data Type

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1140-162K
Language
English (United States)

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.