RE: copying db info with cf

2002-10-10 Thread Bryan Love
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]

Re: copying db info with cf

2002-10-10 Thread Dick Applebaum
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

RE: copying db info with cf

2002-10-10 Thread Cornillon, Matthieu
]] 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

Re: copying db info with cf

2002-10-10 Thread Cathy Taylor
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

Re: copying db info with cf

2002-10-10 Thread S . Isaac Dealey
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,

RE: copying db info with cf

2002-10-10 Thread Shawn Kernes
: 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

Re: copying db info with cf

2002-10-10 Thread Deanna Schneider
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

RE: copying db info with cf

2002-10-10 Thread Mosh Teitelbaum
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)

RE: copying db info with cf

2002-10-10 Thread Cornillon, Matthieu
: 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