question

nathan714 avatar image
nathan714 asked

ORacle to SQL data type conversion for SYS.XMLTYPE STORAGE BINARY

I am working on a project migrating data from Oracle to SQL server .

I am not sure about transferring the data type SYS.XMLTYPE STORAGE BINARY from Oracle to SQL server.

Is the below data type conversion is the right one.Kindly help to keep things in right direction.

Name Oracle Data Type SQL SERVER DATA TYPE
----------------------------------------- -------- --------------------------------------------------------

BDATA BLOB IMAGE/BINARY/VARBINARY(8000)
CDATA CLOB TEXT
XDATA SYS.XMLTYPE STORAGE BINARY XML

migrationdatatypesoracle-sql-developer
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.