Re: Migration from SQL Server to Oracle database

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Sat, 12 Nov 2011 07:55:22 +0100
Message-ID: <CALH8A93O5sF+rpbMcHPHDX_tX=SrdWsjK3TQS_Je8JOBHa5NNA_at_mail.gmail.com>

Krishna,
have you ever thought about Transparent Gateway? [1] I would try to do the DDLs via any tool like SQLDeveloper - probably they can use some hand-made modifications. As SQL Server differs from Oracle in features and weaknesses, it's worth to think about changes of physical parameters of the objects.

hth
 Martin

[1] http://download.oracle.com/docs/html/B10544_01/ch2.htm

On Sat, Nov 12, 2011 at 03:34, Krishna <krishna.setwin_at_gmail.com> wrote:

> I have got 2 questions:
> 1. We are planning to convert our OLTP sql server databases to oracle
> databases. I tried using SQL Developer to migrate a small sql server
> database to oracle database(size 5Gb). It was fine. when I tried to migrate
> another database(size 90G), it is taking too long. The problem with sql
> developer is I cannot choose and pick tables. out of 250 tables, I need to
> migrate abt 80 tables(size will be abt 50G). can anybody share their
> experiences, if any, in converting medium size sql server databases to
> oracle databases? any others options??
>
> 2. I am planning to convert sql server ddl to oracle ddl. I am testing bcp
> out and use sql loader to import the data. Right now, I am manually
> creating oracle tables from sql server tables. I am using
>
> http://download.oracle.com/docs/cd/E11882_01/gateways.112/e12069/apa.htm#BABCIIDI
> to
> convert the code. Are there any other better ways to convert sql server
> DDL to Oracle DDL?
>
> Thanks in advance
>
> krishna
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Nov 12 2011 - 00:55:22 CST