Hi. I work on a site that has development, preview/testing, and production environments. These are fully independent right down to the database environments. It's all Oracle on the back end. I've taken care that the data structure is identical from environment to environment. However, the data itself is a little trickier. Some of it is basic data that I set up when the tables are established. But some stuff gets entered later, and I am trying to figure out a clever way to move data from one of the db environments to another. I could, of course, pull the data, try to have cf spit out sql statements that I then paste into another page, but I am wondering whether there is some smarter way? I am imagining some simple export format that I import on the other boxes. Note: this is probably obvious, but just in case: the CF servers are all independent, so no CF code can access another server's DBs. Thanks, Matthieu
Pfizer Information Center ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm