During my nightly service cycle (batch file) I copy my db files to a new location just after taking the db service down. Then I bring the service(s) back up and, still in the same batch file, zip up the db files. Several minutes later a scheduled ftp operation pulls down the zipped db's. Several minutes after that another scheduled batch file on my dev server replaces the old db files with the just-downloaded new ones.
If you are trying to make an up-to-date backup of CFM/HTML files that maybe users in different places have posted, your scheduled ftp operation should also run a synch as well as a download. I use FTP Voyager and it does this very neatly, and in my case more reliably than WS_FTP Pro. Personally I prefer to develop in an area not molested by automated synchs and downloads, so my synch (not the db part) is actually making a copy to a different location on my dev box. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -----Original Message----- From: Richard Colman [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 03, 2002 5:50 PM To: CF-Talk Subject: Coordinating updates in two sites Here is a problem that many of you must face, i.e. how to synchronize updates in between production sites and development sites. For example, assume a situation where you have one production site and one development site. The production site has content updates on a regular basis. New sections and functions are being built on the development site. Synchronizing these updates and new sections is becoming a time-consuming pain. Are there any tools or techniques out there to simplify or automate the synchronization process. Any suggestions appreciated. Rick Colman ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

