>- see footer for list info -< Yes, that's a jolly good idea indeed. You listen to Mr Russ. He's a clever fella.
You see them flies on him? No you don't, because there aren't any. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Snake Sent: 06 April 2006 16:16 To: 'Coldfusion Development' Subject: RE: [CF-Dev] Data transfer guidance >- see footer for list info -< Further simplifying that, it might be possible to create a DTS on the SQL Server that connects directly to foxpro and imports the data, without any need for the application layer at all. Rsus -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Smyth Sent: 06 April 2006 12:37 To: 'Coldfusion Development' Subject: RE: [CF-Dev] Data transfer guidance >- see footer for list info -< Hi Lee I'm surprised that you can't use a dev copy of CF on the machine but basically I would do it this way regardless of the technology used, 1. Schedule a task to create a CSV file of the data. 2. Have another task to FTP it to the SQL Server box. 3. Once its on there have a scheduled TASK(could use DTS package or CF for this) to import the CSV file I think that's probably the easiest way to do what you are after, I would recommend you apply error handling to each step though just so you are notified of issues etc hth Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee Fortnam Sent: 06 April 2006 12:23 To: 'Coldfusion Development' Subject: [CF-Dev] Data transfer guidance >- see footer for list info -< Afternoon All, Just looking for some advice really. I have a Fox Pro database which resides at 1 location, this location has permanent internet access, I need to (on a daily basis) capture some information from the Fox Pro Database and send this information to a remote location (web site) for capture into a SQL database. Due to the security of the location where the Fox Pro system is, I need to have a system inside the location so that the information is sent out rather than pulled from outside. Need to try and keep the costs down, thinking Blue Dragon 6.2.1 Server (Free) could sit on a machine inside the location and pick information from the DB and then send it using something like CFHTTP over to my waiting CF Server so that it can receive the data and put it into the SQL DB. I know the Development version of CF can do what I want to do but licensing issues prevent me from doing it this way, but at least in principle it works. Would CFHTTP be the best way to send the information out, there could be about 9000 records to send over on a daily basis, limited information in each record but would converting it to XML and posting by CFHTTP be the best??????? Would welcome any comments on the proposed plan and any guidance you guys/gals have. Lee Fortnam _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
