Re: Import of SQL-Server Database

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 4 Nov 2001 23:16:49 +0100
Message-ID: <tucc7tbbn1hta8@corp.supernews.com>

"Bernie Arnold" <BernieA_at_web.de> wrote in message news:3BE02FE6.4F307178_at_web.de...
> Hello,
>
> I have the following problem:
> How can I import an existing database that runs on Microsoft SQL Server
> 7 to Oracle Server 8.0? Thanks for your answers.
>
> Bernie
>

Oracle has a free migration workbench on http://technet.oracle.com in the downloads section.
Setting up an ODBC connection would also do the trick. Tablenames should be in uppercase and without spaces or hyphens, or you will be forced to use " to enclose all table and column names on the Oracle side. Oracle 8.0 has been desupported. Oracle 8.1.7 is the only version supported before 9i

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Sun Nov 04 2001 - 16:16:49 CST