Make your datasource a variable defined in the application.cfm. Switch the datasource between databases as needed by changing the application.cfm. It will not matter if the databases are on the same machine or not as they can have different names and you can change what CF is looking at very easily.
Justin > -----Original Message----- > From: paul smith [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 13, 2003 10:16 AM > To: CF-Talk > Subject: SQL7 DB Update Procedure > > The on-line database of listings, etc, at > www.SMARTERYellowpages.com , > Biz1, is read-only in normal operation. > > The off-line database, Biz2, is not read-only in normal > operation, and it > is currently updated daily on a backup machine, including > automatic backup, > and updating of full-text indexes (SQL7). It's backup is used > to update > Biz1. Since the 2 databases are on different machines, they > can and do > have the same name. Updating of Biz1 is a simple restore > using the most > recent Biz2 backup, followed by updating the full-text index. > > Is there a way to have Biz1 & Biz2 on the same machine, and: > > To update Biz1, switch Biz2 to read-only. > Switch www.SMARTERyellwpages.com to read from Biz2 instead of Biz1 > Update Biz1 using the latest backup of Biz2. I haven't tried > this but I > wonder how to work around the difference DB names - or even > if the name > difference matters. > > best, paul > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
