How to copy data from one database to another database efficiently?
What about using one of the existing ETL tools? Talend ETL or Pentaho Data Integration are two examples (performance-wise PDI is better).
You can design an ETL job then schedule to run it as you like.