From mark@cool-tools.co.uk Sun, 25 Nov 2001 02:57:05 -0800
From: "Mark Leith" <mark@cool-tools.co.uk>
Date: Sun, 25 Nov 2001 02:57:05 -0800
Subject: RE: Import MS SQL Server 2000 DB into Oracle EE 8.1.7
Message-ID: <F001.003CC5BD.20011125023017@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



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@fatcity.com 
  [mailto:root@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@fatcity.com 
    href="mailto: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 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@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