Jyoti,
The Migration Workbench is designed to migrate the
structure and data. It's available as a free download
(once you register) from http://technet.oracle.com
HTH,
- Anita
- "S.Jyotinarayan" <ncjyoti_at_yahoo.com> wrote:
> I have done a typical installation of Oracle 8i EE.
> I have the following:
>
> Ora-OraHome81 -> Enterprise Manager -> Migration
> Assistant
> Ora-OraHome81 -> Migration Utilities -> Oracle Data
> Migration Assistant
>
> I do not have Oracle Migration Workbench installed
> (where would it be, if i need it?).
>
> If Oracle Migration workbench works well for
> migrating the design of a MS SQL Server 2000
> database to Oracle. What can I do for migrating the
> data too?
>
> Thanx a lot in advance
> Jyoti.
>
> ----- Original Message -----
> From: Clinton Naude
> To: Multiple recipients of list ORACLE-L
> Sent: Thursday, November 22, 2001 4:45 PM
> Subject: RE: Import MS SQL Server 2000 DB into
> Oracle EE 8.1.7
>
>
> Can't do the data, but the design yes.
> Oracle provides a tools called Oracle Migration
> qworkbench that works pretty well.
> Make sure that you change the table owner names
> etc to the correct owner.
>
> Good luck.
>
> Clint
> -----Original Message-----
> From: S.Jyotinarayan [mailto:ncjyoti_at_yahoo.com]
> Sent: Thursday, November 22, 2001 12:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Import MS SQL Server 2000 DB into
> Oracle EE 8.1.7
>
>
> Hi all,
>
> How do I import a MS SQL Server 2000 database
> (design and data) into Oracle EE 8.1.7 (typical
> installation) ?
>
> Thanx in advance
>
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Sun Nov 25 2001 - 07:51:58 CST
