Re: oracle schema migration

From: <>
Date: Wed, 2 Apr 2008 18:47:18 +0200
Message-ID: <47f3b896$0$19907$>

Indeed that was a bit short.
[Quoted] [Quoted] I am trying to migrate tables from oracle 10.2 to a MSsql 2005. [Quoted] I thought oracle sql developper would do this but it migrates only from sql to oracle.
[Quoted] The datatypes of the source tables (from Oracle) are number, varchar2,date)


"DA Morgan" <> wrote in message
> wrote:
>> Hello,
>> I am desperatly looking for a tool that could migrate an oracle DB
>> (tables, PK, possibly some views triggers and SP).
>> My difficulty is to properly map the oracle datatype to SQL.
>> Does anyone have an idea?
>> thanks for helping
> No version number.
> No information about the types of objects or their number or their size.
> What's wrong with export?
> What's wrong with DataPump?
> What's wrong with Transportable Tablespaces?
> What's wrong with RMAN?
> --
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Washington
> (replace x with u to respond)
> Puget Sound Oracle Users Group
Received on Wed Apr 02 2008 - 18:47:18 CEST

Original text of this message