Thanks, everyone, for your feedback on this. Looks like some sort of Oracle-based operation is the way to go. I more or less just wanted to make sure that there was no easy and obvious CF solution that I was missing. Thanks again for your posts.
Matthieu -----Original Message----- From: Deanna Schneider [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 4:43 PM To: CF-Talk Subject: Re: copying db info with cf With Oracle, you can log in with sqlplus and do something like this: (Obviously, you'd have to fill in the schema names, passwords, instance names, table names, etc.) //disable all constraints MODIFY CONSTRAINT myconstraintname DISABLE; //disable any triggers that might fire ALTER TRIGGER mytrigger DISABLE; //delete old data from table you want to refill DELETE FROM myschema.mytable; //copy from the other instance and insert into this instance COPY FROM oldschemaname/password@instancename- TO newschemaname/password@instancename - INSERT tabletoinsertinto- USING SELECT * from schemaname.oldtablename; //reenable any triggers ALTER TRIGGER mytrigger ENABLE; //reenable any constraints ALTER TABLE mytable MODIFY CONSTRAINT myconstraint ENABLE; Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
