I have recently moved my website to a new web hosting company. While the former company suffered from almost daily outages, the new company keeps the site up and functioning, but periodically reports server busy messages. The CF site uses Access as a back-end. Their solution is for me to change the site to SQL Server. The necessary programming and database changes are not a problem. The problem is content updates. Currently, I have two access databases on the site. The first database contains the user information for the site (user registrations, shopping cart, orders, etc.). The second database contains the site content. The first database contains links to the second database. Only the first database is referenced by the CF pages. When site content needs to be updated, I simply replace the second database with an updated version. The data is unavailable only for the time it takes to do a file rename using FTP. If I switch the site to SQL Server, I am unsure what is the best way to update the site content with the least amount of impact on uptime and site availability. Yes, I understand that a couple of minutes every week or so is much better than Server Busy messages many times a day, but I am still concerned. Is anybody doing anything similar to this? What is the best way to do this? I estimate that if I were to truncate the tables and import the data, the entire process would take less than a minute. It would be nice to be able to automate this so that the content manager could do it himself. John Keane Sr. Team Leader, Information Systems Watson Wyatt Data Services 218 Route 17 North Rochelle Park, NJ 07662 EMail: [EMAIL PROTECTED] TEL: 201-226-3419 FAX: 201-843-0101 ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
