so the current solution im working on now is to store the data from the first database in arrays, and after i'm done with storing the data, i run another loop to store the data from the arrays to the other database. but guess what I have a table with more than 20000 records o.O each record have about 12 columns, so i need 12 arrays each one will store 20000 value, it's not a professional solution as you see.
can you tell me how to connect 2 different databases at the same time so I store the values in one variable only?
and is it safe to store 20000X12 = 240000 value in the memory at the same time? (Stupid question, i know it's not)
thanx in advance