From ncjyoti@yahoo.com Sat, 24 Nov 2001 22:12:45 -0800
From: "S.Jyotinarayan" <ncjyoti@yahoo.com>
Date: Sat, 24 Nov 2001 22:12:45 -0800
Subject: Re: Import MS SQL Server 2000 DB into Oracle EE 8.1.7
Message-ID: <F001.003CC564.20011124215018@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



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="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
  ----- Original Message ----- 
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  Clinton Naude 
  
  To: <A href="mailto:ORACLE-L@fatcity.com" 
  title=ORACLE-L@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 color=#0000ff face=Arial 
  size=2>Can't do the data, but the design yes.
  <FONT color=#0000ff face=Arial 
  size=2>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.
  <FONT color=#0000ff face=Arial 
  size=2> 
  Good 
  luck.
  <FONT color=#0000ff face=Arial 
  size=2> 
  <FONT color=#0000ff face=Arial 
  size=2>Clint
  
    <FONT face=Tahoma 
    size=2>-----Original Message-----From: S.Jyotinarayan [<A 
    href="mailto:ncjyoti@yahoo.com">mailto:ncjyoti@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