Re: oracle schema migration
Date: Wed, 2 Apr 2008 18:47:18 +0200
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" <damorgan_at_psoug.org> wrote in message
> news.free.fr wrote:
>> 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
Received on Wed Apr 02 2008 - 18:47:18 CEST