Re: SQL Server -> Oracle 8i

Hi,
I am trying to use DBArtisan Change Manager Version 1.2. It can transfer some tables, some ofthem failed. Because datatype are different, such as datetime... I do not they should convert them automticatly?

Thanks

Paul

jzuffoletto wrote:
>
>
> 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.

--
Posted via CNET Help.com
http://www.help.com/