Re: SQL Server -> Oracle 8i

From: <jzuffoletto_at_my-deja.com>
Date: Mon, 11 Dec 2000 21:22:08 GMT
Message-ID: <913ghq$va6$1@nnrp1.deja.com>

In article <90q2n6$mec$1_at_flis.man.torun.pl>, "Chmielewski Jacek"
<jacekch_at_mail.atr.bydgoszcz.pl> wrote:
> What is the best tool to transfer database from
SQl Server 6.5 to Oracle 8i
> ?
> Any hints ?
> Jacek
>
>

We've had OK luck using the "Migrate" utility in DBArtisan 5.x. Another option, if you have SQL Server 7.0 available, is to upgrade to that, then use its data conversion utilities to move the data into Oracle. It's hard to say which works better - we've found both methods helpful but neither foolproof. I'm sure a hardcore DBA would write scripts to do the conversion - I don't qualify but perhaps you'll hear from one. :)

Joe

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 11 2000 - 15:22:08 CST