Migration from SQL Server to Oracle database
- From: Krishna <krishna.setwin@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx, krishna.setwin@xxxxxxxxx
- Date: Fri, 11 Nov 2011 21:34:53 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
