RE: Migration Project: MSSQL to Oracle
- From: "Bobby Curtis - ACE" <curtisbl@xxxxxxxxx>
- To: <niktek2005@xxxxxxxxx>, "'ORACLE-L'" <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 11 May 2014 16:35:46 -0400
Are you looking to write a tool to do the migration? Are you prohibited from
using Oracle GoldenGate? There are tools that are designed to this already,
please explain in more detail why you want to write a new tool.
Thanks
Bobby
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Nik Tek
Sent: Sunday, May 11, 2014 4:16 PM
To: ORACLE-L
Subject: Migration Project: MSSQL to Oracle
Hi,
I have a question about migrating data from MSSQL and Oracle.
I'm working on a migration project from MSSQL and Oracle.
I have around 1040 tables on source (MSSQL) side, database size could be around
100-300 GB.
I would have to do this operation repeatedly, so I'm thinking of creating it as
a tool (command line based).
Could anyone give me some guidelines on how to achieve it.
* I have already created the destination schema on Oracle(Converted all SPs,
Triggers, Tables, Views, Functions to pl/sql compatibility). I have to migrate
data ONLY between source and destination databases.
Source: MS SQL 2008 R2
Destination: Oracle11g R2
I have used Oracle's SQL Developer Migration Tool, but I'm not sure if I can
bundle it as part of my software, as this tool is going to be free to the
community.
Thank you
NikTekki
Other related posts:
