All the datasource information is stored in XML (/WEB-INF/cfusion/lib/neo-query.xml, if I recall correctly) files, and on CF8 you can just drop the XML files into another non-running server and start it up. On CF9 there is some additional security to prevent this.
However, you can use the CFADMIN API to script the creation of all your datasources (and all your other admin settings). That's definitely the route I would take. Build yourself a configuration file per environment, and then use that to bootstrap your CF instance when it starts up. Works like a champ, and you can store your bootstrap file in version control to keep track of it. Plus, because it's code, you'll never have to worry about servers being configured differently for the same version of code AND you can have different server configuration move out with your code so you don't get out of sync. cheers, barneyb On Tue, Aug 10, 2010 at 9:48 AM, Wally Randall <[email protected]> wrote: > > I am faced with a difficult deployment situation. I have eight production CF > servers running CF8. We have about 10 SQL server and Oracle database > occurances supporting those CF applications. > > Our agency is going to create a failover server system at our off-site > emergency location with the following characteristics. All Database server > names will be changed. All IP addresses for all servers will be changed. > > We have 130+ CF datasources defined on the webservers which we need to > "migrate" to the failover location. My datasources all reference specific > database server names and need to be modified on the target machines. > > Has anyone else had to deal with this problem? Any suggestions? Is there > anyway to create the datasources from a source loaded at server startup? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-server/message.cfm/messageid:6893 Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-server/unsubscribe.cfm
