Peter Scott wrote:
On Tue, 17 Oct 2006 13:51:13 -0400, Robert Hicks wrote:
I am migrated from Access to Oracle. I have prepped the Access data
(meaning I have cleaned it up).
What is the best "Perl" way to migrate? I am supposing I can do a
"select" query on the Access and do an insert into the Oracle one?
"Best" depends on information you haven't given us. But the simplest way
under many circumstances would be to use DBI to create input files for the
Oracle bulk loader.
The data isn't that large so I am probably just going to do a select
from the Access, use bindcolumn and then pass that to an insert
statement for Oracle.
I loved "Perl Medic". Definately a keeper on my shelf.
Robert
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
