Re: Migration from SQL-Server 7.0

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

>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.

erm.. oracle's different language called pl/sql is exactly the problem

>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.

oracle delivers a migration-wizard for access-apps. that helps you getting the data over there. but that's actually the smallest problem...

there is also a migration workbench which can be found in oracle's technet (registration is free). i'm not sure but i guess as always you'll need a t1-line to download the stuff :-)

>Norwegian Software Developer

greetings from germany

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