Re: oracle schema migration

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)

thanks

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1207153774.919194_at_bubbleator.drizzle.com...
> news.free.fr 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
> damorgan_at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Wed Apr 02 2008 - 18:47:18 CEST