Hi Chris, I wrote something VERY similiar using Turbine/Torque/Castor & xml-rpc.
Basically it's a scheduled xml-rpc job that queries an Oracle database, writes the records to a stream in xml format which is transported to the client side. Here I reinitialise the objects and again use Torque to update the Mysql database. Works a treat. One question from my side, why would you consider writing a VB module for this? /colin ----- Original Message ----- From: "Chris K Chew" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 21, 2002 10:19 PM Subject: Syncing the local DB from a remote DB > Hello. > > I get to pull information out of a legacy unix system (fortunately it > supports SQL and ODBC!) and put it into SQL Server for web-based reporting > using Turbine. One idea I had was to use Torque and the SchedulerService. > Has anybody tried this? If so, how was your experience? > > Does anybody have other ideas? Mine include writing a VB module and running > it from the windows task scheduler of the SQLServer Job Scheduler, or using > the SQLServer Job scheduler to run a SELECT INTO sql statement. > > Thanks in advance, > > Chris > > > -- > To unsubscribe, e-mail: <mailto:turbine-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:turbine-user-help@;jakarta.apache.org> > > -- To unsubscribe, e-mail: <mailto:turbine-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:turbine-user-help@;jakarta.apache.org>
