Re: data move concept
Date: Mon, 24 Aug 2009 09:38:20 +0200
If you are really talking about concepts, you could also look into Oracle Warehouse Builder (OWB) and/or Oracle Data Integrator (ODI). Underneath both will use the techniques described in the other reactions, of course. But if you are talking about error trapping and re-runable and not too much coding yourself, you could look into one or both of these options.
2009/8/18 Zelli, Brian <Brian.Zelli_at_roswellpark.org>
> Hello all,
> I have systems that need to take data from other systems like most of
> you probably have to do. I need to take from sql server and other oracle
> systems. I can do it the old fashion way of creating flat files, ftp and
> sqlload. But with the tools of 10g is there a better way? Something that
> is reliable, re-runnable, error trapping, etc.....
> I tested some things like:
> - DTS from sql server 2000 into a temp table and then ran scripts against
> the temp table
> - Created a link to oracle and did a select into
> - flat file and sqlload
> Anything else? I just want to try and use something current and reliable
> for moving and loading data. I am open to all kinds of ideas.
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.