Re: Dev Database Refresh Options

On Wed, 19 Jul 2006 18:05:05 -0400, meathammer wrote:

> 9iR2
>
> 1) What are the options (that you'd take) OTHER than "old" exp/imp
> to keep dev database as close to Production as possible ?
>
> 2) ..and now what if Prod is on Unix & Dev is on Windows ?
>
> thx

It depends on the nature of the development database. If it's a full copy of production, I'd use utilities that are meant to facilitate copying databases: imp/exp and RMAN. If it isn't, I'd try to get Princeton Softech Move4Servers or whatever it's called now. It's a stable, robust utility which can create logically consistent subset of the database, follow the foreign keys and do many thins.

-- 
http://www.mgogala.com