OMWB vs DTS (SqlServer2k to Oracle)

From: Krist <xtanto_at_hotmail.com>
Date: 28 Jun 2004 04:44:23 -0700
Message-ID: <cb48a3b.0406280344.dce3d2f@posting.google.com>

Hi All,

I need to do data migration from SqlServer2000 to Oracle 9i. The number of the tables to be transferred is about 130 tables. Some tables has more than 150 columns.
All I have to move is Data, NO SP or trigger .

All I want to do is :
- Create all Tables in MSSql into Oracle

Transfer the Data
Finished !

What tools should I use for this job : OMWB or DTS ?

Using DTS, I have to define the data transfer task one by one. (or is there any automated way for this ?)

Given this condition, is using tools like Oracle Migration Work bench (OMWB) will make it easier ?

Thank you,
Krist Received on Mon Jun 28 2004 - 06:44:23 CDT