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

news.free.fr wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

news.free.fr wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

news.free.fr wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

news.free.fr wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

news.free.fr wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

news.free.fr wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

news.free.fr wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

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

thanks


"DA Morgan" <damorgan (AT) psoug (DOT) org> wrote

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

thanks


"DA Morgan" <damorgan (AT) psoug (DOT) org> wrote