Migration from SQL Server to Oracle database

From: Krishna <krishna.setwin_at_gmail.com>
Date: Fri, 11 Nov 2011 21:34:53 -0500
Message-ID: <CAF6DRCoDL-4_ZjacSPri75RknZXzOFvPv-2RV2o_ewWrJekYTA_at_mail.gmail.com>

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


Received on Fri Nov 11 2011 - 20:34:53 CST

Original text of this message