Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-14 : 15:30:35
|
| Neil Whitson writes "SQLteam,I am required to move data from an sql server ntext column to an oracle raw column using sql-server's DTS facilities. Oracle raw is effectively a hex representation of text so instead of 'ABC' you have '414143' which is the hex representation of 'ABC'.I have seen how this is done the other way using the following :Import Oracle raw into SQL server image datatype column.bcp this to a filesystem file using following convert facilities : convert(varchar(8000),convert(varbinary(8000),image_column))bcp this nack in to the ntext column using an appropriate code page parameter.I would like to know if anyone has had experience moving sql server ntext to Oracle Raw data types.Please let me knowRegards,Neil" |
|
|
|
|
|
DTS moving SQL server ntext data to Oracle raw format