um...replication? Is this an Oracle thing? I don't want to copy the whole DB, just parts of it. Certain tables, certain records. If this is Oracle, I can do more research on my own. Thanks for the lead, though.
Matthieu -----Original Message----- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 3:40 PM To: CF-Talk Subject: RE: copying db info with cf Why not just set up replication between the databases to keep them in sync? +-----------------------------------------------+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +-----------------------------------------------+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -----Original Message----- From: Cornillon, Matthieu [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 10:20 AM To: CF-Talk Subject: copying db info with cf 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
