Re: Migration from SQL-Server 7.0

We are also doing this. We support Access, MS Sql server version 6.5 and 7.0 today, and now I'm implementing Oracle. I hope I dont qualify as beeing one of the complaining and expecting guys.

One thing I take for granted though, and that is that Oracle supports, as most other big databases, the Transact Structured Query Language(T-SQL of course). If I couldn't expect this, then the project dies right here right now.

Now, I've created an 'upsizer' that exports tables w/data and views from an access Database to the destination database (beeing Microsoft SQL Server 6.5 or 7.0). We need to do the same with Oracle in order to support the database at all.

To do this we need to be able to convert datatypes from MSSQL-Server/access to that of Oracle. This is the part where we need help. Is there anyone who KNOWS the correct 'Oracle equalient datatype name' to those datatypes which exists in access/MSSQL Server ?. Better yet, is it easy to use a utility to transfer a Mssql Database to a oracle Database, and how is this done?

Help would be greatly appreciated

thx upfront

Tommy Akre
Norwegian Software Developer

"Jan-Erik Rosinowski" <spamfilter_at_rosinowski.de> skrev i melding news:38efef4e.49000539_at_News.CIS.DFN.DE...
> >This is the usual disease, which can be remedied by a prescription of
 RTFM.
> >or consulting
> >http://osi.oracle.com/~tkyte/ResultSets/index.html
> >as has been posted _many many_ times in this newsgroup.
>
> i guess you didn't understand what i originally wrote. i actually
> mentioned that returning cursorrefs is oracle's way to handle that.
> it's a somewhat broken design to return references to local variables
> but it works in oracle. i said nothing else.
>
> >My experience is people with a sqlserver background are expecting
 everything
> >to function in Oracle _exactly_ the same way, and they start complaining
> >about Oracle immediately when this doesn't proof true. Of course they
 just
> >started 'somewhere', which is usual in the Microsoft world. So that's why
 my
> >orginal last sentence was a bit cynical.
>
> do as you please. my problem is that i need to maintain a common
> sql-code-base for oracle, mssql and sybase. if things work slightly
> different it's simply a nuisance. that's got nothing to do with
> ignorance or 'my dbms is longer than yours'.
>
> ciao, jan
>
> http://www.rsp.de/
>
> rs&p-Dossier: Software zur Erstellung technischer Dokumentationen
> und Schriftgutes in Verwaltung und Industrie.
Received on Tue Apr 11 2000 - 00:00:00 CDT