RE: Migration tool - Data Integrator or Migration Workbench
- From: kathy duret <katpopins21@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 31 Oct 2007 10:21:57 -0700 (PDT)
I was wondering if doing it via sqlloader, dumps etc would be better than
Migration Workbench. I tried OMB about 2 years ago and found it clumsy but I
thought maybe it
had improved.
We have Data Integrator and I was hoping that maybe someone would know about
it.
I am trying to shave corners. They are trying to hire another apps dba here
to help out but in the meantime........
Thanks for all the help, advice and jokes are always welcome......
Kathy
"Kerber, Andrew W." <Andrew.Kerber@xxxxxxx> wrote:
Depending on your data dictionary accessibility and sql skills, you
could generate the commands to create the tables and scripts, if you can
generate the text files to load them.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Gints Plivna
Sent: Wednesday, October 31, 2007 10:16 AM
To: katpopins21@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Migration tool - Data Integrator or Migration Workbench
2007/10/31, kathy duret :
> So any thoughts to share?...
SQL Loader/External tables can work with any DB assuming you can get
text files out of your old sources. Of course the downside is that you
have to manually create tables and scripts.
Gints Plivna
http://www.gplivna.eu
--
//www.freelists.org/webpage/oracle-l
------------------------------------------------------------------------------
NOTICE: This electronic mail message and any attached files are confidential.
The information is exclusively for the use of the individual or entity intended
as the recipient. If you are not the intended recipient, any use, copying,
printing, reviewing, retention, disclosure, distribution or forwarding of the
message or any attached file is not authorized and is strictly prohibited. If
you have received this electronic mail message in error, please advise the
sender by reply electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your computer
system. Thank you.
==============================================================================
--
//www.freelists.org/webpage/oracle-l
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Other related posts:
