开发者

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

开发者 https://www.devze.com 2023-02-17 08:21 出处:网络
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

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消