On 03/02/2007 02:42:27 PM, Paula Stankus wrote:
> Here it is and if someone has a good solution let me know.
>
> I have inherited this database with multiple, multiple schemas.
>
> The schemas have views and the views access more schemas.
>
> The database is very large.
>
> I have about 10 development groups needing (per their request) 10 separate instances to develop on because they are in different phases of development.
>
> Refreshing the databases is a nightmare. Just when you thought you were done you need yet another underlying schema.
>
> I don't have enough space for 10 clones of prod (wish I did)
>
> Any suggestions???
Actually, yes. A long, long time in a galaxy far, far away I was working for an HMO and
had the same problem. The solution was found in a brilliant peace of software called
"Move4Servers" and produced by Princeton Softech. This software enabled me to extract
logically consistent subsets of the One Huge Database (the main database of the company,
which used to be known as "PULSE") and give them developers to develop. The baby databases
contained all the structure needed by a particular development group. It worked great and
I can really recommend the company. They're writing high quality software and have an
excellent technical support. The URL is: http://www.princetonsoftech.com
--
Mladen Gogala
http://www.mladen-gogala.com
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 02 2007 - 20:14:51 CST
