Re: Migration from SQL-Server 7.0

From: Jan-Erik Rosinowski <spamfilter_at_rosinowski.de>
Date: 2000/04/08
Message-ID: <38efcf77.3431323@News.CIS.DFN.DE>#1/1

>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