kangz

Thanks. I am wondering though how you are going to update the remote server which is mssql from the php script. If you can help me with the entire code both on php and mysql i will appreciate so much. Im "intermediate level" with both. You can assume the following details: mysql server : localhost (testsvr0) database: demographics_dbo table: tbl_biodata (id, fname, dob, staffid) mssql server: mssqlsvr0 database: employeedb table: tbl_biodata (id, fname, dob, staffid) Thanks.

I have the libraries enabled (mssql for php) and i would love to have the part where you say "..from within the select loop.." thats where i figure out i would have a problem on how to go about it.

Hi, I have a linux server that I am using to run mysql 5 with a demographics database on it. I would like to update another remote database running ms sql server (2005 i think) with the same demographic data, all this from within the mysql server (or using php script if necessary) since that is where I have control. Any idea how to achieve that? Thanks.