Re: run Oracle workbench migration on oracle 8.0.4 on NT?

In article <38C734BD.D7361687_at_intercall.net>, David Spaisman <davedba_at_intercall.net> wrote:
> Hello:
>
> We are currently running an oracle application
on Oracle 8.0.4.
> We also have a Microsoft sql server application
6.5, sp4 application
> that we want to convert over to Oracle ASAP.
>
> My questions are:
>
> 1) can we use migration workbench between
oracle 8.0.4 on NT and
> mssql 6.5?
>
> 2) If not, do we have to upgrade to Oracle 8.05
or must we go to
> Oracle 8.1.5?
>
> 3) Does any one have any experience in working
with oracle
> migration workbench on Oracle 8.0.4 or working
with any other Oracle
> 8.05 or 8.1.5?
>
> Any information will be helpful.
>
> DAvid Spaisman
>
>

We're currently trying to convert our MSSQL application to Oracle 8.1.5 using the migration workbench. Our application relies heavily on stored procedures and views written in T-SQL and the preliminary results using the workbench are dismal.

For example:

1. has problems interpreting MSSQL column labels in views (e.g. select 'foo' = bar from emp)
2. creates views with invalid column names (e.g. '0x0000001' or 'value' or 'label')

It appears that the workbench hasn't been tested on realistic T-SQL, as most of my stored procs didn't make it over.

On the brighter side, the migration attempt didn't take too long to get going, so you can always do some exploratory tests and see how the workbench likes your application.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 23 2000 - 15:40:47 CST