PHP/Mysql/MSSQL Blocked Ports Problem?
I recently moved my website to godaddy shared hosting because my webserver on my local network wasnt fast enough. I had a cron job that ran each night to pull data from my MSSQL server (shipping database) to my MySQL server (reporting database) and everything worked fine. I moved my website out to godaddy, and because they block ports incoming and outgoing on the server, i cannot access my remote database from a local script and i cannot access local databases from a remote script, there for the connection between Godaddy’s mySQL server, and my local MSSQL server is lost. Is there anyway around this, I was thinking if there was a script available to export the data from MSSQL to XML or some other flat file, then putting a script on the remote server to pick up that file via HTTP, and import it into the MySQL Database??? help!!! i found the script to do the import to the remote host, but i still havent found a way to export the MSSQL data…..the problem i’m running into is that this us
