Using CF, if I did a select * from File on the ISP database is there an SQL statement I could use to do the insert on the local box without looping? Using Query of Queries perhaps?
Lee On Fri, 18 Feb 2005 14:07:04 -0600 "Lee" <[EMAIL PROTECTED]> wrote: > No it's on a shared server so I have little control and > special backup recovery is charged extra. Maybe I need a > new ISP? > > Lee > > On Fri, 18 Feb 2005 13:53:49 -0600 > "Eric Creese" <[EMAIL PROTECTED]> wrote: >> can you not make a back up of the db and FTP the bak >>file to your server or set up a job that could right the >>backup toa remote server? >> >> -----Original Message----- >>From: Lee [mailto:[EMAIL PROTECTED] >> Sent: Friday, February 18, 2005 1:29 PM >> To: CF-Talk >> Subject: Getting SQL Data >> >> >> I have an SQL database that is on a shared server at an >> ISP. I would like to keep a daily or weekly copy of the >> data locally. When I use the VPN to connect and use SQL >> Enterprise manager, using DTS to transfer data always >> fails in one way or another. It usually leaves several >> tables empty with an unknown error code. Getting routine >> backup files from the ISP would be costly. Is there a >>way >> I could use CF or another tool to transfer my data >>locally >> without a lot of effort? Some files have over 100,000 >> records in them. >> >> Lee Surma >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195494 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
