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

Friends, how to copy records from Remote SQL Server 2005 using PHP in Local MySQL table? (Remote SQL Server 2005): Select from source_View * Field: Username, First name, Last name, Email, NIC

(local mySQL): target_table from

Please select / field from: username, firstname, last name, email, idnumber

please help, thanks ..

This will not work because you can not do a SQL statement, which records from two different hosts at a time. Why do not you just take the SQL dump of the table and import it using MySQL.