Re: SQL Server -> Oracle 8i

Jacek,

The best utility out there is free! Oracle Migration Workbench (OMW, available for download at http://technet.oracle.com if you're a member) is very good at the job.

However, you must remember that some things in SQL Server don't have direct equivalents in Oracle. For some of these things, OMW will convert your code with a workaround (e.g. converts identity columns from SQL Server, to a post-insert trigger in Oracle which select the column value from a squence). For other things, it just shows a warning/error (e.g. warns that granularity of date/times in Oracle only goes down to seconds).

Give it a go. It is a very nice tool, but if you have lots of stored procedures, you will have some manual conversion to do too. I have done a couple of SQL Server conversions using it, and OMW is definitely a time-saver.

Hope this helps,

Dave Henderson.

In article <913ghq$va6$1_at_nnrp1.deja.com>,   jzuffoletto_at_my-deja.com 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.
>

--
Any opinions expressed in the above posting are entirely factual and obj
Please do not argue with me, as my Dad is bigger than your Dad.


Sent via Deja.com http://www.deja.com/
Before you buy.