migrate ORACLE TO SQL

From: news.free.fr <grille11_at_yahoo.com>
Date: Wed, 2 Apr 2008 18:48:57 +0200
Message-ID: <47f3b8f8$0$3851$426a74cc@news.free.fr>

Hello

I am desperatly looking for a tool that could migrate an oracle DB (tables, PK, possibly some views triggers and SP). I am trying to migrate tables from oracle 10.2 to a MS SQL 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) My difficulty is to properly map the oracle datatype to SQL. Does anyone have an idea?
thanks for helping Received on Wed Apr 02 2008 - 11:48:57 CDT

This message: [ Message body ]
Next message: Shakespeare: "Re: 9i: Check- constraint Upper(Column)"
Previous message: DA Morgan: "Re: Comparing databases (Oracle, etc.)"
Next in thread: fitzjarrell_at_cox.net: "Re: migrate ORACLE TO SQL"
Reply: fitzjarrell_at_cox.net: "Re: migrate ORACLE TO SQL"
Reply: news.verizon.net: "Re: migrate ORACLE TO SQL"
Reply: Robert Klemme: "Re: migrate ORACLE TO SQL"
Reply: Mark D Powell: "Re: migrate ORACLE TO SQL"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message