How to copy records from remote SQL Server 2005 to local mySQL using PHP?

Question

Guys, how to copy View records from REMOTE SQL Server 2005 to a Table on LOCAL mySQL using PHP?

from the View (REMOTE SQL Server 2005) : select * from source_View
Fields : username, firstname, lastname, email, nik

into (local mySQL) : select * from target_table
Fields : username, firstname, lastname, email, idnumber

Please help, thank you..

one time only or scheduled? ODBC-access? migrating tool if so, if not, I'd script with php/xml. — Teson
Scheduled, that's why I have to use a batch file that runs a PHP script — 130nrd

Simon H Simon H · Accepted Answer · 2011-03-16T13:02:50

This will not work as you cannot have an SQL statement that processes records from two different hosts in one go. Why don't you just get sql dump of the table and import it using MySQL.

How to copy records from remote SQL Server 2005 to local mySQL using PHP?

1 Answers