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]
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
]]
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
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
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,
: 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
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
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)
: 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
9 matches
Mail list logo