MsSQL - PHP - MySQL Need Help!

[jzdexta]

Hi,

 

I'm not sure i should make my post here, i just found it appropriate as im still exploring php/mysql/mssql.

 

To begin with, i have a primary server running mssql located at the office. There's going to be a secondary server located in another site, in this site a secondary server will be running L.A.M.P..

 

My issue is that information from the primary server must be copied to the secondary server every half hour definitely on the first run it will be all the info. but there after it will be just updates to the secondary.

 

My question is, is it possible through PHP to copy data from a remote mssql database and copy to a mysql database without having to create some form of temporary data storages; if yes how do i go about it?

 

Secondly, clients have to connect to the temporary database over the internet and would like to implement secure http from login to viewing their online reports; again how do i go about this?

 

Lastly, on one of the pages, the content changes every half hour and the client must be in a position to see the changes (if any), how do i make the page refresh every half hour or once there's a refresh in the secondary database?

 

Hope to have supplied adequate information, in the case of further clarification, please feel free to ask.

Thank you in advance.