On Apr 2, 6:48 pm, "news.free.fr" <grill...@[EMAIL PROTECTED]
> wrote:
> 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
With MS SQL Server 2k you could use DTS, there is probably a similar
tool for MS SQL Server 2005.
Kind regards
robert


|