Re: Data export question (general and very vague)

2009-02-06 Thread Tom Chiverton
On Thursday 05 Feb 2009, Seamus Campbell wrote: The data I will need to access is on an in-house MySql database. I have to have the website on an external commercial server. Any clues on the best way to update the external database (which can be MSSQL or MySQL) efficiently. It needs to be

Data export question (general and very vague)

2009-02-05 Thread Seamus Campbell
Hi I have just been asked to quote (roughly) on a job. The data I will need to access is on an in-house MySql database. I have to have the website on an external commercial server. Any clues on the best way to update the external database (which can be MSSQL or MySQL) efficiently. It needs to

Re: Data export question (general and very vague)

2009-02-05 Thread Jason Fisher
The easiest would be for the server admin of the MySQL box to allow access by the external web server, so that the web server can have a JDBC connector pointing directly at the source data. Then the JDBC connector could be used either to run the website directly or to feed a scheduled data