Hi,
I have a client who uses a SQL 7 based system to track applications for job vacancies. They are using a VB program to maintain the database.
They now wish to have a web-based version of the database which the candidates can view the progress of thier applications. I've setup a Qube ( with FreeTDS/PHP/MySQL )to handle a new version of the database which works fine.
The problem arises when the client updates data on the SQL server and I need to keep the web version up to date. ( The web version updates both the SQL and MySQL servers but the data is only grabbed from the web server ). I've toyed with the idea of running 12 hourly backups of the SQL server which in turn rebuilds the MySQL server but this means the data on the web version will be out of sync with the local version.
Is there any other way around this problem besides asking the client to use the web version for updates?
