Re: Loading MS SQL Server and other format into Oracle

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Fri, 5 Oct 2001 19:07:14 +0100
Message-ID: <3bbe9efe_1@mk-nntp-1.news.uk.worldonline.com>

I don't think so directly, as I believe the MSSQL backup is a proprietory binary format. Depending on data volumes you may like to look at three options (or combinations thereof):

Oracle's Migration Workbench
MSSQL DTS job(s)
'Unload' from MSSQL as flat files and use Oracle's SQL*Loader to populate Oracle.

HTH.
Paul

"Bruno Georges" <bruno_at_xbridge.com> wrote in message news:3BBD6C67.1050409_at_xbridge.com...
> Hi
>
> Can anyone tell me if it is possible to load a microsoft SQL server
> database bakup into an Oracle database.
>
>
> Thanks for your help
>
> Bruno Georges.
> Xbridge Ltd.
>
Received on Fri Oct 05 2001 - 13:07:14 CDT