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

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开发者_如何学C

Fields : username, firstname, lastname, email, nik

into (local mySQL) : select * from target_table

Fields : username, firstname, lastname, email, idnumber

Please help, thank you..

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.