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
– Teson, Commented Mar 16, 2011 at 13:03
Scheduled, that's why I have to use a batch file that runs a PHP script — 130nrd
– 130nrd, Commented Mar 17, 2011 at 1:57

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

0

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.

answered Mar 16, 2011 at 13:02

Simon H

1,74512 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

130nrd Over a year ago

Thank you for the reply. But I need to do it automatically on scheduler. That's why I have to use a batch file to run a PHP script to copy the records.

Collectives™ on Stack Overflow

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

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related