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

[Mark Leith]

How about trying the other way around - pushing the data from SQLServer to Oracle? There was a tool in SQL7 (not sure if they still have it in SQL2000 but I should think they do) called DTS (Data Transformation Service), that will transfer your tables with the data over to Oracle.. Have a read up about it to see if it fits your requirements..   HTH Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of S.Jyotinarayan Sent: 25 November 2001 05:50 To: Multiple recipients of list ORACLE-L Subject: Re: Import MS SQL Server 2000 DB into Oracle EE 8.1.7 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