I know this is a strange question, but what I need to know is this.

Just for some background, I have a client who I've developed a site for in SS. Soon they are going to have a page of services for the public to search on, this will be quite a large database. All straight forward so far right?

Wrong, (this is where it gets tricky) the client will obviously be able to update the site themselves only the building their offices are in is reputable for having bad internet connections. For this reason they want an offline version of the database they can update and then import to the live site. My initial thoughts are to have an intranet as this is something they can make use of anyway, and to run the same SS pages as on the website so they always have access to the information. The only question then is how do I sync the website with the intranet? The intended use would be that they work on the intranet and then migrate that data to the website.

Apart from exporting CSV files from phpMyAdmin does anyone know of a more automated process of doing this that isn't too difficult for the client?

Thanks

Excellent, that is what I needed to know.

I found this incase anyone else needs it

http://doc.silverstripe.org/doku.php?id=staticpublisher#multiple_server_caching

and also of interest

http://www.silverstripe.com/scaling-silverstripe-with-caching/

Thanks