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:195456 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
