Thanks to everyone that responded ... there was some very useful
information!
Susan
On Fri, May 15, 2009 at 9:15 AM, Guillaume Rheault guilla...@dcshq.comwrote:
**
I am in favor too of the database copy from production to test and even
development.
Copying a database between servers with
Susan,
The most effective way, in my opinion, is to restore a copy of the prod db,
then masage the data and start the test ar services. It will have all the data
from prod, well loaded system takes about 4-6 hours to restore, and then you do
the data masaging, that can be scripted as sql and
One thing to keep in mind is that the Licenses are now stored in the
database (since v7.1.0). Make sure that Production has ALL the server
licenses listed (so when you restore to Test or Dev the system will not
complain about licensing).
We have Dev, 2 Test, and Production systems and
I am in favor too of the database copy from production to test and even
development.
Copying a database between servers with Oracle is simple, your DBA should not
have any problem with that.
The other reason why I think that having a copy of production in dev and test
is to make sure that the
Hi Susan,
I have several dev servers that I keep up to date with various prod
servers. I use Misi's rrrChive program for doing that. It is free and
extremely useful for synchronising the data between two servers. It is
comand line and config file driven so it is easy to create various config
5 matches
Mail list logo