Re: Migration from SQL-Server 7.0

False, Oracle does return resultsets.
Maybe your a better off with sqlserver.

Regards,

Sybrand Bakker, Oracle DBA

"Jan-Erik Rosinowski" <spamfilter_at_rosinowski.de> wrote in message news:38efcf77.3431323_at_News.CIS.DFN.DE...
> >we are planning to migrate from SQL-Server 7.0 under WinNT to Oracle
> >under Unix.
>
> we're going the opposite direction :-)
>
> >Anybody knows what kind of problems we have to face and what kind of
> >help Oracle provides for this task.
>
> oracle technet offers a migration-console or something like that
>
> anyway, t-sql and pl/sql are different in many ways: mssql allows
> stored procs to return rowsets. oracle of course not: you return a
> packaged cursor.. oracle knows packages, functions and a has an ada or
> pascal-like language. tsql? ...
>
> >MS does not even mention the topic ;-))
>
> ms has papers for our direction but the real problems are covered with
> "not supported" statements.
>
> would be nice if you would report your experiences with the
> oracle-migration-tools
>
> ciao, jan
>
> http://www.rsp.de/
>
> rs&p-Dossier: Software zur Erstellung technischer Dokumentationen
> und Schriftgutes in Verwaltung und Industrie.
Received on Sat Apr 08 2000 - 00:00:00 CDT