How to transfer images from ORACLE to MSSQL 2000?

Hi,

I have Oracle Database with Images, How to get the Images from oracle and put them in mssql2000, any tools for this
Sri

I am not very sure if the login transfer wizard can help in this.

See ifhttp://www.microsoft.com/technet/tr...rodtechnol/sql/reskit/sql2000/part2/c0761.asp can help you...

Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

Hi Gaurav,

Nothing in that DOC about the Images


Sri

Hi,

There a document file related w/ subj.


Microsoft SQL Server implements binary large objects (BLOBs) with text and image columns. Oracle implements BLOBs with LONG and LONG RAW columns. In Oracle, a SELECT command can query the values in LONG and LONG RAW columns.

In Oracle, UPDATE and INSERT commands are used to change values in LONG and LONG RAW 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 or image column.
The UPDATETEXT statement can be used to replace existing data, delete existing data, or insert new data. Newly inserted data can be a constant value, table name, column name, or text pointer.
The WRITETEXT statement completely overwrites any existing data in the column it affects. Use WRITETEXT to replace text data and UPDATETEXT to modify text data. The UPDATETEXT statement is more flexible because it changes only a portion of a text of image value rather than the entire value.
...

Please let me know your e-mail address via e-mail.

I will mail you a .doc MSDN published.

Thanks.