Re: Unicode data migration from SQL Server to Oracle
- From: "Jan Benjamins" <jan.benjamins@xxxxxxxxx>
- To: Richard.Goulet@xxxxxxxxxxx
- Date: Fri, 7 Nov 2008 22:04:02 +0100
Hi,
You could look into oracle heterogeneous services, just google for these
terms, you find enough, no need for transparent gateway (license). I think
you need odbc for this, so for windows no problem, for unix you could look
at the datadirect drivers (from Merrant ?). Used it years ago, pretty
straighforward.
regards,
Jan
On Fri, Nov 7, 2008 at 7:11 PM, Goulet, Richard
<Richard.Goulet@xxxxxxxxxxx>wrote:
> Michael,
>
> If that's what your developers want then your only option, that I know
> of, is Oracle's transparent gateway to Sql*Server. You install it on the
> Sql*server database machine & then create database links inside Oracle to
> it. Not very hard to set up(should take you about an hour max). Very easy
> to use and you can control whether or not they can update Sql*Server data
> from Oracle.
>
>
> *Dick Goulet***
> Senior Oracle DBA
> PAREXEL International
> 978.313.3426
> * information transmitted in this communication is intended only for the
> person or entity to which it is addressed and may contain confidential
> and/or privileged material. Any review, retransmission, dissemination or
> other use of, or taking of any action in reliance upon, this information by
> persons or entities other than the intended recipient is prohibited. If you
> received this in error, please destroy any copies, contact the sender and
> delete the material from any computer.*
>
>
>
> ------------------------------
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Michael Rosenblum
> *Sent:* Friday, November 07, 2008 1:06 PM
> *To:* 'Jared Still'
> *Cc:* oracle-l@xxxxxxxxxxxxx
> *Subject:* RE: Unicode data migration from SQL Server to Oracle
>
> It is not a problem to push data from SQL Server to Oracle even
> using Microsoft's "Import and Export Data" utility (as long as Oracle's
> own ODBC drivers are used)
>
> But our developers want to have views on Oracle side that would point to
> SQL Server tables - and write migration scripts againt these views.
>
> Regards,
> Michael Rosenblum
> Dulcian Inc
>
> -----Original Message-----
> *From:* Jared Still [mailto:jkstill@xxxxxxxxx]
> *Sent:* Friday, November 07, 2008 12:12 PM
> *To:* mrosenblum@xxxxxxxxxxx
> *Cc:* oracle-l@xxxxxxxxxxxxx
> *Subject:* Re: Unicode data migration from SQL Server to Oracle
>
> Have you tried using the Migration Workbench in SQL Developer?
> It doesn't require using ODBC.
> The Oracle connection is via Java connector, and the SQL Server
> connection is via open source SQL Server connector (jTDS)
>
> If you do try it, use version 1.2. The new 1.5 version of SQL Developer
> doesn't work for the SQL Server -> Oracle migration.
>
> I just used it this week, and have a question in on OTN for the 1.5
> version.
>
>
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
>
>
> On Fri, Nov 7, 2008 at 7:39 AM, Michael Rosenblum
> <mrosenblum@xxxxxxxxxxx>wrote:
>
>> Good morning, all!
>>
>> Currently we are building a system in Ethiopia – and as a part of the
>> project need to do a data migration. So…
>>
>> 1. Source – SQL Server 2000 Database with a number of tables with NVARCHAR
>> datatype
>> a. Stored data is in Ge'ez language – it does mean that there is no
>> standard locale.
>> b. SQL Server internally is using UCS-2 to store Unicode data
>> (compatible with UTF16)
>> 2. Target – Oracle 10g (10.2.0.4) Enterprise edition on Windows 2003
>> Server 32-bit
>> a. NLS_CHARACTERSET = AL32UTF8
>> b. NLS_NCHAR_CHARACTERSET=AL16UTF16
>> 3. Migration mechanism - Heterogeneous Services via ODBC
>>
>> Problem - *Unicode data comes to Oracle as '?'*.
>>
>> And it is not a visual affectation:
>>
>> SQL> select ascii("Column1") a, "Column1" from test@db_link
>> A Column1
>> --------- --------
>> 63 ?
>> SQL>
>>
>> Attempted actions:
>> 1. OLEDB – the same problem
>> 2. Third party ODBC drivers – don't even recognize NVARCHAR columns
>> 3. Played with HS_LANGUAGE and HS_NLS_LANG – no impact.
>>
>> Any ideas/suggestions?
>>
>> Thanks,
>> Michael Rosenblum
>> Dulcian Inc.
>>
>>
>>
>>
>
>
Other related posts:
