Why not just do a dump of the data from the development environment and import it into the other DBs? Granted, this is often considered a Bad Thing in place of importing a fresh schema complete with lookup data, but it sounds like it's what you're after.
-- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -----Original Message----- > From: Cornillon, Matthieu [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 10, 2002 1:20 PM > 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
