Some question about migration workbench

From: Chris <mclo_at_asia.com>
Date: 10 Apr 2002 21:34:20 -0700
Message-ID: <2d44b924.0204102034.4b5a8ac3@posting.google.com>

Hi,

I have two problems using Migration Workbench. The source database is Micrsoft SQL 7.0 and the target database is Oracle 8.1.5 on Windows 2000.

First problem : When I capture the source database, there is no option for converting "nvarchar" (MSSQL) to "NVARCHAR2" (Oracle). The migration result becomes VARCHAR2 with length 2 times the source length .i.e.

SOURCE DATATYPE       TARGET DATATYPE


---------------       ---------------

varchar(20)           varchar2(40)

How can I get this desired result :

SOURCE DATATYPE       TARGET DATATYPE


---------------       ---------------

varchar(20)           nvarchar2(20)

Second problem : I have some Chinese characters in the source table, after did the data migration, those characters becomes some alphabetic string , e.g. "3C00660075006E006300740069006F006E002000690064003D002200430041005400...."

Here are some character setting of my Oracle 8i database :

PARAMETER                      VALUE
------------------------------ ---------------------NLS_LANGUAGE      
            AMERICAN
NLS_TERRITORY                  AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               UTF8
NLS_NCHAR_CHARACTERSET         UTF8
NLS_RDBMS_VERSION              8.1.5.0.0

Thanks.

Chris Received on Wed Apr 10 2002 - 23:34:20 CDT