I have two server msql and psql. I am fetching data from msql server database table and inserting it into my psql server. The way I am doing is by selecting all the column from mysql server and saving it into an array.

sql->prepare("SELECT id, date,studentName, FROM student", array());  variablArray= array(); 

Then inserting the data in psql with the help of implode().

psql->prepare("INSERT INTO student",implode(",", $  variableArray); 

The problem is every time I ran the query I too 45 min to complete, because I truncate the psql database table before inserting so that the query can run.

Is there is an another way to do this;

Thanks