Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: Copying a Database Table Using DBI's execute_array

by ww (Bishop)
on May 03, 2013 at 15:18 UTC ( #1031911=note: print w/ replies, xml ) Need Help??


in reply to Copying a Database Table Using DBI's execute_array

Not to endorse or deny your conclusion, but how did you arrive at "...this next and last statement is probably really wrong." Is there some substantive reason -- like errors or warnings or your computer puking out blue flames -- that leads you to your belief?

IOW, details ... all the details, help us to help you.


If you didn't program your executable by toggling in binary, it wasn't really programming!


Comment on Re: Copying a Database Table Using DBI's execute_array
Re^2: Copying a Database Table Using DBI's execute_array
by plendid (Acolyte) on May 03, 2013 at 17:24 UTC

    It is not a tested statement because i had and have no confidence that it will run correctly. I believe that the $mysql_data = $sql_handle->fetchall_arrayref(); statement creates a reference to an array of arrays. I do not feel confident nor knowledgeable enough to determine how to employ this structure in the execute_array statement.

    Sorry to be vague. I'm so clueless here with this one statement and what execute_array expects that i find it difficult to write my request either more cogently or more coherently.

      «...Sorry to be vague...»

      OK, but can't you:

      1. Dump the mySQL table to CSV using mysqldump
      2. Bulk insert the data into Oracle

      If you need to manipulate your data, you can do something in the bulk insert script or you can use a trigger and a stored procedure...

      Regards, Karl

      «The Crux of the Biscuit is the Apostrophe»

      Still, you could create a small db -- a few columns per record and only a handful of records -- and use that db as a testbed for statements about which you're unsure.

      Among other things, that approach is apt to be quicker than waiting for a workable answer here (and you still won't know if it's a workable answer unless you test it, or the responder provides demo material.

      And, (bonus!) you get the additional experience -- right or wrong -- that will help you on your path to expertise.


      If you didn't program your executable by toggling in binary, it wasn't really programming!

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1031911]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (11)
As of 2014-12-22 22:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (132 votes), past polls