Re: Import MS SQL Server 2000 DB into Oracle EE 8.1.7

Hi,
Ms sql server itself has a migration utility which is better than Oracle's, and supports more diverse kinds of database and data types. I myself used that utility for transfering data from text files into oracle 8.1.7
give a try
cheers :)

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, November 25, 2001 9:30 PM

> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: yilmaz
  INET: yilmaz_at_hwajet.com.tw

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).