Data type equivalent in T-SQL for the CLOB data type in PL-SQL - SQL Server 2012 and superior

_{Thursday, May 18, 2017 10:53 AM}

Hi,

in order to create a SQL Server table to feed with the corresponding data from an Oracle table, I need to create the corresponding column respect to the CLOB data type.

Any helps to me, please?

Thanks

_{Tuesday, May 23, 2017 11:30 AM}

Hi pscorca,

In SQL Server, you may use varchar(max). For more information about data type mapping, you may take a look at link below.

/en-us/sql/ssma/oracle/project-settings-type-mapping-oracletosql

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

_{Tuesday, May 23, 2017 12:47 PM}

Just to add.

This refers to replication, but the same mapping applies.

/en-us/sql/relational-databases/replication/non-sql/data-type-mapping-for-oracle-publishers