Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle Migration Workbench

Re: Oracle Migration Workbench

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 04 Feb 2005 17:25:09 +0100
Message-ID: <cu07i2$b7f$1@news3.zwoll1.ov.home.nl>


amerar_at_iwc.net wrote:
> Frank van Bortel wrote:
>

>>amerar_at_iwc.net wrote:
>>
>>>Hi All,
>>>
>>>I need to convert a SQL Server running on Windows 2000 to Oracle
>>>running on HP-UX.
>>>
>>>Will the migration utility do this, even though they are on

>
> different
>
>>>platforms?   What am I supposed to do?  Install the migration

>
> utility
>
>>>on both platforms?
>>>
>>
>>Install a network...
>>Connect your Workstation to the network, and both servers.
>>Make sure you can connect to both servers, using the
>>appropriate network stacks (this may require installation
>>of things like an 'Oracle Client' on your Workstation)
>>Install the Oracle Migration Workbench on your Workstation,
>>as well as the Microsoft SQL Server plugin for the Migration
>>Workbench.
>>
>>Oracle is platform independent, so the OMWB really doesn't
>>care about Windows or HP-UX, nor does your Client.
>>
>>In fact, your Workstation may be running Fedora Core 3,
>>as far as the client is concerned. The OMWB is for MS Windows
>>only, I believe.
>>--
>>Regards,
>>Frank van Bortel

>
>
> Well, I was pretty sure that both machines would need to be connected
> to the network. What I am curious about is how the migration utility
> will take the SQL SERVER database on Windows and transfer it, or put it
> onto the HP-UX box. I mean, they are totally different operating
> systems. I'm sure that the migration utility does not care, but during
> the migration, does it not need an Oracle database and an Oracle Home
> so it knows where to put all the new datafiles and such???
>
> Or, do I need to install Oracle on the Windows box, migrate the
> database, then transfer it to an Oracle install on the HP-UX box?
>
> Thanks,
>
> Arthur
>

Ah - wrong exit.
OMWB will migrate data (and procedures) not complete databases!
You will have to build (create) a database on HPUX; the result of the migration from OMWB will be a set of scripts, with which you can:

* create objects, oracle wise (tables, views, sequences, triggers...)
* extract data from SQL Server
* insert extracted data into Oracle
-- 
Regards,
Frank van Bortel
Received on Fri Feb 04 2005 - 10:25:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US