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

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Sun, 25 Nov 2001 02:57:05 -0800
Message-ID: <F001.003CC5BD.20011125023017@fatcity.com>

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..
<FONT face=Arial color=#0000ff
size=2> 
<FONT face=Arial color=#0000ff
size=2>HTH
<FONT face=Arial color=#0000ff
size=2>Mark

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of S.JyotinarayanSent: 25   November 2001 05:50To: Multiple recipients of list   ORACLE-LSubject: 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.
  <BLOCKQUOTE dir=ltr
  style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message -----
  <DIV
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Clinton Naude To: <A title=ORACLE-L_at_fatcity.com href="mailto:ORACLE-L_at_fatcity.com">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     

<FONT face=Arial color=#0000ff

    size=2>Can't do the data, but the design yes.
<FONT face=Arial color=#0000ff

    size=2>Oracle provides a tools called Oracle Migration qworkbench that works     pretty well.
<FONT face=Arial color=#0000ff

    size=2>Make sure that you change the table owner names etc to the correct     owner.
<FONT face=Arial color=#0000ff

    size=2> 
<FONT face=Arial color=#0000ff

    size=2>Good luck.
<FONT face=Arial color=#0000ff

    size=2> 
<FONT face=Arial color=#0000ff

    size=2>Clint     

      <FONT face=Tahoma 
      size=2>-----Original Message-----From: S.Jyotinarayan [<A 
      href="mailto:ncjyoti_at_yahoo.com">mailto:ncjyoti_at_yahoo.com]Sent: 
      Thursday, November 22, 2001 12:45 PMTo: Multiple recipients of 
      list ORACLE-LSubject: 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 Received on Sun Nov 25 2001 - 04:57:05 CST