Login to the servers as the oracle user and do an 'exp' command (look it up for help, but I think that command alone will prompt you for the user/database you want to export). It'll create a binary file you can then 'imp' on the other servers after ftping them over. Well, this is how you do it on a Unix box anyway. The Windows version is probably similar, but gets at it a little differently. You didn't say what environment you have.
Cathy ----- Original Message ----- From: "Cornillon, Matthieu" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, October 10, 2002 1:19 PM 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
