I think this is a little off topic, but I think the easiest way if you have SQL server is a DTS job.. That can allow you to move the data back and forth and massage it a little. Now, if you are doing a ton of data manipulation as you move the data, then maybe Torque is worth it.. But I think moving data via SQL is easiest done via DTS or writing your own sproc using linked servers..
A little off topic. We used to have a VB module doing this type of thing, and it was HELL.. People would log off the vb machine, or not have the right permissions. I think Torque and Turbine is better. Also, check out the Jcrontab package, I added a turbine service for it. Eric -----Original Message----- From: Chris K Chew [mailto:chris@;fenetics.com] Sent: Monday, October 21, 2002 4:19 PM To: [EMAIL PROTECTED] 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>
