0
Answer

How to convert Oracle xml data to sql xml data

vamsi k

vamsi k
2y
751
1

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

Next Recommended Forum