Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
To: <A href="mailto:ORACLE-L_at_fatcity.com"
title=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 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_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 - 00:12:45 CST
![]() |
![]() |