Re: Oracle Migration Workbench
Date: Fri, 04 Feb 2005 17:25:09 +0100
> 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
>>>platforms? What am I supposed to do? Install the migration
>>>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?
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 BortelReceived on Fri Feb 04 2005 - 17:25:09 CET