Re: How to export unicode data from MSSQL 2000 to Oracle 9

From: Dmitry Tolpeko <support_at_ispirer.com>
Date: Wed, 5 Jan 2005 19:34:04 +0200
Message-ID: <342m9nF44lvgjU1@individual.net>

Hi,

It's most likely a database configuration issue, DTS should transfer unicode. Please clarify whether you receive import errors or see not correct data. In latter case, please specify what exactly you receive. What codepage is set in Oracle?

Happy New Year!

Best regards, Dmitry Tolpeko
SQLWays - Data, Schema, Procedures conversion between all major databases www.ispirer.com

<lsllcm_at_gmail.com> wrote in message
news:1104918022.165889.263950_at_z14g2000cwz.googlegroups.com...
> How to export unicode data from MSSQL 2000 to Oracle 9?
>
> The OS platform is Windows, Oracle is 9.0.1, The MSSQL is 2000. I use
> the northwind db of MSSQL as example. I use two methods. One is to use
> MSSQL DTS tool. The another is to save as csv file by using DTS, then
> use Oracle SQLLDR to load it. But we cannot export the unicode data
> successfully. The example data is Table "customers" Column
> "COMPANYNAME".
>
> Can anyone help?
>
> Thanks in advance!
>
Received on Wed Jan 05 2005 - 11:34:04 CST