niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Oracle » Tools
Oracle Migration Workbench
Post new topic   Reply to topic Page 1 of 1 [5 Posts] View previous topic :: View next topic
Author Message
amerar@iwc.net
*nix forums Guru Wannabe


Joined: 27 Jul 2005
Posts: 185

PostPosted: Mon Feb 07, 2005 8:14 pm    Post subject: Re: Oracle Migration Workbench Reply with quote
Well, when you build the Oracle database and migrate the old database,
how does it know which tablespaces to place things in? Or does it do
it in some default tablespace, and you have to perform the maintenance
later?

Thanks,

Arthur
Back to top
Frank van Bortel
*nix forums Guru


Joined: 19 Apr 2005
Posts: 804

PostPosted: Fri Feb 04, 2005 3:25 pm    Post subject: Re: Oracle Migration Workbench Reply with quote
amerar@iwc.net wrote:
Quote:
Frank van Bortel wrote:

amerar@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
Back to top
amerar@iwc.net
*nix forums Guru Wannabe


Joined: 27 Jul 2005
Posts: 185

PostPosted: Thu Feb 03, 2005 1:45 pm    Post subject: Re: Oracle Migration Workbench Reply with quote
Frank van Bortel wrote:
Quote:
amerar@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
Back to top
Frank van Bortel
*nix forums Guru


Joined: 19 Apr 2005
Posts: 804

PostPosted: Wed Feb 02, 2005 8:57 pm    Post subject: Re: Oracle Migration Workbench Reply with quote
amerar@iwc.net wrote:
Quote:
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
Back to top
amerar@iwc.net
*nix forums Guru Wannabe


Joined: 27 Jul 2005
Posts: 185

PostPosted: Wed Feb 02, 2005 8:18 pm    Post subject: Oracle Migration Workbench Reply with quote
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?
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [5 Posts] View previous topic :: View next topic
The time now is Wed Jan 07, 2009 11:34 pm | All times are GMT
navigation Forum index » Databases » Oracle » Tools
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Move Oracle 10g database to another location Selt Server 0 Fri Jul 21, 2006 2:14 pm
No new posts Oracle runtime Spitfire Server 0 Fri Jul 21, 2006 1:18 pm
No new posts Oracle Text Score Computation jatinder.1975@gmail.com Server 0 Fri Jul 21, 2006 1:00 pm
No new posts Can a trigger insert records into another oracle server Tauqir Server 2 Fri Jul 21, 2006 12:27 am
No new posts Moving Oracle filesystem to SAN howard Server 1 Thu Jul 20, 2006 11:49 pm

Buy WoW Gold | Myspace Backgrounds | Debt Consolidation | Credit Card | Ringtones
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.1694s ][ Queries: 20 (0.0873s) ][ GZIP on - Debug on ]