Hi Diane - I'm confused - why does your client want to download the entire SQL DB each day? Is it just for backup purposes?
Todd -----Original Message----- From: Diane Schips [mailto:[EMAIL PROTECTED] Sent: Monday, January 02, 2006 10:52 AM To: [email protected] Subject: [wdvltalk] Download of web db ro desktop via VB Didn't change the subject last time, sorry! Diane Schips wrote: > I hope everyone's New Year is off to a good start! > > I need to provide a backup solution for a customer for his website's > SQL database. He says his people can't handle using ftp to download > the files to the desktop. Not that FTP would help for an SQL > database, but this gives you an idea of the situation. > > I wrote a VB application that uses inet to connect to the SQL > database, and copies the data one record at a time to Access databases > on the desktop (after first emptying them). This works fine except > some records seems to have funky data that causes errors, and the > files take forever to download. My customer wants to do a daily > download, but it looks like it will take most of a day to do the > download! The tables are pretty big! > > I s this the best way to do this? My customer would prefer a webpage > that does the download, but I've never tried to copy anything to a > customer's computer from the web, and wouldn't this still require > copying the records into an Access database, this time on the server? > > Thanks, > Diane ____ • The WDVL Discussion List from WDVL.COM • ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.9/217 - Release Date: 12/30/2005 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.9/217 - Release Date: 12/30/2005 ____ • The WDVL Discussion List from WDVL.COM • ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: unknown lmsubst tag argument: '' To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
