Database Export / Auto Upload - View Single Post

Vodo4321 · 10-23-2009, 11:11 AM

Ok so here's my situation.

At work we use a software package that covers everything from our work order scheduling to our invoice creation. The program runs off a Sequel Server database and in the database there's the Product table that holds all the info for our sellable products.

On my website I'm building a quick little php lookup form so whichever technician is on overtime on a given night can check the product list and get pricing information. My web host has support for MYSQL databases.

So what I need is an application or something that'll take the info from the Sequel database on my internal server convert it if necessary and upload it (nightly?) to the MYSQL database on the offsite web server.

Right now I've got an application called FlySpeed data exporter to get the Sequel database into excel or other formats I may need, but unfortunately it dosent do remote uploads that I've seen.

So is what I'm after possible? And if so any application reccomendations?

10-23-2009, 11:11 AM	#1 (permalink)
Vodo4321 Dying of Chronic Procrastinitis Join Date: Jun 2007 Posts: 419 +8 Internets	Database Export / Auto Upload Ok so here's my situation. At work we use a software package that covers everything from our work order scheduling to our invoice creation. The program runs off a Sequel Server database and in the database there's the Product table that holds all the info for our sellable products. On my website I'm building a quick little php lookup form so whichever technician is on overtime on a given night can check the product list and get pricing information. My web host has support for MYSQL databases. So what I need is an application or something that'll take the info from the Sequel database on my internal server convert it if necessary and upload it (nightly?) to the MYSQL database on the offsite web server. Right now I've got an application called FlySpeed data exporter to get the Sequel database into excel or other formats I may need, but unfortunately it dosent do remote uploads that I've seen. So is what I'm after possible? And if so any application reccomendations?