Quite right, Al, on sites that collect user data on the production database. Other sites just have a CMS system that is build on a database and there is no change to teh production database from one week to the next.
It all depends on the applications that are running on the site and how they make changes to the database. I am managing 40+ web sites adn they are mostly small but varied in the apps that are running there. On one, for example, the client makes many changes each week in the CMS on the production database. On that site, I always take a current copy of the database to my dev machine before i do any development work on their site. On another, i run the CMS on my dev machine because it's my own site, and when i have completed al my changes, i upload the database to teh productoin server to publish the week's changes to the site. As i said, it depends. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Jan 7, 2009 at 3:51 AM, Al Musella, DPM <muse...@virtualtrials.com> wrote: > I hate to ask - but if you copy the data from the live server to > your testing server, make a change to the database on your testing > server then upload the database structure and data back to the live > server, what happens to any new data collected on the live server in > the time it takes you to make the change and upload the table? > > I run my own server so I don't have that problem, but if I did, I > would think a better way might be just use cfquery to modify the > database (see http://tutorial28.easycfm.com/) . You can test it > locally then run it on the server to make the database changes.. then > ask the administrator of the server to backup the database to a > password protected directory on your server, and run an automated > task to zip it and download it to your local machine every night.. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317460 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4