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