One way is to use RDBMS facilities to batch transfer data between databases -- SQL-Server has this capability -- I don't know whether Oracle does.
Another way I have used is this: System A CF A DB A Caller A System B CF B DB B Stub B Install a CF Caller program on System A Install a CF Stub program on System B Caller A creates a SQL Query (with associated data as necessary) Instead of issuing the query, it serializes it into a WDDX packet. The WDDX packet is passed to Stub B via a cfhttp tag. Stub B ins invoked and receives the WDDX packet. It deserialiazes the WDDX packet and issues the SQL query against DB B Stub B then serializes the query results and returns them to Caller A. So, Caller A is able to execute queries against DB B. It is a simple matter for Caller A to copy data from DB A to DB B or vice versa. I use this all the time -- I have even used it to move complete databases between to remote hosts where I didn't have admin privileges on either host. Dick On Thursday, October 10, 2002, at 10:19 AM, Cornillon, Matthieu wrote: > 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
