Re: Migration from SQL Server to Oracle database

From: Krishna <krishna.setwin_at_gmail.com>
Date: Sat, 12 Nov 2011 16:17:22 -0500
Message-ID: <CAF6DRCr0fNGmDmf8S32wfE=00aZ9oM3khjVxK0RCBmsdepCehw_at_mail.gmail.com>

we need to convert sql server databases only once to oracle. I understand that, even though we use once for initial data loads, we need to pay the license for all cores in oracle database. same thing for gateways... Am I right ?
Once we migrate to oracle, the sql server database servers will be decommissioned.

Martin, I understand that I need to change data types for cols. sql server databases will become schemas in oracle. Should I make any other physical design changes?

On Sat, Nov 12, 2011 at 1:55 AM, Martin Berger <martin.a.berger_at_gmail.com>wrote:

> 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 - 15:17:22 CST