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

[S.Jyotinarayan]

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