Hi All,
We have a table in Oracle which as xmltype column with xml data and we need to migrate this data from Oracle to SQL . Please assist me how to migrate Oracle Table xml column values to SQL Server Table xml column through Sql Server wizard or SSIS package or any other solution.
Example:
Oracle Sql Server
Table name : Employee Table name : Employee
ID NUMBER ID INT
NAME VARCHAR2(10) NAME VARCHAR(10)
EMPDetails XMLTYPE EMPDetails XML