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??
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
krishna
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 11 2011 - 20:34:53 CST