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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
