Migrating text, ntext, and image Columns from Oracle to SQL Server

Modifying text, ntext and image Columns

When migrating to Microsoft® SQL Server™, you use text, ntext and image columns in place of LONG, CLOB, NCLOB, LONG RAW and BLOB columns. In Oracle, you use UPDATE and INSERT statements to change values in these columns.

In SQL Server, you can use standard UPDATE and INSERT statements, or you can use the UPDATETEXT and WRITETEXT statements. Both UPDATETEXT and WRITETEXT allow a nonlogged option, and UPDATETEXT allows for partial updating of a text, ntext or image column.

Reading text, ntext and image Columns

In Oracle, you use a SELECT statement to query the values in LONG and LONG RAW columns. Because the LONG, CLOB, NCLOB, LONG RAW or BLOB column is part of a queried row, no specialized functions are required to access this information.

In SQL Server, you can use either a standard SQL statement or the specialized READTEXT statement to read data in text, ntext and image columns. The READTEXT statement allows you to read partial sections of a text, ntext or image column. Oracle does not provide an equivalent statement for working with LONG and LONG RAW columns.

See Also
Modifying ntext, text or image Values Retrieving ntext, text or image Values
READTEXT UPDATETEXT
WRITETEXT  

  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.